Serving the Quantitative Finance Community

 
User avatar
halldorpb
Topic Author
Posts: 0
Joined: March 27th, 2006, 2:35 am

Geske (1979) Compound Options - VBA code needed

July 22nd, 2006, 9:32 pm

Does anyone have Geske code that they can PM me with, or post in the file share section? Thank you very much in advance!
 
User avatar
halldorpb
Topic Author
Posts: 0
Joined: March 27th, 2006, 2:35 am

Geske (1979) Compound Options - VBA code needed

July 23rd, 2006, 1:36 am

Well, I have identified the error in my model already, so I suppose a code won't be necessary after all...There is still one problem that prevents my code from working, that I thought experts here might know the answer to, here goes:How does one determine the initial value x0 for the Newton-Raphson problem of finding Geske's implied strike (i.e. critical value of S which marks the at-the-money boundary of the compound)? I usually use Manaster and Koehler for BS implied vol, but obviously that will not do the trick here I guess...anyone knows how to extend their method to compounds?
 
User avatar
PaperCut
Posts: 0
Joined: May 14th, 2004, 6:45 pm

Geske (1979) Compound Options - VBA code needed

July 23rd, 2006, 3:28 am

QuoteOriginally posted by: halldorpb ...How does one determine the initial value x0 for the Newton-Raphson problem of finding Geske's implied strike (i.e. critical value of S which marks the at-the-money boundary of the compound)? I usually use Manaster and Koehler for BS implied vol, but obviously that will not do the trick here I guess...anyone knows how to extend their method to compounds?I thought you just start with the strike of the compound. So, if you have an SPX $20 call on a 1150 put, your start value for the search would be $20.
 
User avatar
halldorpb
Topic Author
Posts: 0
Joined: March 27th, 2006, 2:35 am

Geske (1979) Compound Options - VBA code needed

July 23rd, 2006, 9:21 am

QuoteOriginally posted by: PaperCutQuoteOriginally posted by: halldorpb ...How does one determine the initial value x0 for the Newton-Raphson problem of finding Geske's implied strike (i.e. critical value of S which marks the at-the-money boundary of the compound)? I usually use Manaster and Koehler for BS implied vol, but obviously that will not do the trick here I guess...anyone knows how to extend their method to compounds?I thought you just start with the strike of the compound. So, if you have an SPX $20 call on a 1150 put, your start value for the search would be $20.I tried using the strike of the underlying and it works just about perfectly...for the record Geske's critical value is measured in terms of the stock (it is solved for using the strike of the compound) and so is a more natural choice than using the strike of the compound. Anyways, excellent suggestion, got me on the right track!
 
User avatar
jkal1000
Posts: 0
Joined: November 19th, 2005, 9:54 pm

Geske (1979) Compound Options - VBA code needed

August 22nd, 2006, 7:47 am

Hi Halldorpb,Can you please post your VBA code or PM it to me. It would be much appreciated. Thanks. Btw, another paper you may be interested in (if you haven't seen it already) is Holger Schilling: "No arbitrage bounds and static hedging of compound options"
Last edited by jkal1000 on August 21st, 2006, 10:00 pm, edited 1 time in total.
 
User avatar
Wibble
Posts: 1
Joined: January 23rd, 2004, 3:15 pm

Geske (1979) Compound Options - VBA code needed

August 22nd, 2006, 8:11 am

the collectors book has vba code for this
 
User avatar
jkal1000
Posts: 0
Joined: November 19th, 2005, 9:54 pm

Geske (1979) Compound Options - VBA code needed

August 22nd, 2006, 8:34 am

Thanks. What is the collectors book. Do you have a link for this?
 
User avatar
Wibble
Posts: 1
Joined: January 23rd, 2004, 3:15 pm

Geske (1979) Compound Options - VBA code needed

August 22nd, 2006, 10:11 am

The complete guide to option pricing formulas by espen gauder haug available from wilmott bookshop or amazon, has VBA code for lots of different option types
 
User avatar
jkal1000
Posts: 0
Joined: November 19th, 2005, 9:54 pm

Geske (1979) Compound Options - VBA code needed

August 22nd, 2006, 12:55 pm

Thanks anyway, but I'd rather not purchase the book. I just need to confirm my output.