DIVIDENDDATA_STATEMENT
What It Does
Retrieves full financial statements for a stock — income statements, balance sheets, or cash flow statements. Supports filtering by period (annual, quarterly, TTM) and year.
Why It's Useful
For in-depth fundamental analysis, you need access to complete financial statements. Whether you're building a DCF model, analyzing a company's debt levels, or tracking cash flow trends, this function gives you the raw financial data you need directly in your spreadsheet.
Syntax
=DIVIDENDDATA_STATEMENT(symbol, metric, showHeaders, period, year)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol (e.g., "MSFT") |
metric | Yes | - | Statement type: "income", "balance", or "cash_flow" |
showHeaders | No | FALSE | Include header row |
period | No | "" | "FY", "Q1", "Q2", "Q3", "Q4", "annual", "quarter", or "ttm" |
year | No | "" | Specific year to filter (e.g., 2024) |
Statement Types
Metric | Description |
income | Income statement (Revenue, Gross Profit, Operating Income, Net Income, EPS, etc.) |
balance | Balance sheet (Assets, Liabilities, Equity, Cash, Debt, etc.) |
cash_flow | Cash flow statement (Operating Cash Flow, CapEx, Free Cash Flow, Dividends Paid, etc.) |
Examples
Get annual income statement for 2024:
=DIVIDENDDATA_STATEMENT("MSFT", "income", TRUE, "annual", "2024")Output: Income statement table for 2024 with headers
Get TTM cash flow statement:
=DIVIDENDDATA_STATEMENT("AAPL", "cash_flow", FALSE, "ttm")Output: TTM cash flow statement without headers
Get Q4 balance sheet:
=DIVIDENDDATA_STATEMENT("AMZN", "balance", TRUE, "Q4", "2024")Output: Q4 2024 balance sheet with Total Assets, Liabilities, Cash, Debt, Shareholders Equity
Get all quarterly income statements:
=DIVIDENDDATA_STATEMENT("NVDA", "income", TRUE, "quarter")Output: All quarterly income statements