I am currently a senior in high school and I built a stock simulator using knowledge gained from a semester of AP Statistics. I was wondering if someone could tell me if my simulation is legit/reasonable!

Here is the Download Link: https://www.dropbox.com/s/llebsb868k06nbz/Simple%20Stock%20Simulator%20Dropbox.xlsm?dl=0

The green cells are for inputs and you can run the ScaleAxes macro (press Alt F8 and hit run) to auto format the stock price graph.


  • $\begingroup$ Just make sure that the source that provides the inputs (expected return and volatility) uses the same formulas as in your simulation. $\endgroup$ – James Dec 3 '14 at 14:51
  • $\begingroup$ Ok! Thank you so much for taking the time to answer my question! $\endgroup$ – Joel Dec 3 '14 at 18:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.