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)

Examples

=QM_Stream_PostMarketLastTradeTime("AAPL")
Stream post-market trade time for Apple
=QM_Stream_PostMarketLastTradeTime("MSFT")
Stream post-market trade time for Microsoft
=QM_Stream_PostMarketLastTradeTime("TSLA")
Stream post-market trade time for Tesla
=QM_Stream_PostMarketLastTradeTime(A1)
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

Q: What timezone is the time in? A: Times are typically in Eastern Time (ET).

Q: Why isn't the time updating? A: Post-market trading is less active than regular hours, so trades may be infrequent.

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 Trade Time and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions