Alert

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 ScienceOption Pricing Calculator | Oct 6, 2016
Up Next
    The Skinny On Options Data ScienceOption Pricing CalculatorOct 6, 2016

    For the Excel spreadsheet used in the show, please click [HERE].



    SUMMARY

    Calling all Nerds. Michael Rechenthin, PhD provides an Excel spreadsheet that helps new option traders understand how options react to changes in inputs.

    Dr. Data joined the guys to introduce and explain his latest free download. It’s a handy Excel spreadsheet which can calculate option prices and it can also visualize the Greeks. It can help traders understand how prices change in reaction to different inputs and the visualization tab provides graphs of the different Greeks (Delta, Gamma, Theta, Vega) and option prices to aid in your understanding. Additionally there is a useful dictionary of terms.

    Mike first discussed the spreadsheet and then demonstrated its use. He also explained how all of the Excel Functions can be called within the spreadsheet to create personalized tabs to build or customize your own analysis. Dr. Data mentioned that there are other free downloads created, but none are as elegant and easy to use as this one. Watch the segment for the full demonstration and download the Spreadsheet using one of the links above and then give it a spin.

    For more incredible spreadsheets from Dr. Data see:

    Watch this segment of Skinny on Options Data Science with Tom Sosnoff, Tony Battista and Dr. Data , aka Michael Rechenthin, Ph.D. for an explanation and demonstration of this handy free downloadable Excel spreadsheet and a bonus take away from Tom.

    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 tastyworks.com. 

    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 quietfoundation.com 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 tastytrade.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 tastytrade’s podcasts as necessary to view for personal use.