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
Syntax
=QM_Stream_Close(Symbol)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
What's the difference between Close and Last?
During market hours, they're often the same. Close is the official session closing price, while Last is the most recent trade.
What's the difference between Close and PreviousClose?
Close is today's closing price, PreviousClose is yesterday's closing price.
Why am I getting #N/A?
Check that symbol format is correct.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
- Stream Currency Id
- Stream Data from QM Data Bundles
- Stream Delta
- Stream Excode
- Stream Extrinsic Value
- Stream Gamma
- Stream High
- Stream Implied Volatility
See QM_Stream_Close used in a complete workbook: Real Time Futures Prices in Excel: Live Streaming Data with MarketXLS 2025
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?