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

Examples

=TargetPriceLow("AAPL")
Lowest analyst target for Apple
=TargetPriceLow("MSFT")
Lowest target for Microsoft
=Last("AAPL")-TargetPriceLow("AAPL")
Downside to low target

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

Q: Is low target a sell signal? A: 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
MarketXLS Excel Add-in Tutorial - How to Use Low Target Price and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions