High Target Price
Returns the highest (most bullish) price target among all analysts covering the stock. This represents the most optimistic view of the stock's potential.
Notes
- Represents the most bullish analyst view
- Compare with
TargetPriceMean()andTargetPriceLow()for range - Updated as analysts revise targets
Syntax
=TargetPriceHigh(Symbol, [ReturnType])Returns
number
Highest analyst price target in USD
Examples
=TargetPriceHigh("AAPL")=TargetPriceHigh("MSFT")=TargetPriceHigh("AAPL")-Last("AAPL")When to Use
- Understanding maximum analyst expectations
- Bull case scenario analysis
- Comparing against current price for upside potential
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need consensus target | TargetPriceMean() |
| Need lowest target | TargetPriceLow() |
| Need current price | Last() |
Common Issues & FAQ
Why is the high target so different from mean?
The high target reflects the most bullish analyst. Wide ranges between high and low indicate divergent analyst views.
Excel Templates Using High Target Price
These ready-made MarketXLS templates call TargetPriceHigh() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Previous Earnings Report Date
- Previous Earnings Report Time
- Price to EPS Estimate Current Year
- Price to EPS Estimate Next Year
- Quarterly Earnings Growth YoY
- 5-Year EPS Growth Rate
- Actual EPS
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
See TargetPriceHigh used in a complete workbook: Analyst Ratings MCP Server: Live Price Targets and Consensus in Excel and AI
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?