The Skinny On Options Data Science

# Probabilistic Stock Outcomes (w/ Spreadsheet)

| Sep 15, 2016
Up Next
The Skinny On Options Data Science

# Probabilistic Stock Outcomes (w/ Spreadsheet)

Sep 15, 2016

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

SUMMARY
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.

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.

#### More like this

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 - 2023 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.