DIVIDENDDATA_GROWTH
What It Does
Retrieves a specific growth metric for financial figures. Returns growth rates like revenue growth, EPS growth, or dividend growth — either as the latest value or a historical table.
Why It's Useful
Growth is a key factor in stock valuation and dividend investing. This function helps you track how fast a company is growing its revenue, earnings, cash flow, and dividends over time. Essential for identifying compounding machines and assessing long-term dividend sustainability.
Syntax
=DIVIDENDDATA_GROWTH(symbol, metric, showHeaders, period, year)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | Yes | - | The growth metric |
showHeaders | No | FALSE | If TRUE, returns historical table |
period | No | "" | "annual", "quarter", "q1"-"q4", "fy" |
year | No | "" | Specific year filter |
Available Metrics
Income Growth: RevenueGrowth, GrossProfitGrowth, OperatingIncomeGrowth, NetIncomeGrowth, EbitdaGrowth
Per Share Growth: EpsGrowth, EpsDilutedGrowth, DividendsPerShareGrowth, BookValuePerShareGrowth
Cash Flow Growth: FreeCashFlowGrowth, OperatingCashFlowGrowth
Balance Sheet Growth: AssetGrowth, DebtGrowth, InventoryGrowth, ReceivablesGrowth
Multi-Year CAGRs: ThreeYRevenueGrowthPerShare, FiveYRevenueGrowthPerShare, TenYRevenueGrowthPerShare, ThreeYDividendPerShareGrowthPerShare, FiveYDividendPerShareGrowthPerShare, TenYDividendPerShareGrowthPerShare
Examples
Get latest revenue growth:
=DIVIDENDDATA_GROWTH("MSFT", "RevenueGrowth")Output: Latest revenue growth rate
Get quarterly EPS growth history:
=DIVIDENDDATA_GROWTH("AAPL", "EpsGrowth", TRUE, "quarter")Output: Quarterly EPS growth history table
Get dividend growth rate:
=DIVIDENDDATA_GROWTH("PG", "DividendsPerShareGrowth", TRUE, "annual")Output: Annual dividend growth history
Get 5-year revenue CAGR:
=DIVIDENDDATA_GROWTH("HD", "FiveYRevenueGrowthPerShare")Output: 5-year revenue CAGR per share
Check NVIDIA's explosive growth:
=DIVIDENDDATA_GROWTH("NVDA", "RevenueGrowth")Output: 1.26 (126% YoY growth)