Option StrategiesOptionsOptions strategies

Long Strangle Option Strategy (Using Excel Template)

Written by Anangsha Saha (Individual Contributor)
Wed Mar 10 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

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


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


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. 


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.


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.



Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

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

Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
BWX Technologies Inc. logo

BWX Technologies Inc.

Optionable: Yes
Market Cap: 4,846 M
Industry: Aerospace & Defense
52 week range    
Ritchie Bros. Auctioneers Incorporated logo

Ritchie Bros. Auctioneers Incorporated

Optionable: Yes
Market Cap: 6,928 M
Industry: Business Services
52 week range    
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
General Mills Inc. logo

General Mills Inc.

Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
CRA InternationalInc. logo

CRA InternationalInc.

Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
ConAgra Brands Inc. logo

ConAgra Brands Inc.

Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
Agree Realty Corporation logo

Agree Realty Corporation

Optionable: Yes
Market Cap: 5,522 M
Industry: REIT - Retail
52 week range    
International Money Express Inc. logo

International Money Express Inc.

Optionable: Yes
Market Cap: 781 M
Industry: Business Services
52 week range    

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!