For the Excel spreadsheet used in the show, please click [HERE].
SUMMARY
Calling all Nerds. Michael Rechenthin, PhD provides an Excel spreadsheet that helps new option traders understand how options react to changes in inputs.
Dr. Data joined the guys to introduce and explain his latest free download. 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:
The Skinny On Options Data Science from September 08, 2016: "MAX. ROC on Covered Calls (w/Spreadsheet)"
The Skinny On Options Data Science from September 15, 2016: "Probabilistic Stock Outcomes (w/Spreadsheet)"
The Skinny On Options Data Science from September 29, 2016: "Hedging a Large Account (w/Spreadsheet)"
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.
This video and its content are provided solely by tastylive, Inc. (“tastylive”) and are for informational and educational purposes only. tastylive was previously known as tastytrade, Inc. (“tastytrade”). This video and its content were created prior to the legal name change of tastylive. As a result, this video may reference tastytrade, its prior legal name.