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()

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 Monte Carlo Simulation and Other Financial Formulas
How does MarketXLS work?