Last Trade Date
Returns the date when the security was last traded. This is useful for verifying data freshness and identifying securities that may have limited trading activity.
Return Format
Returns a date string in YYYY-MM-DD format.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Returns the date portion only, not the time
- For intraday last trade time, use
LastTradeTime() - Returns "NA" if data is unavailable
Syntax
=LastTradeDate(Symbol)Examples
=LastTradeDate("AAPL")=LastTradeDate("SPY")=LastTradeDate("^SPX")=LastTradeDate(A1)When to Use
- Verifying data freshness
- Identifying stale quotes
- Checking if market is open
- Validating trading activity
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need trade time | LastTradeTime() |
| Need full datetime | LastTrade_WithTime() |
| Historical trade dates | Historical data functions |
| Trading days counting | Calendar functions |
Common Issues & FAQ
Why is the date not today?
The market may be closed (weekend, holiday) or the security may not have traded yet today.
How do I check if data is fresh?
Compare LastTradeDate() to today's date to see if data is current.
How do I get both date and time?
Use LastTrade_WithTime() for the full timestamp.
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?