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
Syntax
=QM_DateTime(Symbol)Examples
=QM_DateTime("AAPL")=QM_DateTime("MSFT")=QM_DateTime("SPY")=QM_DateTime(A1)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
What timezone is the datetime in?
Times are typically in Eastern Time (ET).
Why is the time old?
For on-demand functions, the timestamp reflects when you last refreshed. Refresh the workbook for updated data.
Why am I getting #N/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
▶
How does MarketXLS work?