Stream Last Trade Time

Streams the real-time timestamp of the most recent trade. This updates with each new trade execution.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Notes

  • Data streams automatically update in Excel
  • Time is typically in Eastern Time (ET)
  • Useful for monitoring trade activity and staleness

Examples

=QM_Stream_LastTradeTime("AAPL")
Stream last trade time for Apple
=QM_Stream_LastTradeTime("MSFT")
Stream last trade time for Microsoft
=QM_Stream_LastTradeTime("SPY")
Stream last trade time for SPY ETF
=QM_Stream_LastTradeTime(A1)
Symbol from cell reference

When to Use

  • Monitoring quote freshness
  • Detecting stale prices
  • Trade timing analysis
  • Market activity monitoring

When NOT to Use

Scenario Use Instead
Need pre-market trade time QM_Stream_PreMarketTradeTime()
Need post-market trade time QM_Stream_PostMarketLastTradeTime()
Need general timestamp QM_Stream_Timestamp()
Need last trade size QM_Stream_LastTradeSize()

Common Issues & FAQ

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

Q: Why hasn't the time updated? A: If no new trades occur, the time remains at the last trade. This is expected for low-volume stocks.

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

Related Functions