DIVIDENDDATA_METRICS
What It Does
Retrieves a specific metric from financial statements. Allows targeted extraction of key financial figures like revenue, free cash flow, or EPS — either as the latest value or a historical table.
Why It's Useful
Sometimes you don't need a full financial statement — you just need one specific number. This function lets you pull exactly the metric you need for your model, watchlist, or dashboard. Perfect for building custom screens and valuation models.
Syntax
=DIVIDENDDATA_METRICS(symbol, metric, showHeaders, period, year)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | Yes | - | The specific financial metric |
showHeaders | No | FALSE | If TRUE, returns historical table; if FALSE, returns latest value |
period | No | "" | "annual", "quarter", or "ttm" |
year | No | "" | Specific year filter |
Available Metrics (100+)
Income Statement: Revenue, CostOfRevenue, GrossProfit, OperatingExpenses, OperatingIncome, NetIncome, Eps, EpsDiluted, Ebitda, Ebit, InterestExpense, DepreciationAndAmortization
Balance Sheet: CashAndCashEquivalents, TotalCurrentAssets, TotalAssets, TotalCurrentLiabilities, TotalLiabilities, TotalDebt, NetDebt, TotalStockholdersEquity, RetainedEarnings, Inventory, AccountsReceivables, AccountPayables
Cash Flow: OperatingCashFlow, CapitalExpenditure, FreeCashFlow, CommonDividendsPaid, CommonStockRepurchased, NetChangeInCash, NetCashProvidedByOperatingActivities, NetCashProvidedByInvestingActivities, NetCashProvidedByFinancingActivities
Examples
Get latest annual revenue:
=DIVIDENDDATA_METRICS("MSFT", "Revenue")Output: Latest revenue value (annual by default)
Get quarterly free cash flow history for 2024:
=DIVIDENDDATA_METRICS("AAPL", "FreeCashFlow", TRUE, "quarter", "2024")Output: Table with quarterly free cash flow for 2024
Get total debt:
=DIVIDENDDATA_METRICS("JNJ", "TotalDebt")Output: Latest total debt figure
Get dividends paid over time:
=DIVIDENDDATA_METRICS("KO", "CommonDividendsPaid", TRUE, "annual")Output: Historical table of annual dividend payments
Get TTM EPS:
=DIVIDENDDATA_METRICS("NVDA", "EpsDiluted", FALSE, "ttm")Output: Trailing twelve month diluted EPS