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)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.
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?