Stream Open Price
Streams the real-time session open price for stocks and ETFs. This represents the first traded price when the market opened for the current 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
- Open price is set at market open (9:30 AM ET)
- Use for OHLC (Open, High, Low, Close) data collection
Examples
=QM_Stream_Open("AAPL")=QM_Stream_Open("MSFT")=QM_Stream_Open("SPY")=QM_Stream_Open(A1)=QM_Stream_Last("AAPL")-QM_Stream_Open("AAPL")When to Use
- Gap analysis (comparing open to previous close)
- OHLC data collection
- Opening range breakout strategies
- Intraday trading analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need on-demand open | QM_Open() |
| Need historical open | Open_Historical() |
| Need current price | QM_Stream_Last() |
| Need previous close | QM_Stream_PreviousClose() |
Common Issues & FAQ
Q: Why is the open price showing as 0 before market open? A: The open price is set when the first trade occurs at market open (9:30 AM ET).
Q: How do I calculate the gap from previous close?
A: Use =QM_Stream_Open("AAPL")-QM_Stream_PreviousClose("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?