Stream Low Price
Streams the real-time session low price for stocks and ETFs. This represents the lowest 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
- Low resets at market open each day
- Use for OHLC (Open, High, Low, Close) data collection
Examples
=QM_Stream_Low("AAPL")=QM_Stream_Low("MSFT")=QM_Stream_Low("SPY")=QM_Stream_Low(A1)=QM_Stream_High("AAPL")-QM_Stream_Low("AAPL")When to Use
- Tracking intraday price range
- Building OHLC displays
- Identifying support levels
- Setting stop-loss alerts
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 52-week low | 52WeekLow() |
| Need historical low | Low_Historical() |
| Need on-demand low | QM_Low() |
| Need annual low indicator | QM_Stream_IsAnnualLow() |
Common Issues & FAQ
Q: Why does the low equal the open price? A: Early in the trading session, the low may equal the open until a lower 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?