• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Looking for help with Excel macros

I’m disable student looking for some with excel. I’m taking a financial modeling class and I’m trouble getting a macro to work. I’m trying to get the Black Scholes option model to give the correct prices for a call and put at today date and at the expiration date for Boeing. Stock symbol(BA). It gets the price for the call correctly but not for the put for today's date. I have checked everything, but I had no luck on finding a solution to my problem. The put price should = the amounts for call and put analysis should be 4 and 3.84 on the call not not 2.92 call analysis and 2.31, 5.26 and not 3.67 for the put analysis. If I’m in the wrong area for this post, please let me know where I should post this and how to it should be done to get some help.


Thanks

Joe
 

Attachments

Back
Top