Calculating Option Greeks Using a Spreadsheet (or Python)

Поделиться
HTML-код
  • Опубликовано: 15 ноя 2024

Комментарии • 55

  • @asapusrinivas
    @asapusrinivas 2 года назад

    One and only video on formulas for option greeks. Thank you very much. very helpful. If possible please give vega formula also.

    • @kpmooney
      @kpmooney  2 года назад

      I give the formula for vega in this video:
      ruclips.net/video/ljlqGWz1xDY/видео.html

  • @hebert2s
    @hebert2s 4 года назад +2

    Thanks!!! Just what I need for my PHP dashboard system. Great Job!!

  • @Amenoor4
    @Amenoor4 4 года назад +2

    Thanks for your valuable services, much appreciated :)

  • @tarakeshnc9302
    @tarakeshnc9302 4 года назад +2

    Excellent video !

  • @sergiosaravia167
    @sergiosaravia167 2 года назад

    many thanks Kevin!

  • @ishaque123456
    @ishaque123456 4 года назад +2

    Great job! Thanks a lot!

  • @edmilsonsgjk
    @edmilsonsgjk 4 года назад +1

    Great video!

  • @koachmahipal2180
    @koachmahipal2180 2 года назад

    Many Many thanks for Explaining it so nicely. I have small question. If I want to see DELTA Hour wise for few days, how would I do that. This will help understand how much delta is left and should i wait till expiry or Square of my position or may be hedge it

    • @kpmooney
      @kpmooney  2 года назад

      I am not sure what you mean by hour-wise. If you want to know how delta changed, for example on an hourly basis over the last few days, you would need the stock price and volatility at those times.

    • @koachmahipal2180
      @koachmahipal2180 2 года назад

      @@kpmooney Yes Yes, thats exactly what I need. Can you guide me or share any template, i will enter the STOCK PRICE And Volatility

  • @jimdpike
    @jimdpike 3 года назад

    Thank you very much Kevin. You are safe! You did not finish explaining the formula for Put Theta do you mind sharing the formula. Stay blessed

    • @kpmooney
      @kpmooney  3 года назад

      It should be in the Wikipedia article linked to in the video description. Basically you put a minus sign in front of d1 and d2 and change the plus to a minus in the term with the str4ike price.

  • @amarnagrare7270
    @amarnagrare7270 9 месяцев назад

    Sir pls tell to me the value of P which I have to follow in theta of Put option.

    • @kpmooney
      @kpmooney  9 месяцев назад

      In the Python code? It is just a flag to tell the code to use the formula for a put.

  • @akbarboghani1
    @akbarboghani1 4 года назад

    Thanks for sharing. Is it possible to calculate the implied volatility as well?

    • @kpmooney
      @kpmooney  4 года назад

      Yes, ruclips.net/video/ljlqGWz1xDY/видео.html

  • @srkjain2000
    @srkjain2000 7 месяцев назад

    Thanks ! can you please add vega also ?

    • @kpmooney
      @kpmooney  7 месяцев назад

      vega = K*exp(-r*t)*phi(d_2) & sqrt(t) where phi is the normal density function. It's covered in a video on option greeks.

  • @dedicatedmotion1960
    @dedicatedmotion1960 4 года назад +1

    I see theta is multiplied by the number of shares per contract (100).
    Is it the only Greek affected by that multiplier? Thank you…

    • @kpmooney
      @kpmooney  4 года назад +1

      Yeah, the quoting convention for theta in the option chain is different. Not sure why they elect to do it that way.

    • @dedicatedmotion1960
      @dedicatedmotion1960 4 года назад

      @@kpmooney Thank you very much!!

  • @arturoaramburo9365
    @arturoaramburo9365 4 года назад

    Thank you for the explanation!!
    Hey Kevin!!
    Can you make a video on how to isolate the Stock Price from the Black Scholes Formula for a put and for a call?
    No one has done it on RUclips yet.
    When you have an excel spreadsheet ready to calculate the option price; it’s very easy to find the stock price using Goal Seek or SOLVER, but to do that outside an excel environment, you have to algebraically isolate that variable. It is just a nice way of knowing your entry.

    • @kpmooney
      @kpmooney  4 года назад +1

      Sure. It might take a few weeks to put together though.

    • @arturoaramburo9365
      @arturoaramburo9365 4 года назад

      Thanks Kevin!

    • @kpmooney
      @kpmooney  4 года назад

      This turned out to be quicker than I though. The video is up now. Let me know if that is not what you meant.

    • @arturoaramburo9365
      @arturoaramburo9365 4 года назад

      Yes, thank you very much!!! Well done..

  • @dedicatedmotion1960
    @dedicatedmotion1960 4 года назад +1

    Can the Greeks be treated as money affecting profit directly?
    It is clear they do not affect the option price, but I see you refer to theta in this video as bucks. That tells me they all could be handled as money, as you did when referring to theta in terms of dollars.

    • @kpmooney
      @kpmooney  4 года назад

      They can be thought of (for first-order Greeks) as dollar change per unit of something. Theta, for example, is dollar change in contract price per unit of time. Delta is change in price per unit of stock price. Remember these are instantaneous rates of change. They themselves change as things move around. You can estimate this change with the higher order Greeks.

    • @dedicatedmotion1960
      @dedicatedmotion1960 4 года назад

      Thank you very much!!

  • @markusberger7261
    @markusberger7261 4 года назад +1

    can you please check why theta is different with tastyworks

    • @kpmooney
      @kpmooney  4 года назад

      It isn’t that Tastyworks does things differently. On all the platforms I’ve worked with Theta is quoted as dollars per contract per day. The numbers that come out of the Black-Schiles model is in dollars per share per year. One needs to change the units to get it in agreement with trading platforms.

    • @kpmooney
      @kpmooney  4 года назад

      On all the platforms I’ve worked with Theta is quoted as dollars per contract per day. The numbers that come out of the Black-Schiles model is in dollars per share per year. One needs to change the units to get it in agreement with trading platforms.

  • @beckenheimer9219
    @beckenheimer9219 4 года назад

    please make a video why theta not correct?

  • @emmadshahid3031
    @emmadshahid3031 3 года назад

    Hi, if the k is different for put, what should I do then ?

    • @kpmooney
      @kpmooney  3 года назад

      I am not sure what you mean. If I recall the video, I just kept all the strikes the same for simplicity. You'd use whatever strike you're interested in.

  • @alexandergrischuk9762
    @alexandergrischuk9762 3 года назад

    Hello Kevin. Can you please explain how to Automate these Greeks values?

    • @kpmooney
      @kpmooney  3 года назад

      What do you mean by automate? If you mean update in real time, you'd need a connection to a data provider or access to your broker's API if they have one available. It would depend on the API itself, too. I know Interactive Brokers and TD Ameritrade have a Java-based API. It'd be a pain in the butt to get that to work with Excel, I think.

    • @alexandergrischuk9762
      @alexandergrischuk9762 3 года назад

      Yes Kevin. I mean let us say if I want to fetch real time data from CBOT website then how to update Option Greeks values for 10 Strikes?

    • @kpmooney
      @kpmooney  3 года назад

      @@alexandergrischuk9762 Assuming you have a data feed, the Python code should be able to do vectorized calculations to work out the greeks for all ten strikes at the same time. That assume the data feed gives you the volatility of those strikes though.
      If it doesn't give you the vol, you'll have to calculate it from the option prices. This is a bit trickier. I have a couple of videos on it with title like "Revisiting the Implied Volatility Code" I try (it doesn't always work) to come up with a fully vectorized code to calculate IV.

    • @alexandergrischuk9762
      @alexandergrischuk9762 3 года назад

      @@kpmooneyI tried a lot but yes it is a tricky one. I am using this (code.mibian.net/) library for Option Greeks. If possible can you make video on that? I mean how mibian can be applied to >1 strike prices and Update the Greeks Values rather than manually updating it. Well Actually in VBA it is possible but not in Python or at least I am not aware of.

    • @kpmooney
      @kpmooney  3 года назад

      I just saw this comment. RUclips is random about which comments it notifies me about. I'll take a look at it.

  • @breakthruforex
    @breakthruforex Год назад

    is that a flying v or a bass? our rooms look exactly the same lol

  • @berndweiss231
    @berndweiss231 4 года назад

    why is theta not the same like in tasty trade

    • @kpmooney
      @kpmooney  4 года назад

      Quoting conventions. See this video for an explanation. ruclips.net/video/RN8zmSO6DfE/видео.html

  • @berndweiss231
    @berndweiss231 4 года назад

    everything is okay but theta not correct.

  • @admiralknnight5779
    @admiralknnight5779 4 года назад +1

    FINISH OFF UR DRINK! PUT IS SPELLED AS PUT & NOT "PUTT". & BY THE WAY WHAT THE HELL R U TRYING TO CONVEY TO THE COMMON MAN? ALL THE FIGURES R READILY AVAILABLE IN ALL THE PLATFORMS. WHY COMPLICATE ISSUES FOR HALF AN HOUR? & WHO KNOWS ABOUT PROGRAMMING?

    • @vksingh833
      @vksingh833 4 года назад +1

      knight is NOT spelled as knnight and knights are in cavalry. So they cannot be admirals(navy).