How can i set up a MONTE CARLO SIMULATION macro in Excel? thx
I'm looking for a simple macro for Monte carlo sim? I'd apprectiate any help.
many thanks |
Please see a reply in your multiple-post in
microsoft.public.excel.programming. "MonteUser" wrote in message ... I'm looking for a simple macro for Monte carlo sim? I'd apprectiate any help. many thanks |
Don't know about a simple formula, my understanding of Monte Carlo
simulations is that it is not simple, but the a search on Google using 'monte carlo excel vba' threw up 6,000+ entries. Take a look http://tinyurl.com/axzsg -- HTH RP (remove nothere from the email address if mailing direct) "MonteUser" wrote in message ... I'm looking for a simple macro for Monte carlo sim? I'd apprectiate any help. many thanks |
I've used the Crystal Ball addin to run MC simulations. I don't
think std Excel has the capability. Crystal Ball is pretty sweet but it ain't cheap. Check the following web site: http://www.decisioneering.com/ |
Hi Excel provides all the formulas for you to be able to do the Simulation
but you have to put them together yourself. For instance if you want to simulate 10 tosses of a coin, you enter the formula to generate a random number in A1 (=rand()) and another formula in B1 (=if(A1<=.5,"T","H")) and copy A1:B1 in A2:B10. Then each time you recalculate, you get a result of 10 tosses of a coin. You can generate random numbers in any range based on Normal and other probablilty distributions as all those formulas are there. Alok Joshi "MonteUser" wrote: I'm looking for a simple macro for Monte carlo sim? I'd apprectiate any help. many thanks |
All times are GMT +1. The time now is 10:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com