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

Syntax

=TargetPrice(Symbol, [ReturnType], [WeeksAgo])

Excel Desktop (Windows)

Returns

number

Consensus 12-month price target in USD

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

Which target price function should I use?

TargetPrice(), MeanTargetPrice(), and OneyrTargetPrice() return the same value. Use whichever name is clearest for your purpose.

Excel Templates Using Target Price

These ready-made MarketXLS templates call TargetPrice() in their worksheet formulas. Open one to see the function working inside a complete model.

Analyst and earnings functions template

Related Formulas

More MarketXLS Estimates formulas you can use in the same worksheet:

See TargetPrice used in a complete workbook: Streaming Stocks Earnings Tracker Excel: Q2 2026 Subscriber Growth and Margin Dashboard

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?