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)
Syntax
=QM_Stream_PreMarketTradeTime(Symbol)Returns
datetime
Time of the last pre-market trade
Examples
=QM_Stream_PreMarketTradeTime("AAPL")=QM_Stream_PreMarketTradeTime("MSFT")=QM_Stream_PreMarketTradeTime("TSLA")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
What timezone is the time in?
Times are typically in Eastern Time (ET).
Why isn't the time updating?
Pre-market trading is less active than regular hours, so trades may be infrequent.
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?