Share |

Using Excel to Calculate Black-Scholes-Merton Option Price

This is Black-Scholes for a European-style call option. You can download the XLS @ this forum thread on my site: www.bionicturtle.com

  1. ChindoggOriginal
    February 4th, 2009 at 06:42 | #1

    no it doesnt dumbass

  2. robertgeorgefoley
    May 22nd, 2009 at 08:44 | #2

    Thanks. Really helpful!

  3. smithma01
    July 11th, 2009 at 16:32 | #3

    Thank you for your videos! I will check out your site!

  4. ruemlang89
    November 15th, 2009 at 05:37 | #4

    hi! how can i download the excel sheet on your site!? when i click on it (on the right side on your website), nothing happens! ty

  5. MrNH89
    February 20th, 2010 at 13:54 | #5

    Thank you. Much easier than reading 50 pages in John Hull’s book.

  6. bhuromaliya
    March 1st, 2010 at 04:05 | #6

    Its great thanks

  7. podge325
    March 30th, 2010 at 21:06 | #7

    Really helpful.. thanks a lot. It confirmed my excel sheet :P

    T remains constant for different dates of one option right? I mean, the value to use for T at initiation is the same T to use halfway through the life of the option… right?

    example: a euro call is created which expires in 1 year.. if we wanted to value this option 6 months from now, is the T value to use still 1?

    Thanks

  8. bionicturtledotcom
    May 14th, 2010 at 18:55 | #8

    You can find link to the XLS in the description field directly below the video. Thanks!

  9. lmospina42
    October 31st, 2010 at 15:26 | #9

    i prefer to use Derivagem from hull

  10. jawadalishe
    November 9th, 2010 at 18:21 | #10

    @lmospina42 what does this model do (Black Scholes). Does it predict the values of stocks or what.

  11. lmospina42
    November 9th, 2010 at 19:56 | #11

    @jawadalishe no it calculate the value of the call or the put. The important thing is thtat they assume that the price move infinte times.

  12. jawadalishe
    November 9th, 2010 at 22:07 | #12

    @lmospina42 so if the call option is high then investor call or put it.. And what does it means volatility…

  13. lmospina42
    November 9th, 2010 at 22:24 | #13

    @jawadalishe no, one thing is the call option and another is the put option. The call option is the right to buy and specific asset in the future(0.5 years, 6 months for specific price (K)). So, if the spot price(So), is higher than K, you should exercise the call option. The put option is the same, but you should exercise it if K is higher than So. And the volatility is the standar deviation of the asset. The volatility should be per year

  14. Lenora1027
    November 28th, 2010 at 17:02 | #14

    Thank you so much!!!!

  15. yyl111
    December 16th, 2010 at 07:46 | #15

    what about american option?

  16. cicikiz85
    March 22nd, 2011 at 16:23 | #16

    thank you very much from Italy!!

  17. manurajeev
    April 27th, 2011 at 13:02 | #17

    hi just wondering if i want to calculate the number of days , do I take 365 days or 250

  18. DrDainbramaged
    June 8th, 2011 at 16:18 | #18

    In your equation for C, shouldn’t S be multiplied by e^-qT to take account of dividends? In this case it works out, because you’re discussing a case in which the dividend yield is assumed to be 0 (thus making e^-qT = 1), but since you show the place of q in d1 it seems like it would make sense to represent the place of q in C as well, for consistency’s sake.

    Thanks for the vids, btw. Love ‘em.

  19. jptelthorst
    September 10th, 2011 at 15:58 | #19

    How you calculate the greek values?

  20. JCTgroupco
    October 17th, 2011 at 11:50 | #20

    thanks a lot for sharing, bro

  21. ironcdr
    November 19th, 2011 at 10:38 | #21

    @bionicturtledotcom

    Hi David, thanks for the video! The link in the description field is no longer available. Where would it be possible for me to download the XLS?

    Thanks!

  1. No trackbacks yet.