SPREADSHEET LINKS:
Works for Windows and Mac based versions of Excel
NOTE:The price and the IV must be manually entered on the spreadsheet. Additionally, for a breakdown of the spreadsheet, please see the accompanying "Research Slides".
When one of our Rising Stars comes to town they invariably want to share their spreadsheet with us. We have an in-house star in the field of Data Science, Michael Rechenthin, Ph.D, aka Dr. Data. Today he unveils a very useful spreadsheet to share with all tastylivers (see the links above).
Mike said, “Data Science is about changing data into knowledge – making data actionable. I’ve previously explained the math around calculating a stock’s expected move based on its option prices. Today I’ll show my spreadsheet based on that segment.” “Calculating Stock Expected Moves” from April 29th, 2015.
Mike provides us with and then walks through all the components of his spreadsheet. The spreadsheet gives us the description,dollar per tick, current price, notional value and IV once we put in the symbol and amount of future contracts or shares. The spreadsheet also gives us the P/L expected range for 1, 2, 3 and 7 days on a given position. If the underlying price changes by a certain percentage, the spreadsheet provides the implied probability of that underlying closing above or below that amount over the next 1, 2, 3 and 7 days.
Plug the pertinent information into the yellow boxes and the spreadsheet constantly updates its information as the product moves in real time (see the note above). Dr. Data, with help from Tom and Tony, take you through the use of this program and the benefits. Download the appropriate spreadsheet and enjoy.
Watch this segment of "The Skinny on Options Data Science" with Tom Sosnoff, Tony Battista and Dr. Data (Michael Rechenthin, Ph.D), for an explanation on how to use this incredible spreadsheet, a valuable tool for your trading produced by Dr. Data.
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.