Trade Date
Returns the date when the most recent trade occurred.
Syntax
=TradeDate(Symbol)Returns
string
Date of last trade
Examples
=TradeDate("AAPL")When to Use
- Verify data freshness
- Check last trading day
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Trade time | LastTradeTime() |
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
See TradeDate used in a complete workbook: Zerodha Brokerage Calculator: Excel Guide for Intraday & Delivery Trading
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?