Weird behavior

[nguyen-vh]

Hello,
I was testing the same behavior of this library for a project and noticed that when using a for-loop to iterate through the columns in this case, that sometimes it works and sometimes it doesn't.

After some testing, it seems that a 5 x 5 table (example1.csv) works, but other matrix combinations don't work most of the time (example2.csv).

A strange solution for example2.csv seems to be to simply add an empty row and the problem is solved.
Another solution is to keep the for-loop short so that the loop does not reach the last column but this is not what I want.

I have the code and csv files in text and attached to this question.

Can someone explain to me what is going on. It could be that I just missing the obvious.

Kind regards,
nguyen_vh

example1,C1,,,,C5
R1,1.8,"2,000.8",(2.7),"(3,000.6)",
R2,"3,000.8",2,6,10,14
R3,(3.7),3,7,11,15
R4,"(4,000.6)",4,8,12,16
R5,,5,9,13,17

example1.csv

example2,C1,,,,C5
R1,1.8,"2,000.8",(2.7),"(3,000.6)",,,,
R2,"3,000.8",2,6,10,14,,,
R3,(3.7),3,7,11,15,,,
R4,"(4,000.6)",4,8,12,16,,,
R5,,5,9,13,17,,,

example2.csv

example3,C1,,,,C5
R1,1.8,"2,000.8",(2.7),"(3,000.6)",,,,
R2,"3,000.8",2,6,10,14,,,
R3,(3.7),3,7,11,15,,,
R4,"(4,000.6)",4,8,12,16,,,
R5,,5,9,13,17,,,

example3.csv

#include <cstddef>
#include <iostream>
#include <string>
#include <vector>

#include "rapidcsv.h"

// Example 1, 2 or 3

const int EXAMPLE = 1;
// example = 1 -> ok
// example = 2 -> bad
// example = 3 -> ok

auto main(int /*argc*/, char* /*argv*/[]) -> int {
  //! TEST
  std::string document{};
  switch (EXAMPLE) {
    case 1:
      document = "example1.csv";
      break;

    case 2:
      document = "example2.csv";
      break;

    case 3:
      document = "example3.csv";
      break;

    default:
      break;
  }

  const rapidcsv::Document doc(document, rapidcsv::LabelParams(0, 0),
                               rapidcsv::SeparatorParams(),
                               rapidcsv::ConverterParams(true),
                               rapidcsv::LineReaderParams(false, '#', true));

  std::cout << "T E S T" << std::endl;
  std::cout << "\n";

  const size_t number_of_columns{doc.GetColumnCount()};
  std::cout << number_of_columns;

  std::cout << " x ";

  const size_t number_of_rows{doc.GetRowCount()};
  std::cout << number_of_rows << std::endl;
  std::cout << std::endl;

  for (int i{0}; i < (number_of_columns); ++i) {
    std::vector<std::string> current_column{doc.GetColumn<std::string>(i)};

    std::cout << "Loop: " << i << std::endl;

    const size_t num_of_columns{doc.GetColumnCount()};
    const size_t num_of_rows{doc.GetRowCount()};

    std::cout << "Columns: " << num_of_columns << " | Rows: " << num_of_rows
              << std::endl;

    std::cout << current_column[0] << " 0| " << current_column[1] << " 1| "
              << current_column[2] << " 2| " << current_column[3] << " 3| "
              << current_column[4] << " 4| " << current_column[5] << " 5| "
              << std::endl;

    std::cout << std::endl;
  }
  return 0;
}

example_test.cpp

[d99kris]

Hi @nguyen-vh - I'm getting identical output from your example_test.cpp program for EXAMPLE values 1, 2 and 3. Is that what you are expecting too? The first row in all these files have the same number of columns, and this will determine what GetColumnCount() returns.

Can I check which version of rapidcsv you are using (it can be found in the top file comment in rapidcsv.h)? If you're not using latest (8.82) it could be worth trying it (latest master, it's not available as release package yet).

[nguyen-vh]

Hey @d99kris,
I am using the newest version 8.82. I ran the program again but it doesn't reproduce the results I got yesterday.

I tried again abstracting my program to reproduce my error but failed.

I just give the file structure here:

Folder
   |-Database
   |        |-Stocks
   |               |-Germany
   |                       |-1SXP.DE
   |                       |       |-"1SXP.DE - Ratios.csv"
   |                       |
   |                       |-ADS.DE
   |                              |-"ADS.DE - Ratios.csv"
   |
   |-src
       |-rapidcsv.h
       |-Value.cpp 

When run the program it will ask for an input. Just write "Germany" and enter.
Then the loop will finish early and an error comes up.
When adding an empty line to the csv files the program runs.

The rapidcsv starts at line 166.

#include <algorithm>
#include <cstddef>
#include <filesystem>
#include <fstream>
#include <iostream>
#include <memory>
#include <string>
#include <unordered_map>
#include <utility>
#include <vector>

#include "rapidcsv.h"

// #define CSV_CORRECTION_ADD
// #define CSV_CORRECTION_SUB

#define DEBUG
// #define DEBUG2

#ifdef CSV_CORRECTION_ADD
auto add_new_line_to_file(const std::string& file_path) -> void {
  std::ofstream file(file_path, std::ios::app);
  if (!file.is_open()) {
    std::cerr << "Error opening file!\n";
  }
  file << "\n";
  file.close();
}
#endif

#ifdef CSV_CORRECTION_SUB
void removeLastNewline(const std::string& filePath) {
  std::ifstream inputFile(filePath);
  if (!inputFile.is_open()) {
    std::cerr << "Error opening input file: " << filePath << std::endl;
    return;
  }

  std::string fileContents;
  std::string line;
  while (std::getline(inputFile, line)) {
    fileContents += line + "\n";
  }
  inputFile.close();

  auto lastNewlinePos = fileContents.find_last_of('\n');

  if (lastNewlinePos != std::string::npos) {
    fileContents.erase(lastNewlinePos);

    std::ofstream outputFile(filePath);
    if (!outputFile.is_open()) {
      std::cerr << "Error opening output file: " << filePath << std::endl;
      return;
    }

    outputFile << fileContents;
    outputFile.close();
    std::cout << "Last newline removed successfully from file: " << filePath
              << std::endl;
  } else {
    std::cerr << "No newline found in the file: " << filePath << std::endl;
    return;
  }
}
#endif

auto clean_string(std::string& str) -> void {
  str.erase(std::remove(str.begin(), str.end(), ','),
            str.end());  // Remove commas
  str.erase(std::remove(str.begin(), str.end(), '('),
            str.end());  // Remove opening brackets
  str.erase(std::remove(str.begin(), str.end(), ')'),
            str.end());  // Remove closing brackets
  str.erase(std::remove(str.begin(), str.end(), '%'),
            str.end());  // Remove percentage
}

auto convert_string_to_date(const std::string& str) -> int {
  std::string date{str.substr(str.size() - 2)};
  int year{std::stoi(date)};

  return 2000 + year;
}

class Financials {
 public:
  // index = row number - 2

  // Ratios
  float roa{};                      // Return on Assets %
  float roc{};                      // Return on Capital %
  float roe{};                      // Return On Equity %
  float return_on_common_equity{};  // Return on Common Equity %
  float gross_profit_margin{};      // Gross Profit Margin %
  float sg_and_a_margin{};          // SG&A Margin %
  float ebitda_margin{};            // EBITDA Margin %
  float ebita_margin{};             // EBITA Margin %
  float ebit_margin{};              // EBIT Margin %
  float operating_margin{};   // Income From Continuing Operations Margin %
  float net_income_margin{};  // Net Income Margin %
  float normalized_net_income_margin{};     // Normalized Net Income Margin %
  float net_available_for_common_margin{};  // Net Avail. For Common Margin %
  float levered_fcf_margin{};               // Levered Free Cash Flow Margin %
  float unlevered_fcf_margin{};             // Unlevered Free Cash Flow Margin %
  float asset_turnover{};                   // Asset Turnover
  float fixed_assets_turnover{};            // Fixed Assets Turnover
  float receivables_turnover{};             // Receivables Turnover
  float inventory_turnover{};               // Inventory Turnover
  float working_capital_turnover{};         // Working Capital Turnover
  float current_ratio{};                    // Current Ratio
  float quick_ratio{};                      // Quick Ratio
  float operating_cash_flow_coverage_ratio{};  // Op Cash Flow to Current Liab
  float ccc{};                                 // Avg. Cash Conversion Cycle
  float dso{};                                 // Avg. Days Sales Outstanding
  float doi{};                                 // Days Outstanding Inventory
  float dpo{};                                 // Avg. Days Payable Outstanding
  float debt_to_equity_ratio{};                // Total Debt / Equity
  float debt_to_capital_ratio{};               // Total Debt / Capital
  float debt_to_asset_ratio{};             // Total Liabilities / Total Assets
  float icr{};                             // EBIT / Interest Expense
  float ebitda_coverage_ratio{};           // EBITDA / Interest Expense
  float adjusted_ebitda_coverage_ratio{};  //(EBITDA - Capex) / Interest Expense
  float leverage_ratio{};                  // Total Debt / EBITDA
  float net_debt_to_ebitda_ratio{};        // Net Debt / EBITDA
  float net_debt_to_ebitda_capex_ratio{};  // Net Debt / (EBITDA - Capex)

  // Income Statement
  float revenue{};  // Revenue

  // Cash Flow Statement

  // Balance Sheet
};

class Stock {
 public:
  Stock(const std::string& country, const std::string& stock_name)
      : m_country(country), m_stock_name(stock_name) {
    load_data_from_database();
  }

  virtual ~Stock() = default;

  // set
  void set_country(const std::string& country) { m_country = country; }
  void set_stock_name(const std::string& stock_name) {
    m_stock_name = stock_name;
  }

  // get
  auto get_country() const -> const std::string& { return m_country; }
  auto get_stock_name() const -> const std::string& { return m_stock_name; }
  auto get_financial_data() const
      -> const std::unordered_map<int, Financials>& {
    return m_financial_data;
  }

 private:
  std::string m_country{};
  std::string m_stock_name{};
  std::unordered_map<int, Financials> m_financial_data{};
  std::unordered_map<std::string, int> m_index_position;
  // Private function

  auto load_data_from_database() -> void {
    std::string csv_directory{"../Database/Stocks/" + m_country + "/" +
                              m_stock_name + "/" + m_stock_name +
                              " - Ratios.csv"};

#ifdef CSV_CORRECTION_ADD
    add_new_line_to_file(csv_directory);
#endif

#ifdef CSV_CORRECTION_SUB
    removeLastNewline(csv_directory);
#endif

    rapidcsv::Document document(csv_directory, rapidcsv::LabelParams(-1, -1),
                                rapidcsv::SeparatorParams(),
                                rapidcsv::ConverterParams(true),
                                rapidcsv::LineReaderParams(false, '#', true));

    const size_t number_of_columns{document.GetColumnCount()};
    const size_t number_of_rows{document.GetRowCount()};

#ifdef DEBUG
    std::cout << m_stock_name << std::endl;
    std::cout << number_of_columns << " x ";
    std::cout << number_of_rows << std::endl;
    std::cout << std::endl;
#endif

    std::vector<std::string> current_index = document.GetColumn<std::string>(0);
    for (int i = 1; i < number_of_rows; i++) {
      std::string metric_name{current_index[i]};
      m_index_position[metric_name] = i;
    }

    for (const auto& pair : m_index_position) {
      std::cout << "Key: " << pair.first << ", Value: " << pair.second
                << std::endl;
    }

    for (int i{1}; i < (number_of_columns); i++) {
      std::vector<std::string> current_column{
          document.GetColumn<std::string>(i)};

#ifdef DEBUG
      std::cout << "Loop: " << i
                << " | Year: " << convert_string_to_date(current_column[0])
                << std::endl;
      const size_t num_of_columns{document.GetColumnCount()};
      const size_t num_of_rows{document.GetRowCount()};
      std::cout << "Columns: " << num_of_columns << " | Rows: " << num_of_rows
                << std::endl;
      std::cout << current_column[0] << " 0| " << current_column[1] << " 1| "
                << current_column[2] << " 2| " << current_column[3] << " 3| "
                << current_column[4] << " 4| " << current_column[5] << " 5| "
                << std::endl;
      std::cout << std::endl;
#endif

      int current_year{convert_string_to_date(current_column[0])};

      Financials& financial_data_of_year{m_financial_data[current_year]};

      // Load Data of Stock into program
    }
  }
};

auto get_stock_names(const std::string& folder_path)
    -> std::vector<std::string> {
  const std::filesystem::path database_directory{"../Database/Stocks/" +
                                                 folder_path};

  std::vector<std::string> stock_names{};

  for (const auto& entry :
       std::filesystem::directory_iterator(database_directory)) {
    if (entry.is_directory()) {
      stock_names.push_back(entry.path().filename().string());
    }
  }

  return std::move(stock_names);
}

auto main(int /*argc*/, char* /*argv*/[]) -> int {
  std::vector<std::unique_ptr<Stock>> stocks{};

  std::string country{};
  std::cout << "Which country?" << std::endl;
  std::cout << "Germany: ";
  std::cin >> country;

  const std::vector<std::string> stock_names = get_stock_names(country);

  std::cout << "CHECK" << std::endl;

  for (const auto& stock_name : stock_names) {
    stocks.emplace_back(std::make_unique<Stock>(country, stock_name));
  }

#ifdef DEBUG2
  for (const auto& stock : stocks) {
    std::cout << "Country: " << stock->get_country()
              << ", Stock Name: " << stock->get_stock_name() << std::endl;
    for (const auto& [year, financials] : stock->get_financial_data()) {
      std::cout << "Year: " << year << std::endl;
      std::cout << "ROA: " << financials.roa << std::endl;
      std::cout << "ROC: " << financials.roc << std::endl;
      std::cout << "ROE: " << financials.roe << std::endl;
    }
    std::cout << std::endl;
  }
#endif

  return 0;
}

src/Value.cpp
src/rapidcsv.h

Date,9/30/20,9/30/21,9/30/22,9/30/23
Return Ratios:,,,,
Return on Assets %,,10.7%,10.8%,8.8%
Return on Capital %,21.9%,21.5%,18.2%,18.5%
Return On Equity %,,27.5%,22.3%,21.7%
Return on Common Equity %,,27.5%,22.3%,21.7%
Margin Analysis:,,,,
Gross Profit Margin %,33.5%,34.9%,36.1%,35.2%
SG&A Margin %,15.3%,14.3%,13.5%,13.7%
EBITDA Margin %,21.3%,23.3%,25.8%,24.8%
EBITA Margin %,16.1%,17.9%,20.6%,19.2%
EBIT Margin %,15.6%,17.7%,20.5%,19.1%
Income From Continuing Operations Margin %,13.3%,15.6%,15.3%,16.9%
Net Income Margin %,13.3%,15.5%,15.3%,16.9%
Normalized Net Income Margin %,10.1%,11.8%,12.8%,12.5%
Net Avail. For Common Margin %,13.3%,15.5%,15.3%,16.9%
Levered Free Cash Flow Margin %,,(3.3%),(24.6%),8.1%
Unlevered Free Cash Flow Margin %,,(3.2%),(24.4%),8.5%
Asset Turnover:,,,,
Asset Turnover,0.98,0.88,0.69,0.73
Fixed Assets Turnover,,2.16,1.93,1.56
Receivables Turnover,,4.61,4.69,4.25
Inventory Turnover,,5.76,4.94,4.35
Working Capital Turnover,20.06,11.19,3.55,7.67
Short Term Liquidity:,,,,
Current Ratio,1.14,1.24,1.72,1.33
Quick Ratio,0.77,0.80,0.80,0.79
Dividend Yield %,,,,
Op Cash Flow to Current Liab,0.50,0.54,0.56,0.52
Avg. Cash Conversion Cycle,,105.57,97.52,117.57
Avg. Days Sales Outstanding,,91.79,76.22,90.77
Avg. Days Outstanding Inventory,,73.41,72.44,88.79
Avg. Days Payable Outstanding,,59.63,51.14,61.99
Long-Term Solvency:,,,,
Total Debt / Equity,28.9%,24.0%,27.6%,30.3%
Total Debt / Capital,22.0%,18.9%,21.1%,22.6%
Total Liabilities / Total Assets,47.0%,43.3%,40.7%,43.8%
EBIT / Interest Expense,60.16,96.54,79.48,25.71
EBITDA / Interest Expense,82.47,127.27,100.19,33.49
(EBITDA - Capex) / Interest Expense,26.14,44.58,28.28,7.15
FFO Interest Coverage,,,,
FFO to Total Debt (x),,,,
Total Debt / EBITDA,0.73,0.67,0.92,0.94
Net Debt / EBITDA,0.58,0.48,0.78,0.82
Net Debt / (EBITDA - Capex),1.84,1.38,2.76,3.86
Industry Metrics:,,,,

Database/Stocks/Germany/1SXP.DE/1SXP.DE - Ratios.csv

Date,12/31/07,12/31/08,12/31/09,12/31/10,12/31/11,12/31/12,12/31/13,12/31/14,12/31/15,12/31/16,12/31/17,12/31/18,12/31/19,12/31/20,12/31/21,12/31/22
Return Ratios:,,,,,,,,,,,,,,,,
Return on Assets %,,,,,,,6.6%,5.1%,5.4%,6.5%,8.8%,10.2%,9.2%,2.2%,5.8%,2.2%
Return on Capital %,,,,,,,17.2%,12.4%,14.1%,17.6%,28.2%,28.8%,22.0%,5.8%,15.0%,6.1%
Return On Equity %,,,,,,,14.4%,10.2%,12.2%,17.9%,21.7%,27.6%,28.6%,6.7%,20.5%,3.9%
Return on Common Equity %,,,,,,,14.3%,10.0%,12.0%,17.8%,21.6%,27.5%,29.1%,6.8%,20.8%,3.6%
Margin Analysis:,,,,,,,,,,,,,,,,
Gross Profit Margin %,,,,,,,49.3%,47.6%,48.3%,49.2%,50.4%,51.9%,52.0%,50.0%,50.7%,47.5%
SG&A Margin %,,,,,,,41.5%,39.2%,39.5%,39.0%,40.5%,41.2%,41.0%,45.3%,41.5%,44.5%
EBITDA Margin %,,,,,,,10.3%,8.4%,8.2%,9.6%,11.5%,13.2%,13.6%,6.5%,11.8%,5.6%
EBITA Margin %,,,,,,,8.7%,6.7%,6.6%,8.1%,9.7%,13.2%,11.6%,4.6%,9.8%,3.7%
EBIT Margin %,,,,,,,8.7%,6.7%,6.6%,8.1%,9.7%,11.0%,11.3%,4.0%,9.4%,3.3%
Income From Continuing Operations Margin %,,,,,,,5.4%,3.9%,4.1%,5.8%,6.4%,7.8%,8.1%,2.5%,7.0%,1.1%
Net Income Margin %,,,,,,,5.5%,3.4%,3.7%,5.5%,5.2%,7.8%,8.4%,2.3%,10.0%,2.7%
Normalized Net Income Margin %,,,,,,,5.1%,4.0%,4.0%,4.9%,5.9%,6.9%,6.8%,1.9%,5.3%,1.1%
Net Avail. For Common Margin %,,,,,,,5.4%,3.8%,4.0%,5.8%,6.4%,7.8%,8.1%,2.4%,6.8%,1.0%
Levered Free Cash Flow Margin %,,,,,,,1.5%,(0.4%),5.4%,2.6%,6.3%,7.9%,9.3%,5.9%,2.6%,(0.7%)
Unlevered Free Cash Flow Margin %,,,,,,,1.8%,(0.1%),5.7%,2.9%,6.4%,8.0%,9.7%,6.4%,2.9%,(0.3%)
Asset Turnover:,,,,,,,,,,,,,,,,
Asset Turnover,,,,,,,1.22,1.17,1.27,1.22,1.51,1.40,1.14,0.88,0.96,1.11
Fixed Assets Turnover,,,,,,,12.18,10.80,10.94,10.40,10.84,10.34,6.26,3.72,4.51,4.61
Receivables Turnover,,,,,,,8.12,7.74,8.47,8.70,9.40,9.24,9.33,8.00,10.21,9.51
Inventory Turnover,,,,,,,2.81,2.95,3.10,2.73,2.82,2.96,03.01,2.17,2.49,2.37
Working Capital Turnover,,,,,,,6.68,4.90,7.93,8.71,09.01,7.36,10.84,5.54,4.26,9.10
Short Term Liquidity:,,,,,,,,,,,,,,,,
Current Ratio,,,,,,,1.45,1.68,1.40,1.31,1.37,1.44,1.25,1.38,1.56,1.27
Quick Ratio,,,,,,,0.77,0.88,0.69,0.59,0.70,0.79,0.66,0.76,0.77,0.48
Dividend Yield %,,,,,,,,,,,,,,,,
Op Cash Flow to Current Liab,,,,,,,0.13,0.16,0.20,0.20,0.26,0.39,0.32,0.17,0.36,(0.06)
Avg. Cash Conversion Cycle,,,,,,,116.94,104.47,96.53,98.65,108.10,99.93,94.31,142.18,110.95,132.40
Avg. Days Sales Outstanding,,,,,,,61.88,57.07,46.81,44.28,46.59,45.25,43.90,55.90,40.67,41.10
Avg. Days Outstanding Inventory,,,,,,,178.67,149.78,127.77,141.15,155.25,141.41,135.85,205.81,166.78,165.07
Avg. Days Payable Outstanding,,,,,,,123.61,102.38,78.05,86.77,93.74,86.73,85.44,119.53,96.51,73.77
Long-Term Solvency:,,,,,,,,,,,,,,,,
Total Debt / Equity,,,,,,,24.6%,33.5%,32.5%,25.2%,18.7%,27.7%,67.6%,88.0%,68.0%,120.7%
Total Debt / Capital,,,,,,,18.8%,23.9%,23.4%,19.2%,15.3%,21.1%,39.4%,45.9%,40.1%,54.1%
Total Liabilities / Total Assets,,,,,,,52.7%,54.8%,57.7%,57.5%,57.1%,59.2%,65.9%,68.2%,64.6%,73.6%
EBIT / Interest Expense,,,,,,,16.90,15.73,17.08,21.27,33.32,57.33,16.66,4.75,17.97,5.34
EBITDA / Interest Expense,,,,,,,20.08,19.81,21.37,25.37,39.35,69.00,24.10,12.03,28.26,14.26
(EBITDA - Capex) / Interest Expense,,,,,,,14.30,11.76,14.23,17.11,28.42,54.45,20.36,9.67,23.81,10.58
FFO Interest Coverage,,,,,,,,,,,,,,,,
FFO to Total Debt (x),,,,,,,,,,,,,,,,
Total Debt / EBITDA,,,,,,,0.92,1.53,1.32,0.91,0.46,0.61,1.24,3.14,1.70,3.31
Net Debt / EBITDA,,,,,,,(0.19),0.16,0.34,0.06,(0.20),(0.30),0.59,0.98,0.46,2.86
Net Debt / (EBITDA - Capex),,,,,,,(0.27),0.27,0.51,0.09,(0.27),(0.38),0.69,1.22,0.54,3.85
Industry Metrics:,,,,,,,,,,,,,,,,

Database/Stocks/Germany/ADS.DE/ADS.DE - Ratios.csv

[d99kris]

I'm not seeing any error when running the above program with the provided csv files. The output I see is:

$ ./Value.cpp 
Which country?
Germany: Germany
CHECK
1SXP.DE
5 x 46

Key: Industry Metrics:, Value: 45
Key: EBIT / Interest Expense, Value: 37
Key: FFO to Total Debt (x), Value: 41
Key: Total Liabilities / Total Assets, Value: 36
Key: Total Debt / Equity, Value: 34
Key: Long-Term Solvency:, Value: 33
Key: Avg. Days Payable Outstanding, Value: 32
Key: Quick Ratio, Value: 26
Key: Avg. Days Sales Outstanding, Value: 30
Key: Current Ratio, Value: 25
Key: Op Cash Flow to Current Liab, Value: 28
Key: Short Term Liquidity:, Value: 24
Key: FFO Interest Coverage, Value: 40
Key: Avg. Days Outstanding Inventory, Value: 31
Key: Working Capital Turnover, Value: 23
Key: Net Debt / EBITDA, Value: 43
Key: Unlevered Free Cash Flow Margin %, Value: 17
Key: Receivables Turnover, Value: 21
Key: Net Debt / (EBITDA - Capex), Value: 44
Key: (EBITDA - Capex) / Interest Expense, Value: 39
Key: Levered Free Cash Flow Margin %, Value: 16
Key: Fixed Assets Turnover, Value: 20
Key: Asset Turnover, Value: 19
Key: Net Avail. For Common Margin %, Value: 15
Key: Income From Continuing Operations Margin %, Value: 12
Key: Net Income Margin %, Value: 13
Key: Normalized Net Income Margin %, Value: 14
Key: SG&A Margin %, Value: 8
Key: Return on Assets %, Value: 2
Key: Total Debt / Capital, Value: 35
Key: Return on Capital %, Value: 3
Key: EBIT Margin %, Value: 11
Key: Avg. Cash Conversion Cycle, Value: 29
Key: Dividend Yield %, Value: 27
Key: EBITA Margin %, Value: 10
Key: Gross Profit Margin %, Value: 7
Key: Margin Analysis:, Value: 6
Key: Total Debt / EBITDA, Value: 42
Key: Return On Equity %, Value: 4
Key: Asset Turnover:, Value: 18
Key: EBITDA / Interest Expense, Value: 38
Key: Return on Common Equity %, Value: 5
Key: Inventory Turnover, Value: 22
Key: EBITDA Margin %, Value: 9
Key: Return Ratios:, Value: 1
Loop: 1 | Year: 2020
Columns: 5 | Rows: 46
9/30/20 0|  1|  2| 21.9% 3|  4|  5| 

Loop: 2 | Year: 2021
Columns: 5 | Rows: 46
9/30/21 0|  1| 10.7% 2| 21.5% 3| 27.5% 4| 27.5% 5| 

Loop: 3 | Year: 2022
Columns: 5 | Rows: 46
9/30/22 0|  1| 10.8% 2| 18.2% 3| 22.3% 4| 22.3% 5| 

Loop: 4 | Year: 2023
Columns: 5 | Rows: 46
9/30/23 0|  1| 8.8% 2| 18.5% 3| 21.7% 4| 21.7% 5| 

ADS.DE
17 x 46

Key: Industry Metrics:, Value: 45
Key: EBIT / Interest Expense, Value: 37
Key: FFO to Total Debt (x), Value: 41
Key: Total Liabilities / Total Assets, Value: 36
Key: Total Debt / Equity, Value: 34
Key: Long-Term Solvency:, Value: 33
Key: Avg. Days Payable Outstanding, Value: 32
Key: Quick Ratio, Value: 26
Key: Avg. Days Sales Outstanding, Value: 30
Key: Current Ratio, Value: 25
Key: Op Cash Flow to Current Liab, Value: 28
Key: Short Term Liquidity:, Value: 24
Key: FFO Interest Coverage, Value: 40
Key: Avg. Days Outstanding Inventory, Value: 31
Key: Working Capital Turnover, Value: 23
Key: Net Debt / EBITDA, Value: 43
Key: Unlevered Free Cash Flow Margin %, Value: 17
Key: Receivables Turnover, Value: 21
Key: Net Debt / (EBITDA - Capex), Value: 44
Key: (EBITDA - Capex) / Interest Expense, Value: 39
Key: Levered Free Cash Flow Margin %, Value: 16
Key: Fixed Assets Turnover, Value: 20
Key: Asset Turnover, Value: 19
Key: Net Avail. For Common Margin %, Value: 15
Key: Income From Continuing Operations Margin %, Value: 12
Key: Net Income Margin %, Value: 13
Key: Normalized Net Income Margin %, Value: 14
Key: SG&A Margin %, Value: 8
Key: Return on Assets %, Value: 2
Key: Total Debt / Capital, Value: 35
Key: Return on Capital %, Value: 3
Key: EBIT Margin %, Value: 11
Key: Avg. Cash Conversion Cycle, Value: 29
Key: Dividend Yield %, Value: 27
Key: EBITA Margin %, Value: 10
Key: Gross Profit Margin %, Value: 7
Key: Margin Analysis:, Value: 6
Key: Total Debt / EBITDA, Value: 42
Key: Return On Equity %, Value: 4
Key: Asset Turnover:, Value: 18
Key: EBITDA / Interest Expense, Value: 38
Key: Return on Common Equity %, Value: 5
Key: Inventory Turnover, Value: 22
Key: EBITDA Margin %, Value: 9
Key: Return Ratios:, Value: 1
Loop: 1 | Year: 2007
Columns: 17 | Rows: 46
12/31/07 0|  1|  2|  3|  4|  5| 

Loop: 2 | Year: 2008
Columns: 17 | Rows: 46
12/31/08 0|  1|  2|  3|  4|  5| 

Loop: 3 | Year: 2009
Columns: 17 | Rows: 46
12/31/09 0|  1|  2|  3|  4|  5| 

Loop: 4 | Year: 2010
Columns: 17 | Rows: 46
12/31/10 0|  1|  2|  3|  4|  5| 

Loop: 5 | Year: 2011
Columns: 17 | Rows: 46
12/31/11 0|  1|  2|  3|  4|  5| 

Loop: 6 | Year: 2012
Columns: 17 | Rows: 46
12/31/12 0|  1|  2|  3|  4|  5| 

Loop: 7 | Year: 2013
Columns: 17 | Rows: 46
12/31/13 0|  1| 6.6% 2| 17.2% 3| 14.4% 4| 14.3% 5| 

Loop: 8 | Year: 2014
Columns: 17 | Rows: 46
12/31/14 0|  1| 5.1% 2| 12.4% 3| 10.2% 4| 10.0% 5| 

Loop: 9 | Year: 2015
Columns: 17 | Rows: 46
12/31/15 0|  1| 5.4% 2| 14.1% 3| 12.2% 4| 12.0% 5| 

Loop: 10 | Year: 2016
Columns: 17 | Rows: 46
12/31/16 0|  1| 6.5% 2| 17.6% 3| 17.9% 4| 17.8% 5| 

Loop: 11 | Year: 2017
Columns: 17 | Rows: 46
12/31/17 0|  1| 8.8% 2| 28.2% 3| 21.7% 4| 21.6% 5| 

Loop: 12 | Year: 2018
Columns: 17 | Rows: 46
12/31/18 0|  1| 10.2% 2| 28.8% 3| 27.6% 4| 27.5% 5| 

Loop: 13 | Year: 2019
Columns: 17 | Rows: 46
12/31/19 0|  1| 9.2% 2| 22.0% 3| 28.6% 4| 29.1% 5| 

Loop: 14 | Year: 2020
Columns: 17 | Rows: 46
12/31/20 0|  1| 2.2% 2| 5.8% 3| 6.7% 4| 6.8% 5| 

Loop: 15 | Year: 2021
Columns: 17 | Rows: 46
12/31/21 0|  1| 5.8% 2| 15.0% 3| 20.5% 4| 20.8% 5| 

Loop: 16 | Year: 2022
Columns: 17 | Rows: 46
12/31/22 0|  1| 2.2% 2| 6.1% 3| 3.9% 4| 3.6% 5| 

Please share the output you see and what you consider being the error, thanks.

[d99kris]

I will proceed to close this discussion for now, feel free to re-open it for any follow-up discussion.