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

Examples

=QM_Stream_Timestamp("AAPL")
Stream timestamp for Apple
=QM_Stream_Timestamp("MSFT")
Stream timestamp for Microsoft
=QM_Stream_Timestamp("SPY")
Stream timestamp for SPY ETF
=QM_Stream_Timestamp(A1)
Symbol from cell reference

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

Q: What timezone is the timestamp in? A: Timestamps are typically in Eastern Time (ET).

Q: Why isn't the timestamp updating? A: 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
MarketXLS Excel Add-in Tutorial - How to Use Stream Timestamp and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions