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

Long Strangle Option Strategy (Using Excel Template)

Written by Anangsha Saha (Individual Contributor)
Wed Mar 10 2021
Long Strangle Option Strategy (Using Excel Template) - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Long Strangle Option Strategy (Using Excel Template) - MarketXLS

A long strangle is a neutral strategy that involves simultaneously buying a slightly out of the money put option (having a lower strike price) and a slightly out-of-the-money call option (having higher strike price) of the same underlying asset and same expiration date. Long strangle strategies are debit spreads because a net debit is required to enter the trade. It is established for a net debit and profits if the underlying stock price rises above the upper breakeven point or falls below the lower breakeven point. 

The profit potential is unlimited, while the maximum loss is limited to the total cost of the strangle option.

Let us see how we can use the MarketXLS Template to understand the long strangle option strategy

In the template:

* Mention the stock ticker

* Enter the expiry date of the option. A list of upcoming expiry dates has been provided adjacent to the input.

* Enter the OTM strike price for the put and call option.

long strangle

Consider Microsoft Corp. (MSFT). In this example, we have chosen the expiry date to be 19/02/2021. The OTM strike price for put and call options are $240 and $250, respectively.

The template then calculates the bid-ask spread and the net cash flow. A high bid-ask spread of 10% in the put option signifies high volatility, while a low spread of 5% in the call option signifies greater liquidity of the security.

long strangle

Profits and Losses

Profit

A long strangle option strategy is profitable when the price of the underlying asset rises above the upper breakeven point or falls below the lower breakeven point. Considerable gains are possible, which may be calculated using the following formulae:

• Maximum Profit = Unlimited

• Profit Achieved When Price of Underlying > Strike Price of Long Call + Net Premium Paid OR Price of Underlying < Strike Price of Long Put – Net Premium Paid

• Profit = Price of Underlying – Strike Price of Long Call – Net Premium Paid OR Strike Price of Long Put – Price of Underlying – Net Premium Paid

Risk

The maximum risk for a long strangle strategy is realised when the underlying stock price at expiration is between the strike prices of the options bought. In this scenario, both the call and put options expire worthlessly, and the trader loses his entire initial debit undertaken to enter the trade. 

Breakeven

The long strangle strategy has two breakeven points which can be calculated using the following formulae:

• Upper Breakeven Point = Strike Price of Long Call + Net Premium Paid

• Lower Breakeven Point = Strike Price of Long Put – Net Premium Paid

long strangle diagram

Understanding the market forecast

Changes in stock price

When the stock price lies between the upper and lower stock prices, then the call option’s positive delta and the negative delta of the put option offset each other, so for small changes in prices between the strike prices, the strangle has a ‘near-zero delta.

If the stock price rises fast, the call increases in price more than the outfalls in price, and if the stock price falls fast, then the put rises in price more than the call falls. In this case, the strangle has a positive gamma. A positive gamma implies that the delta of a stock position changes in the same direction as the change in the underlying stock price. 

Change in volatility

As volatility rises, the options price and the strangle’s price rise if factors like stock price and expiration time remain constant. When volatility increases, the price of long strangles increase, and they become more profitable, so they have a positive vega. A positive vega means that a position profits if the volatility rises and makes losses if the volatility falls. 

Impact of time

Long strangles consist of two long options, so their sensitivity to time erosion or decay is higher than that of single option strategies. Thus, long strangles tend to incur more losses as time passes if the stock price doesn’t change.

The bottom line

The long strangle option strategy has some significant advantages. Firstly, the cost and maximum risk of one strangle is lower than that for one straddle. Secondly, for a fixed amount of capital, more strangles can be purchased. However, strangles are more sensitive to time decay than other strategies, and there is a greater chance of losing 100% of the strangle’s cost if it is held to expiration. The templates provided by MarketXLS are easy to use and can help you track your options with ease.

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

https://www.fidelity.com/learning-center/investment-products/options/options-strategy-guide/long-strangle

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

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

Get started today

Top MarketXLS Rank stocks

Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

52.88
 
USD
 
1.12
 
(2.16%)
85
Rank
Optionable: Yes
Market Cap: 2,812 M
Industry: Auto & Truck Dealerships
52 week range    
42.72   
   55.06
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

126.10
 
USD
 
1.70
 
(1.37%)
84
Rank
Optionable: Yes
Market Cap: 8,021 M
Industry: Specialty Retail
52 week range    
101.58   
   176.89
Magnolia Oil & Gas Corporation Class A logo

Magnolia Oil & Gas Corporation Class A

23.81
 
USD
 
0.70
 
(3.03%)
83
Rank
Optionable: Yes
Market Cap: 4,657 M
Industry: Oil & Gas E&P
52 week range    
18.01   
   30.31
Foot Locker Inc. logo

Foot Locker Inc.

43.30
 
USD
 
2.59
 
(6.36%)
83
Rank
Optionable: Yes
Market Cap: 3,673 M
Industry: Footwear & Accessories
52 week range    
23.85   
   45.59
Shoe Carnival Inc. logo

Shoe Carnival Inc.

27.66
 
USD
 
-1.04
 
(-3.62%)
82
Rank
Optionable: Yes
Market Cap: 747 M
Industry: Apparel Stores
52 week range    
19.43   
   36.48
Group 1 Automotive Inc. logo

Group 1 Automotive Inc.

206.44
 
USD
 
9.36
 
(4.75%)
82
Rank
Optionable: Yes
Market Cap: 2,814 M
Industry: Auto & Truck Dealerships
52 week range    
136.16   
   206.49
Boot Barn Holdings Inc. logo

Boot Barn Holdings Inc.

87.42
 
USD
 
13.05
 
(17.55%)
81
Rank
Optionable: Yes
Market Cap: 2,188 M
Industry: Apparel Stores
52 week range    
50.20   
   105.66
Weis Markets Inc. logo

Weis Markets Inc.

87.46
 
USD
 
1.22
 
(1.41%)
80
Rank
Optionable: Yes
Market Cap: 2,298 M
Industry: Grocery Stores
52 week range    
58.40   
   95.57
PulteGroup Inc. logo

PulteGroup Inc.

52.37
 
USD
 
0.39
 
(0.75%)
80
Rank
Optionable: Yes
Market Cap: 11,760 M
Industry: Residential Construction
52 week range    
35.03   
   54.71
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

122.57
 
USD
 
2.42
 
(2.01%)
80
Rank
Optionable: Yes
Market Cap: 8,328 M
Industry: Auto & Truck Dealerships
52 week range    
88.58   
   131.55

More Features