DIVIDENDDATA.RATIOS
What It Does
Retrieves financial ratios for valuation, profitability, liquidity, and leverage analysis.
Why It's Useful
Compare companies, assess financial health, and build valuation models with 50+ ratios.
Syntax
=DIVIDENDDATA.RATIOS(symbol, metric, [showHeaders], [period], [year])
Available Metrics
Valuation: PeRatio, PriceToSalesRatio, PbRatio, EnterpriseValueOverEBITDA
Profitability: GrossProfitMargin, NetProfitMargin, Roe, Roic
Liquidity: CurrentRatio, QuickRatio, CashRatio
Leverage: DebtToEquity, DebtToAssets, InterestCoverage
Examples
=DIVIDENDDATA.RATIOS("AAPL", "PeRatio")=DIVIDENDDATA.RATIOS("MSFT", "Roe")