• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Hull-White Two Factor Model Excel-Implementation

Joined
11/6/16
Messages
1
Points
11
Hello everyone,

I am a MSc in Finance student and currently writing my master thesis about the Hull-White two factor model. Unfortunately, I have some problems with the implementation in Excel. I am not too experienced with Quantitative Finance and therefore implement it in Excel by hand (no VBA programming). I have set up the three-dimensional trinomial tree Right now I am not sure how to continue with pricing caps, floors and swaps. Can someone please give me some advice about how to continue or does anyone know if there a document out there with a good example for the pricing with the Hull-White 2 factor model? Your help would be very much appreciated!

P.S.: below you can find the excel file I'm currently working on (I put in some random numbers for the parameters for now, just in case you are wondering).
 

Attachments

  • Master thesis-Hull White 2 factor model - revised probabilities 2.xls
    46.5 KB · Views: 875
Back
Top