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
Syntax
=QM_Stream_LastTradeTime(Symbol)Returns
datetime
Time of the last trade
Examples
=QM_Stream_LastTradeTime("AAPL")=QM_Stream_LastTradeTime("MSFT")=QM_Stream_LastTradeTime("SPY")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
What timezone is the time in?
Times are typically in Eastern Time (ET), the standard US market timezone.
Why hasn't the time updated?
If no new trades occur, the time remains at the last trade. This is expected for low-volume stocks.
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:
- Stream Last Trade Time
- Stream Low
- Stream Low Price
- Stream Mark
- Stream Mark Change
- Stream Mark Change Percent
- Stream Open
- Stream Open Interest
See QM_Stream_LastTradeTime used in a complete workbook: How to Insert Stock Price in Excel for Real-Time Quotes
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?