Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Option Trading With Ms Excel-Protective Puts Strategy

Written by  Shubham Shah on 
Fri Mar 05 2021
 about Option StrategiesOptionsOptions strategies
Option Trading With Ms Excel-Protective Puts Strategy - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
Option Trading With Ms Excel-Protective Puts Strategy - MarketXLS

Protective puts

As the name itself suggests, 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

Below is a screenshot of the complete excel template that marketXLS provides for this strategy. This template has five major components. Let’s break them down one by one.

Option Trading With Ms Excel-Protective Puts Strategy

Input by user

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

Option Trading With Ms Excel-Protective Puts Strategy

Execution

A protective put is one of the most straightforward strategies in options trading as it involves only one leg of buying an OTM put option contract. As I am writing this article, AAPL shares are trading at $125. Therefore, an investor would buy a put option out-the-money, say $135. The investor pays a premium of $145 to the writer. This is the maximum loss he would incur in this trade.

Option Trading With Ms Excel-Protective Puts Strategy

Profit, loss, and breakeven

The table and the graph below show how the trade will pan out at various AAPL stock prices. As you can see, 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 execution of a protective put helped the investor to limit his losses to a mere $145. However, the profits are unlimited on the bullish side. The breakeven point is at the strike price, which is $135.

Option Trading With Ms Excel-Protective Puts Strategy

Key takeaways

• A protective put is a high volatility strategy as the losses are limited on the bearish side, and the profits are unlimited on the bullish side.
• Since protective put is pretty straightforward, it is also suitable for beginners.
• Loss is limited to just the premium, while profit is unlimited on the bullish side.
• An investor pays a premium upfront to open a trade with this strategy.

Disclaimer

None 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 here.

Ad slot not ready
#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.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

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

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I 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

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord