Open Price (On Demand)
Gets today's opening price on-demand (snapshot) from QuoteMedia. The opening price is the first traded price when the market opened.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Returns a snapshot (does not auto-update)
- Open is set at market open (9:30 AM ET)
- Useful for gap analysis
Examples
When to Use
- Static OHLC reports
- Gap analysis (open vs previous close)
- When streaming is not needed
- Snapshot reports
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need streaming open | QM_Stream_Open() |
| Need historical open | Open_Historical() |
| Need current price | QM_Last() |
Common Issues & FAQ
Q: Why is the open showing 0 before market open? A: The open is only set after the first trade at market open (9:30 AM ET).
Q: How do I calculate the gap?
A: Use =QM_Open("AAPL")-QM_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?