• 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.

Need Help with Black Scholes Options Macros

Status
Not open for further replies.
E

El Jefe 7878

Member
I’m disable student looking for some help 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 amounts for calls and put analysis should be 4 for the call and 3.84 for the put, not 2.92 for put. On the puts analysis, the call should be 2.31 and the put price should be 5.26 and not 3.67 for the puts analysis. If I’m in the wrong area for this post, please let me know where I should post this and how it should be done to get some help.

Jose


▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !

​
 
Last edited by a moderator:
Status
Not open for further replies.
Back
Top