DIVIDENDDATA_PRICE_TARGET
What It Does
Retrieves analyst price targets for a stock including consensus, high, low, and median targets, plus recent price target news.
Why It's Useful
Wall Street analyst opinions can provide context for whether a stock is overvalued or undervalued. Use price targets to gauge market expectations and compare them to your own valuation — especially useful when deciding to add to positions.
Syntax
=DIVIDENDDATA_PRICE_TARGET(symbol, metric, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | No | "summary" | Price target metric |
showHeaders | No | TRUE/FALSE | Include headers (defaults to TRUE for summary/news) |
Available Metrics
Metric | Description |
summary | Complete price target summary table |
consensus | Consensus (average) price target |
high | Highest analyst target |
low | Lowest analyst target |
median | Median price target |
news | Recent price target news table |
Examples
Get consensus price target:
=DIVIDENDDATA_PRICE_TARGET("AAPL", "consensus")Output: Average analyst price target
Get the analyst range:
=DIVIDENDDATA_PRICE_TARGET("TSLA", "high")=DIVIDENDDATA_PRICE_TARGET("TSLA", "low")Output: Highest and lowest analyst targets
Get full price target summary:
=DIVIDENDDATA_PRICE_TARGET("MSFT", "summary", TRUE)Output: Table with consensus, high, low, median, and analyst count
Get recent price target news:
=DIVIDENDDATA_PRICE_TARGET("GOOGL", "news", TRUE)Output: Recent analyst price target changes