tastylive logo
uploaded image

Free Options Pricing Spreadsheet

By:Michael "Dr. Data" Rechenthin

One of the best ways to learn how options work is by seeing how changing inputs affects prices

Here in nerd land, we believe one of the best ways to learn how options work is by seeing how changing inputs affects prices. Those inputs would include stock price, strike price, volatility, time to expiration and interest rates. By experimenting with differing scenarios, you can immediately see the results, which builds intuition about options pricing.

Link is HERE.

cherrypicksmay13 image1.png


You’ll notice actual prices may differ from what the spreadsheet suggests. This is totally normal. Actual prices are affected by factors and forces like supply and demand, dividends and volatility skew. So, don't be concerned.


cherrypicksmay13 image2.png



Biggest S&P 500 Movers for the Month

Check out the following:


cherrypicksmay13 image3.png



cherrypicksmay13 image4.png



Two Trade Ideas

QQQ ($511.54) Put Diagonal Spread (JUL/JUN) $7.85 Debit

A monster rally during the last couple weeks has sent the stock market soaring by 20% or so from the lows with a huge vol crush. The VIX is back below 18! If you rode the wave higher and are looking for a little bit of short delta here, then a put diagonal spread trades cheaply relative to the delta. Go long the 500 put in July, with a short put at 480 in June, which will net around 20 short delta for just a $7.85 debit.


cherrypicksmay13 image5.jpg



TGT ($99.93) Put Ratio Spread (JUN) $1.14 Credit

Target (TGT) is one of the few remaining stocks with an upcoming earnings announcement. The company reports on May 21 before the market opens. The stock has been hammered — it's a couple of dollars off the 52-week low with an IVR at 72. If you think the bad news might already be baked in, then a put ratio spread plays into the upside with a wide buffer to the downside. Being long the 95 put and short 2x the 90 puts in June trades for a $1.14 credit with a breakeven down near lows.


cherrypicksmay13 image6.jpg




Our newsletter even counts as "research" when your boss walks by. Forward this email to your friends so they can subscribe to our newsletters, too! Get weekly data-driven trade ideas with Cherry Picks and daily pre-market insights and trade ideas with Cherry Bomb.
Michael Rechenthin, Ph.D., (aka “Dr. Data”), managing director of research and development, has 25 years of trading and markets experience. He’s known best for his weekly Cherry Picks newsletter. On Thursdays, he appears on Trades from the Research Team LIVE.

Nick Battistatastylive director of market intelligence, has a decade of trading experience. He appears Monday-Friday on Options Trading Concepts LiveOn Wednesdays, he co-hosts Johnny Trades@tradernickybat

For live daily programming, market news and commentary, visit tastylive or the YouTube channels tastylive (for options traders), and tastyliveTrending for stocks, futures, forex and macro.

Trade with a better broker. Open a tastytrade account today. tastylive Inc. and tastytrade Inc. are separate but affiliated companies.




Options involve risk and are not suitable for all investors. Please read Characteristics and Risks of Standardized Options before deciding to invest in options.

Related Posts

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