One Year Target Price (Analysts)
Returns the consensus analyst 12-month price target for a stock. This is typically the same as TargetPriceMean().
Notes
- Same value as TargetPriceMean() in most cases
- Represents 12-month forward expectation
- Based on analyst consensus
Syntax
=OneyrTargetPrice(Symbol)Examples
=OneyrTargetPrice("AAPL")=OneyrTargetPrice("MSFT")When to Use
- Getting analyst price expectations
- Calculating implied upside
- Same use cases as TargetPriceMean()
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need high/low range | TargetPriceHigh() / TargetPriceLow() |
| Need current price | Last() |
Common Issues & FAQ
How is this different from MeanTargetPrice?
They typically return the same value - the consensus 12-month price target.
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
- Analyst Consensus
See OneyrTargetPrice 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?