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

Examples

=DrawdownCustomDates("AAPL", DATE(2022,1,1), DATE(2022,12,31))
2022 drawdown
=DrawdownCustomDates("MSFT", "2023-01-01", "2023-06-30")
H1 2023

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

Q: Why am I getting "NA"? A: Check that the symbol is valid and has sufficient trading history for the requested period.

Q: Are returns price-only or total return? A: These are typically price returns. Dividend-adjusted returns may differ.

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 Drawdown Between Two Dates and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions