Stream Close Price
Streams the real-time close price for stocks and ETFs. During market hours, this typically reflects the most recent trading price. After market close, it shows the official closing price.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Data streams automatically update in Excel
- During trading hours, close may equal the last traded price
- Use
QM_Stream_PreviousClose()for yesterday's closing price
Examples
=QM_Stream_Close("AAPL")=QM_Stream_Close("MSFT")=QM_Stream_Close("SPY")=QM_Stream_Close(A1)When to Use
- End of day price tracking
- OHLC data collection
- Daily price analysis
- Portfolio valuation at close
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need previous day's close | QM_Stream_PreviousClose() |
| Need current last price | QM_Stream_Last() |
| Need historical close | Close_Historical() |
| Need open price | QM_Stream_Open() |
Common Issues & FAQ
Q: What's the difference between Close and Last? A: During market hours, they're often the same. Close is the official session closing price, while Last is the most recent trade.
Q: What's the difference between Close and PreviousClose? A: Close is today's closing price, PreviousClose is yesterday's closing price.
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?