Stream Post Market Change
Streams the real-time price change in dollars during post-market (after hours) trading. Post-market hours are typically 4:00 PM - 8:00 PM ET.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Data streams automatically update in Excel
- Post-market hours: 4:00 PM - 8:00 PM ET
- Change is calculated from the regular session close
Syntax
=QM_Stream_PostMarketChange(Symbol)Returns
number
Real-time streaming post-market price change in dollars
Examples
=QM_Stream_PostMarketChange("AAPL")=QM_Stream_PostMarketChange("MSFT")=QM_Stream_PostMarketChange("TSLA")Symbol from cell reference
When to Use
- After-hours trading monitoring
- Earnings reaction tracking
- Extended hours analysis
- Pre-open preparation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need regular session change | QM_Stream_Change() |
| Need post-market percent change | QM_Stream_PostMarketPercentChange() |
| Need pre-market change | QM_Stream_PreMarketChange() |
| Need post-market price | QM_Stream_PostMarketLast() |
Common Issues & FAQ
Why is the post-market change showing 0?
Post-market data is only available during extended hours (4:00 PM - 8:00 PM ET).
What is the change calculated from?
Post-market change is calculated from the regular session 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:
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?