Option StrategiesOptionsOptions strategies

Option Trading With Ms Excel-Protective Puts Strategy

Written by Robin Bisarya
Fri Mar 05 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

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.

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.

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.

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.

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.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

108.01
 
USD
 
-0.39
 
(-0.36%)
84
Rank
Optionable: Yes
Market Cap: 8,953 M
Industry: Auto & Truck Dealerships
52 week range    
72.35   
   119.47
Zim Integrated Shipping Services Ltd logo

Zim Integrated Shipping Services Ltd

64.70
 
USD
 
0.94
 
(1.47%)
80
Rank
Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
33.71   
   91.23
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

24.07
 
USD
 
-0.55
 
(-2.23%)
79
Rank
Optionable: No
Market Cap: 684 M
Industry: Trucking
52 week range    
15.86   
   26.90
NRG Energy Inc. logo

NRG Energy Inc.

45.72
 
USD
 
-0.49
 
(-1.06%)
79
Rank
Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
31.94   
   46.86
Corteva Inc. logo

Corteva Inc.

59.23
 
USD
 
0.23
 
(0.39%)
79
Rank
Optionable: Yes
Market Cap: 41,692 M
Industry: Agricultural Inputs
52 week range    
40.60   
   62.04
Avnet Inc. logo

Avnet Inc.

46.30
 
USD
 
-0.27
 
(-0.58%)
78
Rank
Optionable: Yes
Market Cap: 4,732 M
Industry: Electronics Distribution
52 week range    
35.71   
   48.75
Universal Corporation logo

Universal Corporation

59.59
 
USD
 
-0.47
 
(-0.78%)
77
Rank
Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
46.24   
   63.46
Kronos Worldwide Inc logo

Kronos Worldwide Inc

17.50
 
USD
 
-0.52
 
(-2.89%)
77
Rank
Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
12.06   
   18.48
Boise Cascade L.L.C. logo

Boise Cascade L.L.C.

76.72
 
USD
 
-1.29
 
(-1.65%)
77
Rank
Optionable: Yes
Market Cap: 3,260 M
Industry: Lumber & Wood Production
52 week range    
46.51   
   85.17
Rollins Inc. logo

Rollins Inc.

35.28
 
USD
 
0.95
 
(2.77%)
76
Rank
Optionable: Yes
Market Cap: 17,428 M
Industry: Business Services
52 week range    
28.51   
   40.11

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!