Stream Pre Market Trade Time

Streams the real-time timestamp of the most recent trade during pre-market (before hours) trading. This updates with each new pre-market trade.

Supported Symbol Formats

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

Notes

  • Data streams automatically update in Excel
  • Pre-market hours: 4:00 AM - 9:30 AM ET
  • Time is typically in Eastern Time (ET)

Examples

=QM_Stream_PreMarketTradeTime("AAPL")
Stream pre-market trade time for Apple
=QM_Stream_PreMarketTradeTime("MSFT")
Stream pre-market trade time for Microsoft
=QM_Stream_PreMarketTradeTime("TSLA")
Stream pre-market trade time for Tesla
=QM_Stream_PreMarketTradeTime(A1)
Symbol from cell reference

When to Use

  • Monitoring pre-market trade activity
  • Detecting stale before-hours quotes
  • Early morning trading analysis
  • Pre-market liquidity assessment

When NOT to Use

Scenario Use Instead
Need regular session trade time QM_Stream_LastTradeTime()
Need post-market trade time QM_Stream_PostMarketLastTradeTime()
Need general timestamp QM_Stream_Timestamp()
Need pre-market price QM_Stream_PreMarketLast()

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: Pre-market trading is less active than regular hours, so trades may be infrequent.

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

Related Functions