Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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/ |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Software that works well with excel to conduct monte carlo simula. | Excel Discussion (Misc queries) | |||
How can i made a monte Carlo simulation with Excel ? | Excel Discussion (Misc queries) | |||
How do I perform a Monte Carlo simulation in Excel? | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |