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.
Wikipedia article on Greeks:
Wikipedia article on the Black-Scholes model:
Github:
Donate:
Tip Jar: .
Table of Contents
Images related to the topic financial greeks
Calculating Option Greeks Using a Spreadsheet (or Python)
Search related to the topic Calculating Option Greeks Using a Spreadsheet (or Python)
#Calculating #Option #Greeks #Spreadsheet #Python
Calculating Option Greeks Using a Spreadsheet (or Python)
financial greeks
See all the latest ways to make money online: See more here
See all the latest ways to make money online: See more here
18 comments
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
Hi, if the k is different for put, what should I do then ?
Hello Kevin. Can you please explain how to Automate these Greeks values?
Excellent video !
Thanks for sharing. Is it possible to calculate the implied volatility as well?
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.
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.
Thanks!!! Just what I need for my PHP dashboard system. Great Job!!
please make a video why theta not correct?
can you please check why theta is different with tastyworks
why is theta not the same like in tasty trade
everything is okay but theta not correct.
I see theta is multiplied by the number of shares per contract (100).
Is it the only Greek affected by that multiplier? Thank you…
Thanks…..To calculate N(d1) and N(d2) this might help: https://youtu.be/-Hl-c0_RjxA
Great job! Thanks a lot!
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?
Thanks for your valuable services, much appreciated 🙂
Great video!