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.
tastylive content is created, produced, and provided solely by tastylive, Inc. (“tastylive”) and is for informational and educational purposes only. It is not, nor is it intended to be, trading or investment advice or a recommendation that any security, futures contract, digital asset, other product, transaction, or investment strategy is suitable for any person. Trading securities, futures products, and digital assets involve risk and may result in a loss greater than the original amount invested. tastylive, through its content, financial programming or otherwise, does not provide investment or financial advice or make investment recommendations. Investment information provided may not be appropriate for all investors and is provided without respect to individual investor financial sophistication, financial situation, investing time horizon or risk tolerance. tastylive is not in the business of transacting securities trades, nor does it direct client commodity accounts or give commodity trading advice tailored to any particular client’s situation or investment objectives. Supporting documentation for any claims (including claims made on behalf of options programs), comparisons, statistics, or other technical data, if applicable, will be supplied upon request. tastylive is not a licensed financial adviser, registered investment adviser, or a registered broker-dealer. Options, futures, and futures options are not suitable for all investors. Prior to trading securities, options, futures, or futures options, please read the applicable risk disclosures, including, but not limited to, the Characteristics and Risks of Standardized Options Disclosure and the Futures and Exchange-Traded Options Risk Disclosure found on tastytrade.com/disclosures.
tastytrade, Inc. ("tastytrade”) is a registered broker-dealer and member of FINRA, NFA, and SIPC. tastytrade was previously known as tastyworks, Inc. (“tastyworks”). tastytrade offers self-directed brokerage accounts to its customers. tastytrade does not give financial or trading advice, nor does it make investment recommendations. You alone are responsible for making your investment and trading decisions and for evaluating the merits and risks associated with the use of tastytrade’s systems, services or products. tastytrade is a wholly-owned subsidiary of tastylive, Inc.
tastytrade has entered into a Marketing Agreement with tastylive (“Marketing Agent”) whereby tastytrade pays compensation to Marketing Agent to recommend tastytrade’s brokerage services. The existence of this Marketing Agreement should not be deemed as an endorsement or recommendation of Marketing Agent by tastytrade. tastytrade and Marketing Agent are separate entities with their own products and services. tastylive is the parent company of tastytrade.
tastycrypto is provided solely by tasty Software Solutions, LLC. tasty Software Solutions, LLC is a separate but affiliate company of tastylive, Inc. Neither tastylive nor any of its affiliates are responsible for the products or services provided by tasty Software Solutions, LLC. Cryptocurrency trading is not suitable for all investors due to the number of risks involved. The value of any cryptocurrency, including digital assets pegged to fiat currency, commodities, or any other asset, may go to zero.
© copyright 2013 - 2024 tastylive, Inc. All Rights Reserved. Applicable portions of the Terms of Use on tastylive.com apply. Reproduction, adaptation, distribution, public display, exhibition for profit, or storage in any electronic storage media in whole or in part is prohibited under penalty of law, provided that you may download tastylive’s podcasts as necessary to view for personal use. tastylive was previously known as tastytrade, Inc. tastylive is a trademark/servicemark owned by tastylive, Inc.