Monte Carlo Simulation
Runs Monte Carlo simulation for portfolio analysis.
Syntax
=MonteCarloSimulation(Portfolio, Period)Examples
=MonteCarloSimulation("AAPL,MSFT,GOOGL", "1Y")When to Use
- Risk analysis
- VaR calculation
- Scenario planning
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Simple mean | MeanReturns() |
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
