Monte Carlo Simulation

-Arsenal-

New Member
Joined
Jun 19, 2010
Messages
10
Hey guys,

I am trying to simulate some stock return data with the random number generator.. I have 7 stocks that I want to simulate with a multivariate normal distribution where the inputs are the mean vector and the covariance matrix..

The random number generator that comes with Excel does not have a feature for multivariate normal distributions and I am trying to avoid having to buy a new program or add-in... Is there any way to do this? maybe using vba code?

Thanks in advance.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
I'm not sure I understand what you mean... I have some return data and I have calculated the mean vector and covariance matrix on that data... I want to simulate random numbers from a multivariate normal distribution using the mean vector and covariance matrix from the above-mentioned data as inputs... Just like when you do a normally distributed number generation where you use the mean and standard deviation of the existing data... :/
 
Upvote 0
This has just come out in a new 2010 version of an online journal:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>
The Journal of Financial Modeling and Educational Technology<o:p></o:p>
Winter 2010 (Vol. 1, No. 1)<o:p></o:p>


The article is available without registering.
The Excel file is available with registering.


Generating Correlated Normally Distributed Random Numbers in Excel

http://www.afmet-online.org/journal
 
Upvote 0

Forum statistics

Threads
1,215,425
Messages
6,124,826
Members
449,190
Latest member
rscraig11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top