Stream Is Annual Low
Streams a real-time boolean indicator showing whether the stock is currently trading at its 52-week (annual) low. Returns TRUE if at or near the annual low, FALSE otherwise.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Data streams automatically update in Excel
- Useful for identifying oversold conditions
- Combine with
QM_Stream_IsAnnualHigh()for range analysis
Syntax
=QM_Stream_IsAnnualLow(Symbol)Returns
boolean
TRUE if stock is at 52-week low, FALSE otherwise
Examples
=QM_Stream_IsAnnualLow("AAPL")=QM_Stream_IsAnnualLow("MSFT")Symbol from cell reference
=IF(QM_Stream_IsAnnualLow("AAPL"),"NEW LOW","Not at low")When to Use
- Screening for stocks at new lows
- Identifying potential value opportunities
- Contrarian investment signals
- Risk monitoring
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need actual 52-week low price | 52WeekLow() |
| Need annual high indicator | QM_Stream_IsAnnualHigh() |
| Need session low price | QM_Stream_Low() |
| Need historical low | Low_Historical() |
Common Issues & FAQ
What counts as "annual low"?
This typically means the stock is at or very near its 52-week low price.
How do I get the actual low price?
Use 52WeekLow() to get the actual 52-week low price value.
Why am I getting #N/A?
Check that symbol format is correct.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
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?