Quote Date

Returns the date when the quote data was last updated.

Parameters

Parameter Type Required Description
Symbol string Yes Stock ticker symbol

Syntax

=QuoteDate(Symbol)
Excel Desktop (Windows)

Examples

=QuoteDate("AAPL")
Apple quote date
=QuoteDate("MSFT")
Microsoft quote date

When to Use

  • Verify data freshness
  • Check when quote was updated
  • Data validation

When NOT to Use

Scenario Use Instead
Trade date TradeDate()
Trade time LastTradeTime()

Common Issues & FAQ

Is this the same as TradeDate?

QuoteDate is when quote was updated; TradeDate is last trade date.

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 Date and Other Financial Formulas
How does MarketXLS work?