Stream Post Market Last Trade Time
Streams the real-time timestamp of the most recent trade during post-market (after hours) trading. This updates with each new post-market trade.
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
- Time is typically in Eastern Time (ET)
Syntax
=QM_Stream_PostMarketLastTradeTime(Symbol)Returns
datetime
Time of the last post-market trade
Examples
=QM_Stream_PostMarketLastTradeTime("AAPL")=QM_Stream_PostMarketLastTradeTime("MSFT")=QM_Stream_PostMarketLastTradeTime("TSLA")Symbol from cell reference
When to Use
- Monitoring post-market trade activity
- Detecting stale after-hours quotes
- Earnings reaction timing
- Extended hours analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need regular session trade time | QM_Stream_LastTradeTime() |
| Need pre-market trade time | QM_Stream_PreMarketTradeTime() |
| Need general timestamp | QM_Stream_Timestamp() |
| Need post-market price | QM_Stream_PostMarketLast() |
Common Issues & FAQ
What timezone is the time in?
Times are typically in Eastern Time (ET).
Why isn't the time updating?
Post-market trading is less active than regular hours, so trades may be infrequent.
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?