DIVIDENDDATA_ESTIMATES
What It Does
Retrieves analyst estimates for earnings and revenue including summary tables, specific metric history (estimates vs actuals), or single next-year values for quick watchlist building.
Why It's Useful
Analyst estimates help you forecast future growth and assess whether a stock's valuation is justified. Use estimates to build forward P/E calculations, project future dividend capacity, and compare growth expectations across stocks.
Syntax
=DIVIDENDDATA_ESTIMATES(symbol, metric, period, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | No | "summary" | Estimate metric |
period | No | "annual" | "annual" or "quarter" |
showHeaders | No | TRUE | Include headers for tables |
Available Metrics
Metric | Description |
summary | Full table: Date, EPS Estimate, EPS Growth, Revenue Estimate, Revenue Growth, Analyst Counts |
eps | EPS estimates history (Date, Avg EPS Estimate, EPS Growth) |
revenue | Revenue estimates history (Date, Avg Revenue Estimate, Revenue Growth) |
next_year_eps | Single value: next year estimated EPS |
next_year_revenue | Single value: next year estimated revenue |
next_year_eps_growth | Single value: next year EPS growth % |
next_year_revenue_growth | Single value: next year revenue growth % |
Examples
Get full estimates summary:
=DIVIDENDDATA_ESTIMATES("MSFT", "summary")Output: Comprehensive table of future analyst estimates
Get next year's estimated EPS:
=DIVIDENDDATA_ESTIMATES("AAPL", "next_year_eps")Output: Single value (e.g., 7.25)
Get expected revenue growth:
=DIVIDENDDATA_ESTIMATES("NVDA", "next_year_revenue_growth")Output: Growth percentage (e.g., 0.45 = 45%)
Get quarterly revenue estimates:
=DIVIDENDDATA_ESTIMATES("AMZN", "revenue", "quarter")Output: Table with quarterly revenue estimates and growth
Build a forward P/E watchlist:
Combine with QUOTE function: =DIVIDENDDATA_QUOTE("AAPL","price") / DIVIDENDDATA_ESTIMATES("AAPL","next_year_eps")