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.
- Is this possible? (the general question is: is it possible to define my own distribution based on historical stock returns?)
- How can I do this?