Option Trading with MS Excel: Protective Puts Strategy

Published
Option Trading With Ms Excel-Protective Puts Strat - options strategy analysis and payoff diagram in Excel with MarketXLS

A protective put means buying a put option on a stock you already own, so that if the price falls below the put's strike you can sell at the strike. Your maximum loss is the stock price minus the strike price plus the premium paid, your breakeven is the stock price plus the premium, and your upside stays unlimited. It works like insurance: you pay a premium to cap the downside for the life of the option. This article walks through a MarketXLS Excel template for the strategy. It is educational, not investment advice.

**Protective puts **The Protective Put strategy is used by investors to protect their capital gains from a decline in the stock price. Investors buy put options for a given premium to hedge their positions. In this strategy, investors buy put option contracts to hedge against a potential fall in stock price. This strategy is generally used when investors have made profits from stock price appreciation and want to hold stock further but do not want to risk their earnings from a decline in stock price again. This strategy is similar to the most widely used covered call strategy. The objective is the same in both the strategy; however, the significant difference lies in the execution. In a covered call, you write call option contracts while protective puts you buy put option contracts. From a profit/loss standpoint, a trader gets paid to open a covered call; there is a net cash outflow in case of protective puts.

Trading with MS Excel

Use the protective-put workbook and follow the workflow below.

##Input by userIn this section, you put the stock ticker and the expiry for the option of that underlying. You can select the expiry from section 2. Here, we have taken the example of AAPL (Apple Inc.) with an expiry of 19 Feb 2021.

##ExecutionA protective put adds one option leg to a stock position: buying a put, usually out of the money (strike below the current price). In the template example, the underlying is AAPL with a 19 Feb 2021 expiry, and the investor pays a premium of $145 per contract (100 shares). The maximum loss is the drop from the purchase price to the strike, plus that premium.

##Profit, loss, and breakevenThe historical example describes outcomes at various AAPL stock prices. Had the investor not bought put options, the loss would have been significant on the bearish side and it only increases with the stock price. The protective put limits the loss below the strike, while the profits remain unlimited on the bullish side. The breakeven point is the stock purchase price plus the premium paid per share.

##Key takeaways• A protective put limits losses on the bearish side while keeping profits unlimited on the bullish side.
• Since protective put is pretty straightforward, it is also suitable for beginners.
• Loss is limited to the stock price minus the strike, plus the premium, while profit is unlimited on the bullish side.
• An investor pays a premium upfront to open a trade with this strategy.

##DisclaimerNone of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.

The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.

the article is written for helping users collect the required information from various sources deemed to be an authority in their content. The trademarks if any are the property of their owners and no representations are made.

##** References** 

Learn more about protective put OptionsTrading.org protective-put guide.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

#1 Excel Solution for Investors

Get Market data in Excel easy to use formulas

  • Real-time Live Streaming Option Prices & Greeks in your Excel
  • Historical (intraday) Options data in your Excel
  • All US Stocks and Index options are included
  • Real-time Option Order Flow
  • Real-time prices and data on underlying stocks and indices
  • Works on Windows, MAC or even online
  • Implement MarketXLS formulas in your Excel sheets and make them come alive
  • Save hours of time, streamline your option trading workflows
  • Easy to use with formulas and pre-made templates
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
I use MarketXLS to manage my personal portfolio. I can easily pull in stock quotes, betas, and dividends. I also like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

•

Associate Professor of Finance, Penn State University

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

•

Professional Trader

I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying and pasting data from websites.

Samir Khan

•

InvestExcel.net

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year.

Kirubakaran K.

•

Investment Professional

I Love My MarketXLS. The market speaks to you when you know how to listen. With MarketXLS, the market truly does speak. Patterns emerge. Pricing behavior becomes clearer.

Don Zelezny

•

Entrepreneur & Options Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets