Target Price Function

Overview

The TargetPrice function provides analyst consensus target prices for stocks. By default, it returns the current mean target price. You can optionally retrieve historical target prices from 1-3 weeks ago, or get the date of the most recent estimate. The ReturnType parameter accepts 'value' (default) or 'date', while WeeksAgo accepts 0 (current), -1, -2, or -3 for historical data.

Syntax

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

Parameters

• Symbol: Required - Stock ticker symbol (e.g., 'AAPL', 'MSFT') • ReturnType (optional): Optional - 'value' for numeric data or 'date' for date information • WeeksAgo (optional): Optional - 0 for current, -1 to -3 for historical weeks

Return Value

Type: Number/Date

Returns the mean analyst target price with optional historical lookback

Example Usage

Basic Example

=TargetPrice("MSFT") or =TargetPrice("MSFT", "value", -1)

Real-World Applications

1. Investment Analysis: Use TargetPrice to evaluate analyst sentiment and expectations for stocks in your portfolio.

2. Earnings Strategy: Incorporate this function into earnings-based trading strategies to identify opportunities.

3. Valuation Models: Essential input for various valuation models and financial analysis.

Common Use Cases

• Portfolio Monitoring: Track analyst estimates for all holdings
• Screening: Identify stocks with improving analyst sentiment
• Risk Management: Monitor earnings expectations to anticipate volatility
• Comparative Analysis: Compare estimates across peers and sectors

Best Practices

1. Always use valid stock symbols (ticker symbols)
2. Combine with other MarketXLS functions for comprehensive analysis
3. Regular updates ensure you have the latest analyst data
4. Consider using with conditional formatting for visual alerts

Related Functions

• Other earnings and estimate functions in the Analyst Estimates category
• Price and valuation functions for complete analysis
• Historical data functions for trend analysis

Notes

• Data is updated in real-time when markets are open
• Historical data availability may vary by symbol
• Requires valid MarketXLS subscription

Troubleshooting

If the function returns "NA" or an error:

1. Verify the stock symbol is correct
2. Ensure you have an active internet connection
3. Check that your MarketXLS license is valid
4. Some symbols may have limited analyst coverage

This function is part of the MarketXLS Excel Add-in suite for financial analysis and investment research.