The Skinny On Options Data Science

Hedging a Large Account (w/ Spreadsheet)

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

    Hedging a Large Account (w/ Spreadsheet)

    Sep 29, 2016

    For the Windows version, click HERE
    For the Mac version (or those without thinkorswim), click HERE

    Note: You will need Microsoft Excel for the spreadsheet to work correctly. Prices will automatically update only for those running thinkorswim and only for those using the Windows operating system.

    The head of our research team, Michael Rechenthin, Ph.D., (aka Dr. Data) created a downloadable spreadsheet (both a Windows version and a Mac version) that will work with the thinkorswim platform and can help you with either your hedging needs or in constructing a Pairs Trade. Dr. Data first explains dollar weighted hedges and Implied Volatility (IV) hedges and how they perform differently. He then explained how to use the spreadsheet and how it could be used.

    Mike first explained a dollar weighted hedge (or dollar weighted pairs trade) and provided the formula. The example was of SPY at $215/share and IWM at $124/share. $215 multiplied by 100 shares and then divided by $124 results in just over 173, so it takes 173 shares of IWM to hedge or match up in a pairs prade with SPY. He then noted that although the correlation was very high at 0.90 the Russell 2000 has a higher IV than the S&P 500. Dr. Data then provided the formula for an IV weighted hedge (or pairs trade). The result was that one would use 125 shares of IWM to offset 100 shares of SPY. A final slide showed a graph of both a dollar weighted hedge and an IV adjusted one using a short term bond versus a long term bond. The IV adjusted duo was much more stable.

    The rest of the segment was all about Mike’s spreadsheet. The Windows version only requires you to enter the symbols and position size that you want hedged. The Mac version requires you to enter more fields. Both Futures and equities (including ETFs) can be plugged into the spreadsheet. Prices, IV and the resulting figures work dynamically in the Windows version. It is elegant in its simplicity and every trader will find it very helpful.

    Watch this segment of Skinny on Options Data Science with Tom Sosnoff, Tony Battista and Dr. Data, aka Michael Rechenthin, Ph.D., for a better understanding of dollar weighted hedging, IV adjusted hedging and for a “game changer” downloadable spreadsheet which traders can use to calculate hedges or share amounts for pairs trades.

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