Empirical Distribution and Monte Carlo Simulation in Excel


I have some detailed question about the possibility to use a Monte Carlo (MC) simulation with NumXL.

I have a series of historical returns of a stock index, and I want to define an empirical "distribution" using those returns to run my Monte Carlo simulation.

  1. Is this possible? (the general question is: is it possible to define my own distribution based on historical stock returns?)
  2. How can I do this?



Please sign in to leave a comment.

Didn't find what you were looking for?

New post