For the Excel spreadsheet used in the show, please click HERE
Calling all Nerds. Michael Rechenthin, PhD provides an Excel spreadsheet that helps new option traders understand how options react to changes in inputs.
Data joined the guys to introduce and explain his latest free download.
Options A to Z - Expected Price Calculator
It’s a handy Excel spreadsheet which can calculate option prices and it can also visualize the Greeks. It can help traders understand how prices change in reaction to different inputs and the visualization tab provides graphs of the different Greeks (Delta, Gamma, Theta, Vega) and option prices to aid in your understanding.
Additionally there is a useful dictionary of terms.
Mike first discussed the spreadsheet and then demonstrated its use. He also explained how all of the Excel Functions can be called within the spreadsheet to create personalized tabs to build or customize your own analysis.
Dr. Data mentioned that there are other free downloads created, but none are as elegant and easy to use as this one.
Watch the segment for the full demonstration and download the Spreadsheet using one of the links above and then give it a spin.
For more incredible spreadsheets from Dr. Data see:
Watch this segment of Skinny on Options Data Science with Tom Sosnoff, Tony Battista and Dr.
Data , aka Michael Rechenthin, Ph.D. for an explanation and demonstration of this handy free downloadable Excel spreadsheet and a bonus take away from Tom.