Stream Is Annual High
Streams a real-time boolean indicator showing whether the stock is currently trading at its 52-week (annual) high. Returns TRUE if at or near the annual high, 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 screening stocks making new highs
- Combine with
QM_Stream_IsAnnualLow()for range analysis
Examples
=QM_Stream_IsAnnualHigh("AAPL")=QM_Stream_IsAnnualHigh("MSFT")Symbol from cell reference
=IF(QM_Stream_IsAnnualHigh("AAPL"),"NEW HIGH","Not at high")When to Use
- Screening for stocks at new highs
- Building breakout alerts
- Momentum strategy signals
- Market strength analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need actual 52-week high price | 52WeekHigh() |
| Need annual low indicator | QM_Stream_IsAnnualLow() |
| Need session high price | QM_Stream_High() |
| Need historical high | High_Historical() |
Common Issues & FAQ
Q: What counts as "annual high"? A: This typically means the stock is at or very near its 52-week high price.
Q: How do I get the actual high price?
A: Use 52WeekHigh() to get the actual 52-week high price value.
Q: Why am I getting #N/A? A: Check that symbol format is correct.
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?