Hi,
I am trying to build binomial option model in excel. right now I have a macro in place that values American put model & also construct a binomial tree upto 200 nodes. I am trying to make it more dynamic by making it value american call as well as europian options.
I have formulas but I am not able to make my macro run. To give a proper view first I will post the formulas to value bith american & europian options. Below that I will write the macro I am using. Please have a look and help me out if you can.
Edit1: As per forum policy, I have also asked this question on other forum. The link to the same is as below.
http://www.mrexcel.com/forum/excel-q...valuation.html
Bookmarks