DIVIDENDDATA.METRICS
What It Does
Retrieves specific financial metrics like revenue, EPS, or free cash flow.
Why It's Useful
Pull exactly the data you need for custom models and dashboards.
Syntax
=DIVIDENDDATA.METRICS(symbol, metric, [showHeaders], [period], [year])
Available Metrics (100+)
Income: Revenue, GrossProfit, OperatingIncome, NetIncome, Eps, Ebitda
Balance: TotalAssets, TotalDebt, CashAndCashEquivalents, TotalStockholdersEquity
Cash Flow: OperatingCashFlow, FreeCashFlow, CapitalExpenditure, CommonDividendsPaid
Examples
=DIVIDENDDATA.METRICS("NVDA", "Revenue")=DIVIDENDDATA.METRICS("AAPL", "FreeCashFlow", TRUE, "annual")