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

Examples

=QM_Stream_PostMarketLast("AAPL")

Stream post-market price for Apple

=QM_Stream_PostMarketLast("MSFT")

Stream post-market price for Microsoft

=QM_Stream_PostMarketLast("TSLA")

Stream post-market price for Tesla

=QM_Stream_PostMarketLast(A1)

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

Q: Why is the post-market price the same as the close? A: If no post-market trading has occurred, the price may still show the regular session close.

Q: When is post-market data available? A: Post-market hours are typically 4:00 PM - 8:00 PM ET.

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

MarketXLS Excel Add-in Tutorial - How to Use Stream Post Market Last Price and Other Financial Formulas

▶

How does MarketXLS work?