Low Target Price
Returns the lowest (most bearish) price target among all analysts covering the stock. This represents the most conservative or pessimistic view.
Notes
- Represents the most bearish analyst view
- Useful for downside risk assessment
- Compare with mean and high for full range
Syntax
=TargetPriceLow(Symbol, [ReturnType])Returns
number
Lowest analyst price target in USD
Examples
=TargetPriceLow("AAPL")=TargetPriceLow("MSFT")=Last("AAPL")-TargetPriceLow("AAPL")When to Use
- Bear case scenario analysis
- Downside risk assessment
- Understanding analyst range of opinions
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need consensus target | TargetPriceMean() |
| Need highest target | TargetPriceHigh() |
Common Issues & FAQ
Is low target a sell signal?
Not necessarily. It's just one analyst's view. Consider the mean target and number of analysts for context.
Excel Templates Using Low Target Price
These ready-made MarketXLS templates call TargetPriceLow() 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:
- One Year Target Price (Analysts)
- 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
See TargetPriceLow 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?