Stream High Price
Streams the real-time session high price for stocks and ETFs. This represents the highest price the security has traded at during the current trading session.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
| Options | OCC Symbol | AAPL240315C00170000 |
Notes
- Data streams automatically update in Excel
- High resets at market open each day
- Use for OHLC (Open, High, Low, Close) data collection
Examples
=QM_Stream_High("AAPL")=QM_Stream_High("MSFT")=QM_Stream_High("SPY")=QM_Stream_High(A1)=QM_Stream_High("AAPL")-QM_Stream_Low("AAPL")When to Use
- Tracking intraday price range
- Building OHLC displays
- Identifying breakout levels
- Setting price alerts
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 52-week high | 52WeekHigh() |
| Need historical high | High_Historical() |
| Need on-demand high | QM_High() |
| Need annual high indicator | QM_Stream_IsAnnualHigh() |
Common Issues & FAQ
Q: Why does the high equal the open price? A: Early in the trading session, the high may equal the open until a higher price is traded.
Q: How do I calculate the daily range?
A: Use =QM_Stream_High("AAPL")-QM_Stream_Low("AAPL").
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?