August 20th, 2008, 10:15 am
Hello,I am simulating a GBM in a Mote Carlo Simulation with VBA. I have the problem that my mean return from the simulated pathes is not corresponding to the exogenous mean return that I use for the simulation. I attached the code that i use. I am sure that the representation of the GBM is correct, nevertheless I always get a too small mean from the simulation. randoms is a vector that is normally distributed (0,1). stocks(i) = stocks(i - 1) * Exp((mean - 0.5 * (volatility ^ 2)) * time_increment + volatility * time_increment ^ 0.5 * randoms(i))to me it seems that the term 0.5 * (volatility ^ 2) automatically reduces the mean return. Still this representation is correct. Many thanks for help/explanation.F.