does MonteCarlito work?
It is a macro; to be able to start it, just open the MonteCarlito.xls
file along with your other files.
to run do Monte-carlo-simulation?
Put all formulas you want to simulate in a line next to each other, preceded
by the number of trials. Select all these cells, as well as some cells
beneath for the statistical analysis output. Press Ctrl+W or start macro
to run in high-speed mode?
Use a negative number of trials.
to create histograms?
Change the font type of the cell containing the number of trials to bold
before starting MonteCarlito with Ctrl+W.
- M. Auer 2012
MonteCarlito is open source and distributed under the terms of the GNU
General Public License