RATIOS

Get an extensive set of financial and accounting ratios for a given company over time.

Syntax

=OBB.EQUITY.FUNDAMENTAL.RATIOS(symbol,[period],[limit],[with_ttm])

Examples

=OBB.EQUITY.FUNDAMENTAL.RATIOS("AAPL")

=OBB.EQUITY.FUNDAMENTAL.RATIOS("AAPL","annual",12)

---

Parameters

Name	Type	Description	Required
symbol	Text	Symbol to get data for. Multiple comma separated items allowed.	True
period	Text	Time period of the data to return.	False
limit	Number	The number of data entries to return.	False
with_ttm	Boolean	Include trailing twelve months (TTM) data.	False

---

Data

• fmp

Name	Description
period_ending	The date of the data.
fiscal_period	Period of the financial ratios.
fiscal_year	Fiscal year.
symbol	Symbol representing the entity requested in the data.
current_ratio	Current ratio.
quick_ratio	Quick ratio.
cash_ratio	Cash ratio.
days_of_sales_outstanding	Days of sales outstanding.
days_of_inventory_outstanding	Days of inventory outstanding.
operating_cycle	Operating cycle.
days_of_payables_outstanding	Days of payables outstanding.
cash_conversion_cycle	Cash conversion cycle.
gross_profit_margin	Gross profit margin.
operating_profit_margin	Operating profit margin.
pretax_profit_margin	Pretax profit margin.
net_profit_margin	Net profit margin.
effective_tax_rate	Effective tax rate.
return_on_assets	Return on assets.
return_on_equity	Return on equity.
return_on_capital_employed	Return on capital employed.
net_income_per_ebt	Net income per EBT.
ebt_per_ebit	EBT per EBIT.
ebit_per_revenue	EBIT per revenue.
debt_ratio	Debt ratio.
debt_equity_ratio	Debt equity ratio.
long_term_debt_to_capitalization	Long term debt to capitalization.
total_debt_to_capitalization	Total debt to capitalization.
interest_coverage_ratio	Interest coverage.
cash_flow_to_debt	Cash flow to debt ratio.
company_equity_multiplier	Company equity multiplier.
receivables_turnover	Receivables turnover.
payables_turnover	Payables turnover.
inventory_turnover	Inventory turnover.
fixed_asset_turnover	Fixed asset turnover.
asset_turnover	Asset turnover.
operating_cash_flow_per_share	Operating cash flow per share.
free_cash_flow_per_share	Free cash flow per share.
cash_per_share	Cash per share.
payout_ratio	Payout ratio.
operating_cash_flow_sales_ratio	Operating cash flow sales ratio.
free_cash_flow_operating_cash_flow_ratio	Free cash flow operating cash flow ratio.
cash_flow_coverage_ratio	Cash flow coverage ratio.
short_term_coverage_ratio	Short term coverage ratio.
capital_expenditure_coverage_ratio	Capital expenditure coverage ratio.
price_book_value_ratio	Price book value ratio.
price_to_book_ratio	Price to book ratio.
price_to_sales_ratio	Price to sales ratio.
price_earnings_ratio	Price earnings ratio.
price_to_free_cash_flows_ratio	Price to free cash flows ratio.
price_to_operating_cash_flows_ratio	Price to operating cash flows ratio.
price_cash_flow_ratio	Price cash flow ratio.
price_earnings_to_growth_ratio	Price earnings to growth ratio.
price_sales_ratio	Price sales ratio.
dividend_paid_and_capex_coverage_ratio	Dividend paid and capex coverage ratio.
dividend_payout_ratio	Dividend payout ratio.
dividend_yield	Dividend yield.
dividend_per_share	Dividend per share.
enterprise_value_multiple	Enterprise value multiple.
price_fair_value	Price fair value.