Check out the top 4 stocks to watch in October 2022
tastytrade logo
The Skinny On Options Data ScienceHedging a Large Account (w/ Spreadsheet) | Sep 29, 2016
Up Next
    The Skinny On Options Data ScienceHedging 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.

    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.