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 Robin Bisarya on 
Fri Mar 05 2021
 about Option StrategiesOptionsOptions strategies
Option Trading With Ms Excel-Protective Puts Strategy - MarketXLS
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!
Download Template →
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.

Improve your Options Trading

Use MarketXLS to stream real-time Stock Option Pricing in Excel. Save hundreds of hours searching for reliable financial information and get all the options data you need to make your trading decisions in real-time.

We respect your privacy and will never share your email.
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.

We respect your privacy and will never share your email.
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