SERVING THE QUANTITATIVE FINANCE COMMUNITY

ojim
Topic Author
Posts: 6
Joined: December 11th, 2004, 6:38 pm

### Basket Option and Monte Carlo

Hi,If I want to price a basket option of 3 equity index, with correlation matrix available. How do I incorporate the correlation info into the Monto Carlo Simulation? Do I build one set of random variates for 1 equity index first, and then create 2 more equity index according to the correlation matrix? Any idea / VB code / sources would be highly appreciated.Thank you so much for your great help.....

Antonio
Posts: 630
Joined: June 30th, 2004, 3:13 pm
Location: Imperial College London
Contact:

### Basket Option and Monte Carlo

What you have to do is to create one brownian motion for one equity, then you simulate the two other Brownian motions using the "square root" of the covariance matrix, using a Cholesky decomposition. I have some vba or c++ code for that if you want, but I can't provide it to you before tomorrow (it's at home).

ojim
Topic Author
Posts: 6
Joined: December 11th, 2004, 6:38 pm

### Basket Option and Monte Carlo

that will be very helpful if you could post the code file.Thank you so much again!

junbum
Posts: 23
Joined: May 23rd, 2005, 9:18 pm

### Basket Option and Monte Carlo

Hello Antony,Could you please send theVB code for cholesky decomposition to to gvmrb@yahoo.co.uk .Your help will be appreciated and acknowledged. jun

Antonio
Posts: 630
Joined: June 30th, 2004, 3:13 pm
Location: Imperial College London
Contact:

### Basket Option and Monte Carlo

Hi,Here is the vba and c code for the Cholesky decomposition. There is also a short explanation on how to use it to simulate your correlated assets.Have fun
Attachments
Cholesky2.zip

rhmari
Posts: 21
Joined: May 27th, 2005, 10:12 am

### Basket Option and Monte Carlo

hi i'am also trying to price a basket optioni see that antonio has sent the VBA Code for Cholesky Decompositioni took it but unfortunatelly,i don't know how to use it in Excel,i mean how do i enter my matrix A on Excel and how to obtain the L matrix wich is the cholesky decomposition of A.Can you please send me the excel File where i can find the pricing of the basket option if you have already done itthank you very much for your helpyou can send me the files at the following address : mohamed.rhrmaritlemcani@epfl.ch

rhmari
Posts: 21
Joined: May 27th, 2005, 10:12 am

### Basket Option and Monte Carlo

hi i'am also trying to price a basket optioni see that antonio has sent the VBA Code for Cholesky Decompositioni took it but unfortunatelly,i don't know how to use it in Excel,i mean how do i enter my matrix A on Excel and how to obtain the L matrix wich is the cholesky decomposition of A.Can you please send me the excel File where i can find the pricing of the basket option if you have already done itthank you very much for your helpyou can send me the files at the following address : mohamed.rhrmaritlemcani@epfl.ch

rhmari
Posts: 21
Joined: May 27th, 2005, 10:12 am

### Basket Option and Monte Carlo

Hi Antonioi saw that you have a VB Code to price a Basket Optioncan you please send it to me (with the excel spreadsheet if it's possible) to this adress : mohamed.rhmaritlemcani@epfl.chThank you very much for your help

BLOBY
Posts: 113
Joined: May 17th, 2004, 5:07 am

### Basket Option and Monte Carlo

Please make benefit from it everyone...

Antonio
Posts: 630
Joined: June 30th, 2004, 3:13 pm
Location: Imperial College London
Contact:

### Basket Option and Monte Carlo

Hi,Here is how to use the Cholesky decomposition in Excel. I don't have the pricer for Basket options with me, I'll have to look for it at home. But it really is immediate : just simulate the underlyings using the Cholesky decomposition for the correlation matrix between the Brownian motions, then calculate your final payoff, you discount it, you run that n times and you get your Monte Carlo price.
Attachments
Cholesky example.zip

jfuqua
Posts: 1255
Joined: July 26th, 2002, 11:41 am

### Basket Option and Monte Carlo

Papers not code. Still perhaps of value.Pellizari P. 'Efficient Monte Carlo Pricing of Basket Options' U. VeniceDahl Lars, Fred Benth 'Valuation of Asian Basket Options with Quasi-Monte Carlo Techniques & Singular Value Decomposition' 2/2001

Posts: 19
Joined: January 25th, 2005, 10:30 am

### Basket Option and Monte Carlo

I too am looking at basket options in monte carlo. I understand that I have to simulate the underlyings using the Cholesky decomposition for the correlation matrix between the Brownian motions, however I'm not sure how to implement this in practice. I have the vols for each or my 3 assets and also the correlation matrix which I can form the Cholesky matrix from this. However I'm unsure then what do to next, I know that I should start by creating my normally distributed numbers for each asset and then somehow apply the Cholesky matrix, but how to I apply the matrix to the 3 sets of data.Let cholesky matrix be:1 0 0a b cd e fIs it the case that the first asset's data is left alone (hence the top of the Cholesky matrix is 1, 0, 0?Then the next asset is multiplied so you use a*asset 1 + b* asset (with no c term because c is always 0)Then the last asset is multipled so d*asset1 + e*asset2 + f*asset3Do I then use these three new assets (wwell ok asset1 is unchanged, but call the others asset2' and asset3') to find my basket return and hence do the normal calculate payoff, discount to today and run numerous times for my simulations?THANKS

Sonyah
Posts: 153
Joined: December 11th, 2006, 3:58 pm

### Basket Option and Monte Carlo

Cholesky matrix should be applied to your normally distributed random number samples to create correlated distributions. Then you can generate your paths using the same formula you would for a 1 factor but using the correlated randoms.

vietdung
Posts: 30
Joined: February 12th, 2007, 2:40 pm

### Basket Option and Monte Carlo

In java we have a very useful package for manipulate the matrix, named : JAMA (includes Cholesky , LU ... decomposition).My case particular , I tried a basket of 40 assets and around 1000000 simulations 360 time steps , it costs 9h of simulation Anyone has a good ref results for the basket option ?

Wilmott.com has been "Serving the Quantitative Finance Community" since 2001. Continued...

 JOBS BOARD

Looking for a quant job, risk, algo trading,...? Browse jobs here...

GZIP: On