Target Price

Returns the consensus analyst price target for a stock with historical data support. This is the average 12-month price target from covering analysts.

Notes

Same core value as TargetPriceMean() and OneyrTargetPrice()
May include historical target tracking
Most commonly used target price function

Examples

=TargetPrice("AAPL")

Price target for Apple

=TargetPrice("MSFT")

Price target for Microsoft

=(TargetPrice("AAPL")-Last("AAPL"))/Last("AAPL")*100

Upside %

When to Use

Getting analyst price expectations
Calculating potential upside/downside
Stock screening by analyst targets

When NOT to Use

Scenario	Use Instead
Need high/low range	`TargetPriceHigh()` / `TargetPriceLow()`
Need number of analysts	`AnalystConsensus()`

Common Issues & FAQ

Q: Which target price function should I use? A: TargetPrice(), MeanTargetPrice(), and OneyrTargetPrice() return the same value. Use whichever name is clearest for your purpose.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

MarketXLS Excel Add-in Tutorial - How to Use Target Price and Other Financial Formulas

▶

How does MarketXLS work?