DIVIDENDDATA.STATEMENT
What It Does
Retrieves full financial statements — income statements, balance sheets, or cash flow statements.
Why It's Useful
Access complete financial data for DCF models, debt analysis, and cash flow tracking.
Syntax
=DIVIDENDDATA.STATEMENT(symbol, metric, [showHeaders], [period], [year])
Parameters
symbol (required): Stock ticker
metric (required): income, balance, or cash_flow
period: FY, Q1-Q4, annual, quarter, ttm
year: Specific year (e.g., 2024)
Examples
=DIVIDENDDATA.STATEMENT("AAPL", "income", TRUE, "annual", 2024)=DIVIDENDDATA.STATEMENT("MSFT", "cash_flow", TRUE, "ttm")