Serving the Quantitative Finance Community

 
User avatar
Patota83
Topic Author
Posts: 0
Joined: June 17th, 2004, 12:32 pm

SWAPTIONS

June 21st, 2004, 8:43 pm

hi,I've been assigned a long term project for the summer and was looking for some help.I was wondering what type of binomial or trinomial tree is the best to use for pricing european swaptions. Basically, I have to find the best interest rate model to use (hull-white, ho lee, etc) and make a program/spreadsheet in excel. I don't have an extensive knowledge of the subject or a ton of programming skills - this is more of a research oriented project. I need to research how people implement tree based option models in excel - how they work and any potential differences. My model must assume normal interest rates and I can only consider open form models. (no bounds on the interest rates)i am leaning towards using a hull white trinomial spreadsheet.
 
User avatar
ppauper
Posts: 11729
Joined: November 15th, 2001, 1:29 pm

SWAPTIONS

June 21st, 2004, 10:49 pm

Last edited by ppauper on December 15th, 2004, 11:00 pm, edited 1 time in total.
 
User avatar
Patota83
Topic Author
Posts: 0
Joined: June 17th, 2004, 12:32 pm

SWAPTIONS

June 22nd, 2004, 11:36 am

normal, as in "normal distribution"
 
User avatar
ppauper
Posts: 11729
Joined: November 15th, 2001, 1:29 pm

SWAPTIONS

June 22nd, 2004, 1:15 pm

Last edited by ppauper on December 15th, 2004, 11:00 pm, edited 1 time in total.