I'm curious what software I should use for Monte Carlo Simulations. I'm not a computer programmer but have some knowledge of quantitative finance. I assume that Matlab is more sophisticated than Mathematica, but I don't mind investing some time to learn. Whatever is more efficient and better overall will do. Please list any other programs that are good as well? If anyone has any Excel tips to run a very simply test, that would be great too. I've seen a lot of information on the web for Excel but few for equities. Thanks
One important point to keep in mind is the random number generator. Matlab is good I think but for Excel I dont know. Any programming language can do, if you can code it.
Thanks for the quick reply... I know there is a random number generator for Excel... but I don't want to deal with too much on the macros to get it to run. I would prefer just plugging in data/variables. Does Matlab require a lot of (complex) coding? I was under the assumption that I just insert the data and plug in parameters within a made outline. I'll do some more research now.
computer can not give you true random numbers use a program that measures CPU temp it will give you true random numbers
Wet dreams. You do have to code the thing since you have to define what is it that you do a Monte Carlo on. Matlab does not have a list of all possible testable scenarios. And even worse, if you want to test a strategy on stocks, you have to define how the simulated stock path go. You have to make it yourself; brownian? stochastic vol? jumps?...
In Monte Carlo you dont care about the numbers themself but rather on their distribution. And it's a desirable feature to have pseudo random number because you can re-run the same simulation many times or run a different simulation with the same numbers. But you are right, they are not random, they are pseudo random.
Good post. I wonder if trully random number exist, since they always depend on the seed and thus the sequence will be repeated at some point in time.