Drawdown Three Years

Returns the maximum drawdown over the last 3 years, useful for understanding risk through different market cycles.

Syntax

=DrawdownThreeYears(Symbol)
Excel Desktop (Windows)

Examples

=DrawdownThreeYears("AAPL")
Max 3-year drawdown

When to Use

Multi-year risk assessment, market cycle analysis

When NOT to Use

| Need 5 years | DrawdownFiveYears() |

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

Related Functions