Stream Timestamp
Streams the real-time timestamp of the most recent quote update for a symbol. This indicates how fresh the streaming data is.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
| Options | OCC Symbol | AAPL240315C00170000 |
Notes
- Data streams automatically update in Excel
- Time is typically in Eastern Time (ET)
- Useful for monitoring data freshness
Syntax
=QM_Stream_Timestamp(Symbol)Returns
datetime
Timestamp of the most recent quote update
Examples
=QM_Stream_Timestamp("AAPL")=QM_Stream_Timestamp("MSFT")=QM_Stream_Timestamp("SPY")=QM_Stream_Timestamp(A1)When to Use
- Monitoring data freshness
- Detecting stale quotes
- Audit trails for trading decisions
- Data quality verification
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need last trade time | QM_Stream_LastTradeTime() |
| Need pre-market trade time | QM_Stream_PreMarketTradeTime() |
| Need post-market trade time | QM_Stream_PostMarketLastTradeTime() |
| Need on-demand datetime | QM_DateTime() |
Common Issues & FAQ
What timezone is the timestamp in?
Timestamps are typically in Eastern Time (ET).
Why isn't the timestamp updating?
If no new data arrives for the symbol, the timestamp remains unchanged.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
- Stream Trade Count
- Stream Trade Count
- Stream Trade Value
- Stream Twap
- Stream TWAP
- Stream Vega
- Stream Volume
- Stream Volume
See QM_Stream_Timestamp used in a complete workbook: Real-Time Options API MCP: Live Option Chains and Greeks in Excel and AI
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?