Quote DateTime (On Demand)

Gets the date and time of the quote on-demand (snapshot) from QuoteMedia. This indicates when the quote data was generated.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Indices ^SYMBOL ^SPX, ^VIX

Notes

  • Returns a snapshot (does not auto-update)
  • Time is typically in Eastern Time (ET)
  • Useful for verifying data freshness

Examples

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

When to Use

  • Verifying data freshness
  • Audit trails
  • Static reports with timestamps
  • Data quality checks

When NOT to Use

Scenario Use Instead
Need streaming timestamp QM_Stream_Timestamp()
Need last trade time QM_Stream_LastTradeTime()
Need pre-market time QM_Stream_PreMarketTradeTime()

Common Issues & FAQ

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

Q: Why is the time old? A: For on-demand functions, the timestamp reflects when you last refreshed. Refresh the workbook for updated data.

Q: Why am I getting #N/A? A: Check that symbol format is correct.

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 Quote DateTime (On Demand) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions