Monte Carlo Analysis

Replies to This Discussion

Permalink Reply by Retha Kwok on March 14, 2008 at 10:43am

Here's one by Humberto Barreto and Frank M. Howland from the Econometrics department of Wabash College.

I think the real advantage of this Monte Carlo analysis Excel add-in over others is its simplicity in use, installation instructions and (what I hear to be) good ongoing support provided by its developers / authors.

Here's a description of the Excel add-in from their website:

This add-in, MCSim.xla, enables Monte Carlo simulation from any Excel sheet. The logic is quite simple: you select a cell that has or depends upon a random number (using either Excel's RAND or our RANDOM function) and the add-in recalculates the sheet for as many repetitions as you request. It outputs the results to a new sheet with summary statistics and a histogram. You may Monte Carlo more than one cell and you have several other options.

Attachments:

• MCSim.xla, 312 KB
• MCSim Installation Instructions.doc, 162 KB

• ▶ Reply

Permalink Reply by Yugesh on March 15, 2008 at 2:59am

Hi Retha

Thanks for providing info on MC analysis...I have not yet tried the add in provided by you...i will try it to run my model...

And come back to you..

Thanks once again

Yugesh

• ▶ Reply

Permalink Reply by luke on March 23, 2008 at 5:12pm

hi thanks mate just trying out the site and found out about this.
thanks

luke.

• ▶ Reply

Permalink Reply by vivek on July 13, 2009 at 10:59am

Hello Retha,

I am not able to open the excel file could you please send anoher one...

Cheers,

Vivek
viveknaik2006@gmail.com

• ▶ Reply

Permalink Reply by fabian on April 9, 2008 at 4:44pm

try the free version of "crystal ball" soft

• ▶ Reply

Permalink Reply by Dulanjie De silva on May 8, 2008 at 3:56am

Hi Yugesh,

I am Dulanjie Workig on a construction project for a new business. I need to evaluate the risks and variables undelying the different scenarios with respect to this project. I would be thankfull if you can send me the montecarlo X cel, if you have already reeived it, since it will make my workload much easier ,simpler and accurate.

• ▶ Reply

Permalink Reply by Yugesh on May 8, 2008 at 5:09am

Hi Dulanjie

MC Sim.xla file is already uploaded in ths forum by our friend Retha...

Apart from that i hvnt used any other software for MC analysis...

Yugesh

• ▶ Reply

Permalink Reply by Ricky on December 13, 2008 at 1:05pm

Many thanks. I'll use it for my school project work.

• ▶ Reply

Permalink Reply by Enrique Gonzalez on July 11, 2009 at 2:26pm

Hello all,

There exists an excellent alternative in terms of software for Monte Carlo Analysis. It is SIMULAR, developed by Professor Luciano Machain from the National University of Rosario in Argentina. I suggest you visit his web page at: http://www.simularsoft.com.ar/

You don't have to pay for the software but professor Machain acepts donations or at least an example of a model where his package was successfully used.

Regards,

Enrique

• ▶ Reply

Permalink Reply by Robin Pauletto on December 14, 2010 at 8:46am

Hello,

 

I developed a new risk analysis tool called Statscorer. It allows do to Monte Carlo simulations within Excel.

I will be interested to know your opinion since it's a bit different from its competitors: you can correlate directly input variables with formal expression (e.g.: X3=Exp(X1)+ln(X2^2+1), ...), export raw data in a text file and other stuffs. I will give a free 3-month subscription to the readers of finance 3.0 (this offer runs until march 2011 ;-).

Just send me an email to support@statscorer.com mentioning you are a reader of Finance 3.0

 

You can visit www.statscorer.com for further details.

 

Bye,

Robin

• ▶ Reply

Permalink Reply by noah123 on February 28, 2011 at 3:54pm

I've also tried the free add-in for Excel called YASAI and YASAIw, Along with the commercial @Risk from Palisade.

 

Are there any similar (free or paid) add-ins for OpenOffice Calc? 

• ▶ Reply