DIVIDENDDATA_RATIOS
What It Does
Retrieves a specific financial ratio or key metric for a stock. Returns either the latest value or a historical table for trend analysis.
Why It's Useful
Financial ratios are essential for valuation, comparing companies, and assessing financial health. Whether you need P/E ratios for a valuation model, current ratios for liquidity analysis, or ROE for profitability comparison — this function delivers 50+ ratios directly to your spreadsheet.
Syntax
=DIVIDENDDATA_RATIOS(symbol, metric, showHeaders, period, year)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | Yes | - | The ratio or key metric |
showHeaders | No | FALSE | If TRUE, returns historical table |
period | No | "" | "annual", "quarter", "ttm" |
year | No | "" | Specific year filter |
Available Metrics (50+)
Valuation: PeRatio, PriceToSalesRatio, PbRatio, PfcfRatio, EnterpriseValueOverEBITDA, EvToFreeCashFlow, EarningsYield, FreeCashFlowYield, MarketCap, EnterpriseValue
Profitability: GrossProfitMargin, OperatingProfitMargin, NetProfitMargin, Roe (Return on Equity), Roic (Return on Invested Capital), ReturnOnAssets
Liquidity: CurrentRatio, QuickRatio, CashRatio
Leverage: DebtToEquity, DebtToAssets, NetDebtToEBITDA, InterestCoverage
Efficiency: InventoryTurnover, ReceivablesTurnover, PayablesTurnover, DaysSalesOutstanding, DaysPayablesOutstanding
Dividends: DividendYield, PayoutRatio, DividendPayoutRatio
Per Share: RevenuePerShare, NetIncomePerShare, FreeCashFlowPerShare, BookValuePerShare, CashPerShare
Examples
Get P/E ratio:
=DIVIDENDDATA_RATIOS("MSFT", "PeRatio")Output: Latest P/E ratio
Get current ratio history:
=DIVIDENDDATA_RATIOS("AAPL", "CurrentRatio", TRUE, "annual")Output: Annual current ratio history table
Get return on equity:
=DIVIDENDDATA_RATIOS("JNJ", "Roe")Output: Latest ROE (e.g., 0.25 = 25%)
Get debt to equity:
=DIVIDENDDATA_RATIOS("T", "DebtToEquity")Output: Debt-to-equity ratio
Get dividend payout ratio:
=DIVIDENDDATA_RATIOS("VZ", "PayoutRatio")Output: Payout ratio (e.g., 0.58 = 58%)