Drawdown One Year
Returns the maximum drawdown over the last 12 months (252 trading days). This is a key risk metric for annual performance assessment.
Notes
- Standard measure for annual risk reporting
- Useful for comparing risk across investments
- Key input for risk-adjusted returns
Syntax
=DrawdownOneYear(Symbol)Examples
=DrawdownOneYear("AAPL")=DrawdownOneYear("SPY")When to Use
Annual risk assessment, portfolio risk analysis, risk-adjusted returns
When NOT to Use
| Need multi-year | DrawdownThreeYears(), 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.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Drawdown Thirty Days
- Drawdown Three Months
- Drawdown Two Years
- Drawdowns
- Enterprise Value To EBITDA
- Enterprise Value To Revenue
- Fifty Two Week Change
- Fifty Two Week High
See DrawdownOneYear used in a complete workbook: Google Sheets Portfolio Tracker: Track Investments with Live Data and Analytics
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?