Calculating Option Greeks Using a Spreadsheet (or Python)

In answer to a question in the comments, I show how to use a spreadsheet (as well as Python) to calculate the option greeks. This is straightforward. I’ll calculate delta, theta and gamma as an example.

The spreadsheet and Python notebook are both available in the github repo.

[asapusrinivas]

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

[heberts]

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

[Amenoor]

Thanks for your valuable services, much appreciated :)

[jimdpike]

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

[arturoaramburo]

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

[srkjain]

Thanks ! can you please add vega also ?

[amarnagrare]

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

[dedicatedmotion]

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.

[dedicatedmotion]

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

[koachmahipal]

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

[akbarboghani]

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

[markusberger]

can you please check why theta is different with tastyworks

[beckenheimer]

please make a video why theta not correct?

[emmadshahid]

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

[alexandergrischuk]

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

[breakthruforex]

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

[berndweiss]

why is theta not the same like in tasty trade

[berndweiss]

everything is okay but theta not correct.

[admiralknnight]

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?