Stream Previous Close
Streams the previous trading day's closing price for stocks and ETFs. This is the reference price used to calculate daily change and percentage change.
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
- Used as baseline for calculating daily change
- Important for gap analysis
Examples
=QM_Stream_PreviousClose("AAPL")=QM_Stream_PreviousClose("MSFT")=QM_Stream_PreviousClose("SPY")Symbol from cell reference
=QM_Stream_Last("AAPL")-QM_Stream_PreviousClose("AAPL")When to Use
- Calculating daily price change
- Gap analysis (comparing open to previous close)
- Percentage change calculations
- Reference price for comparison
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current/today's close | QM_Stream_Close() |
| Need on-demand previous close | QM_PreviousClose() |
| Need historical close on date | Close_Historical() |
| Need current price | QM_Stream_Last() |
Common Issues & FAQ
Q: What is "previous close"? A: The official closing price from the most recent completed trading session (typically yesterday).
Q: Why use previous close instead of close? A: Previous close is the reference for calculating today's change; close is today's closing price.
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?