Stream Post Market Last Price
Streams the real-time last traded price 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
- Important for tracking earnings reactions and overnight moves
Syntax
=QM_Stream_PostMarketLast(Symbol)Returns
number
Real-time streaming post-market last traded price
Examples
=QM_Stream_PostMarketLast("AAPL")=QM_Stream_PostMarketLast("MSFT")=QM_Stream_PostMarketLast("TSLA")Symbol from cell reference
When to Use
- After-hours trading monitoring
- Earnings reaction tracking
- Extended hours analysis
- Overnight portfolio valuation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need regular session price | QM_Stream_Last() |
| Need pre-market price | QM_Stream_PreMarketLast() |
| Need post-market change | QM_Stream_PostMarketChange() |
| Need post-market volume | QM_Stream_PostMarketVolume() |
Common Issues & FAQ
Why is the post-market price the same as the close?
If no post-market trading has occurred, the price may still show the regular session close.
When is post-market data available?
Post-market hours are typically 4:00 PM - 8:00 PM ET.
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 Post Market Last Trade Time
- Stream Post Market Last Trade Time
- Stream Post Market Percent Change
- Stream Post Market Volume
- Stream Pre Market Change
- Stream Pre Market Change
- Stream Pre Market Last
- Stream Pre Market Percent Change
See QM_Stream_PostMarketLast used in a complete workbook: How to Insert Stock Price in Excel for Real-Time Quotes
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?