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])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.
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?