How do you construct a $100k portfolio, using just ETFs and futures? Find out in the new Top Dogs series.
tastytrade logo
The Skinny On Options Data ScienceProbabilistic Stock Outcomes (w/ Spreadsheet) | Sep 15, 2016
Up Next
    The Skinny On Options Data ScienceProbabilistic Stock Outcomes (w/ Spreadsheet)Sep 15, 2016

    For the Mac version, click here
    For the Windows version, click here

    The Black-Scholes formula for pricing options assumes stocks will have a normal distribution (a graph provided an example of a normal distribution). Using that assumption we can calculate the probability that a stock will fall between two price points (or above or below a single price point) and different variations. How do we do that? Michael Rechenthin, Ph.D., the head of our research team, aka Dr. Data, joins the guys to use the tools of Data Science to explain things in a way that is easily understood. He also has a spreadsheet available in both Windows and Mac versions for download (see links at top) that will help calculate more complex probabilities.

    A graph of two separate methods to find out the probability that a stock will fall between Price X1 and Price X2 was displayed. Method 1 was the one found in most textbooks while method 2 “calculated the probability of things falling on the extremes” and is the way many traders think.

    Getting more complicated, Mike next explained how we would calculate the probability that stock A would fall below price 1 and that stock B would fall below price 2 which someone doing a Pairs Trade would find of interest. Should there be no correlation between the stocks it’s a simple multiplication problem. The chance for stock A is 72% and for B is 40%, so 0.72 multiplied by 0.40 is 0.288 which is rounded off to 29%. Given a perfect correlation between the two the calculation is simply to take the lower of the two probabilities (40%).

    Dr. Data wrapped things up by explaining how his spreadsheet works. The Windows version works easily with thinkorswim while the Mac version requires manual inputs. It can calculate the probabilitiy of both single options like a short Put or something more complex like a short Straddle or Strangle.

    Watch this segment of Skinny on Options Data Science with Tom Sosnoff, Tony Battista and Dr. Data, aka Michael Rechenthin, Ph.D., to find out the probability of a stock, option or option strategy being above or below a certain price, between two prices as well as more complicated equations all made simple using Dr. Data’s incredible spreadsheet.

    More like this

    tastytrade content is provided solely by tastytrade, Inc. (“tastytrade”) 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, transaction or investment strategy is suitable for any person. Trading securities can involve high risk and the loss of any funds invested. tastytrade, 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. tastytrade 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), comparison, statistics, or other technical data, if applicable, will be supplied upon request. tastytrade is not a licensed financial advisor, registered investment advisor, or a registered broker-dealer. Options, futures and futures options are not suitable for all investors. Prior to trading securities products, please read the Characteristics and Risks of Standardized Options and the Risk Disclosure for Futures and Options found on 

    tastytrade is a trademark/servicemark owned by tastytrade.

    tastyworks, Inc. ("tastyworks") is a registered broker-dealer and member of FINRA, NFA and SIPC. tastyworks offers self-directed brokerage accounts to its customers. tastyworks 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 tastyworks’ systems, services or products. tastyworks is a wholly owned subsidiary of tastytrade, Inc (“tastytrade”).

    tastyworks, Inc. (“tastyworks”) has entered into a Marketing Agreement with tastytrade (“Marketing Agent”) whereby tastyworks pays compensation to Marketing Agent to recommend tastyworks’ brokerage services. The existence of this Marketing Agreement should not be deemed as an endorsement or recommendation of Marketing Agent by tastyworks. tastytrade is the parent company of tastyworks. tastyworks and Marketing Agent are separate entities with their own products and services. tastytrade has different privacy policies than tastyworks.

    Quiet Foundation, Inc. (“Quiet Foundation”) is a wholly-owned subsidiary of tastytrade The information on is intended for U.S. residents only. All investing involves the risk of loss. Past performance is not a guarantee of future results. Quiet Foundation does not make suitability determinations, 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 Quiet Foundation’s systems, services or products.

    © copyright 2013 – 2022 tastytrade. All Rights Reserved. Applicable portions of the Terms of use on 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 tastytrade’s podcasts as necessary to view for personal use.