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)
Excel Desktop (Windows)

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

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.

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