MarketXLS

Last Trade DateTime (On Demand)

Returns the date and time of the most recent trade for a stock or option using QuoteMedia's on-demand data service.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Options (OCC) SYMBOL+YYMMDD+C/P+STRIKE AAPL240315C00170000

Parameters

Parameter Type Required Description
Symbol String Yes Stock ticker or OCC option symbol

Notes

  • Returns datetime in local market time
  • Useful for checking data freshness
  • Can help identify illiquid securities (stale trade times)

Syntax

=QM_LastTradeDateTime(Symbol)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker or option symbol

Returns

string

Date and time of the last trade

Examples

=QM_LastTradeDateTime("AAPL")
Last trade time for Apple
=QM_LastTradeDateTime("SPY")
Last trade time for SPY
=QM_LastTradeDateTime("AAPL240315C00170000")
Last trade time for option
=QM_LastTradeDateTime(A1)
Symbol from cell reference

When to Use

  • Verify data freshness
  • Check when a security last traded
  • Identify illiquid securities
  • Timestamp trading data

When NOT to Use

Scenario Use Instead
Only need last price QM_Last() or Last()
Need historical trades QM_GetHistory()
Need streaming timestamps QM_Stream_* functions

Common Issues & FAQ

Why is the timestamp old?

This could indicate:

  • Market is closed
  • Illiquid security with infrequent trades
  • Data is from previous trading session

What timezone is the timestamp in?

Timestamps are typically in Eastern Time (ET) for US markets.

Related Formulas

More MarketXLS Price Quotes formulas you can use in the same worksheet:

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

Related Functions