Drawdown Between Two Dates
Returns the maximum drawdown over a custom date range specified by start and end dates.
Parameters
- Symbol: Stock ticker
- StartDate: Beginning of period
- EndDate: End of period
Syntax
=DrawdownCustomDates(Symbol, StartDate, EndDate)Parameters
symbolstringRequired
Stock ticker symbol
startDatedateRequired
Start date (YYYY-MM-DD)
endDatedateRequired
End date (YYYY-MM-DD)
Examples
=DrawdownCustomDates("AAPL", DATE(2022,1,1), DATE(2022,12,31))=DrawdownCustomDates("MSFT", "2023-01-01", "2023-06-30")When to Use
Custom period risk analysis, specific event analysis, backtesting
When NOT to Use
| Need standard periods | Use fixed period functions |
Common Issues & FAQ
Why am I getting "NA"?
Check that the symbol is valid and has sufficient trading history for the requested period.
Are returns price-only or total return?
These are typically price returns. Dividend-adjusted returns may differ.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Drawdown Nine Months
- Drawdown Six Months
- Drawdown Thirty Days
- Drawdown Three Months
- Drawdown Three Years
- Drawdown Two Years
- Drawdowns
- Enterprise Value To EBITDA
See DrawdownCustomDates used in a complete workbook: Stock Drawdown
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?