Drawdowns
Calculates the drawdowns for a portfolio.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Portfolio | string | Yes | Comma-separated symbols |
| Period | string | Yes | Time period |
| InitialAmount | number | Yes | Initial investment |
Syntax
=mxls.Drawdowns(Portfolio, Period, InitialAmount)Examples
=mxls.Drawdowns("AAPL,MSFT,GOOGL", "1Y", 10000)When to Use
- Risk assessment
- Historical drawdown analysis
- Portfolio evaluation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Mean returns | MeanReturns() |
Common Issues & FAQ
What is a drawdown?
Peak to trough decline in portfolio value.
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?