Drawdown Two Years

Returns the maximum drawdown over the last 2 years.

Examples

=DrawdownTwoYears("AAPL")
Max 2-year drawdown

When to Use

Multi-year risk assessment, longer-term risk analysis

When NOT to Use

| Need 1 year | DrawdownOneYear() |

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 Two Years and Other Financial Formulas
How does MarketXLS work?