Drawdown Thirty Days

Returns the maximum drawdown (peak-to-trough decline) over the last 30 trading days. Drawdown measures the largest percentage drop from any peak during the period.

Formula

Drawdown = (Trough Price - Peak Price) / Peak Price

Return Value

Negative percentage (e.g., -15.2 means 15.2% max decline from peak).

Examples

=DrawdownThirtyDays("AAPL")
Max 30-day drawdown

When to Use

Short-term risk assessment, recent volatility analysis

When NOT to Use

| Need longer period | DrawdownThreeMonths(), 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 Thirty Days and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions