Monte Carlo Simulation
Runs Monte Carlo simulation for portfolio analysis.
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() |
