InformativeOption StrategiesOptionsTemplates

Reverse Iron Condor Options Strategy (Using Excel Template)

Written by Syed Hammadahmed (Individual Contributor)
Thu Jun 17 2021
Reverse Iron Condor
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Reverse Iron Condor
 

Introduction

Reverse Iron Condor strategy is an advanced Option Strategy. It is primarily used in volatile market conditions. The Reverse Iron Condor is a limited profit, limited risk trading strategy that is designed to make some profit when the underlying stock price makes a sharp move in either direction.

The strategy involves entering into four different transactions i.e. 2 Call (one long & one short) and 2 Put (one long & one short) options, and is used when the investor is not sure of the direction in which the price of the security may move.

Reverse Iron Condor

Reverse Iron Condor Construction

To implement and execute this strategy, the investor will trade in four different contracts. The investor can decide whether to carry out all the trades at the same time or not.

The four trading contracts will be:

  • Buying an OTM (out of the money) Put option
  • Selling an OTM Put option at a lower strike price
  • Buying an OTM Call option
  • Selling an OTM Call option at a higher strike price

To set up a reverse iron condor, the options trader buys an OTM put with a strike price below the current stock price, sells an even lower strike OTM put, buys an OTM call with a strike price above the current stock price and sells another even higher strike OTM call. A net debit is taken to enter this trade.

Limited Profit

Maximum profit for the reverse iron condor strategy is limited but considerably higher than the maximum possible loss. It is attained when the underlying stock price drops below the strike price of the Short Put or rises above the higher strike price of the Short Call. In either situation, maximum profit is equal to the difference in strike prices between the puts (or calls) minus the net debit taken when initiating the trade.

Maximum Profit can be calculated with the formula:

Max Profit = Strike Price of Short Call – Strike Price of Long Call (or) Strike Price of Long Put – Strike price of Short Put – Net Premium Paid – Commissions Paid

Max Profit is achieved when Price of Underlying < Strike Price of Short Put 

                                                            (OR)

Max Profit is achieved when Price of Underlying > Strike Price of Short Call

Limited Loss

Maximum loss for the Reverse Iron Condor strategy is also limited and is equal to the net debit (net cash outflow) taken when entering the trade. Maximum loss occurs when the underlying stock price at expiration is between the strikes of the Long Put and the Long Call. At this level, all the options expire worthless and the trader is left with nothing except a loss equal to the initial debit taken.

Maximum Loss can be calculated with the formula:

Max Loss = Net Premium Paid + Commissions Paid

Max Loss Occurs When Price of Underlying is in between the Strike Prices of the Long Put and the Long Call

Breakeven Points

The reverse iron condor position has 2 break-even points: 

Reverse Iron Condor Breakeven Points
  • Upper Breakeven Point = Strike Price of Long Call + Net Premium Paid
  • Lower Breakeven Point = Strike Price of Long Put – Net Premium Paid

Applying Reverse Iron Condor Strategy Using MarketXLS Template With an Example:

MarketXLS software is a one-stop solution for the analysis of your entire investments. It provides a host of functions like eps, various ratios, key fundamentals, historical data, options pricing and much more to assess the value of your investments. It provides a variety of templates for various options trading strategies and also to compare your portfolio stocks for doing a better analysis of your investments.

Reverse Iron Condor

Link to the Template: https://marketxls.com/template/reverse-iron-condor-spread/

Step 1: Enter the stock ticker in cell D6 and press enter. The template will provide the upcoming expiry dates for the stock, current market price and lot size. Select any one of the expiry dates and change the lot size according to your preference.

Step 2: Enter the 4 strike prices i.e. OTM Strike Price for Call, Far OTM Strike Price for Call, OTM Strike Price for Put and Far OTM Strike Price for Put in the respective yellow cells. Press enter.

Step 3: The template might ask you to refresh. Go to the MarketXLS tab in the ribbon > Refresh All. Click on Refresh All.

The template uses the bid price for sells and ask price for buys and related premiums to calculate the net cash flow (net debit to be paid) for you.

Reverse Iron Condor Template

Step 4: The template also provides the Net Payoff Profile of the strategy. You need to enter the minimum and maximum expiry prices for the period. It will calculate the net profit or net loss for all the levels of expiry prices and present it graphically.

Microsoft Corporation (MSFT) as an example in the above template: 

MSFT stock is trading at levels of $257 on 14th June 2021. I have selected the upcoming expiry of 25/06/21 to enter the trade. I want to execute a reverse iron condor by buying a Call @$265, selling a Call @$270, buying a Put @$250 and selling another Put @$245.

The template will calculate the premium amounts for all the options and thus calculate the net cash flow for entering the trade, which is $88 in this case.

[ 0.41*100 ($245 strike) – 0.83*100 ($250 strike) – 0.69*100 ($265 strike) + 0.23*100 ($270 strike) = -$88 ]

Suppose if the stock keeps trading at $257 till expiration, all 4 options will expire worthless. Since a net debit of $88 is being taken to enter the trade, I will suffer a loss of $88. This is also my maximum possible loss.

If the stock trades at $245 on the expiration date, only the Long Put option at $250 expires in the money. This Put option will be worth $500 ( a lot of 100 shares ) and therefore my net profit will be $412 after deducting the initial $88 debit. This profit can be easily determined by looking at the net payoff table within the template (4.12*100). A similar situation occurs when the stock trades at $270 at expiration. In this case, only the Long Call option at $265 expires in the money and it is also worth $412 after deducting the premium paid.

Here is a video explaining the Reverse Iron Condor Strategy using MarketXLS: https://youtu.be/bqKAEYpVGIs

Bottom Line

If one is expecting a security to move significantly but is not sure in which direction it will move, this is a good strategy to implement. The maximum loss and the maximum profit are both predictable, and one can adjust the strikes to determine how much they wish to make and how much they need the price of the security to move by.

The main downside is that it is a complicated strategy to use. The fact that there are four transactions involved also means that you will pay a fair amount in commission charges.

Disclaimer

All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own, or affiliation with the trademark owners.
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.

Reference

https://www.theoptionsguide.com/reverse-iron-condor.aspx

https://top10stockbroker.com/option-trading/reverse-iron-condor-spread/

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

Sanderson Farms Inc. logo

Sanderson Farms Inc.

218.61
 
USD
 
-1.29
 
(-0.59%)
81
Rank
Optionable: Yes
Market Cap: 4,908 M
Industry: Packaged Foods
52 week range    
175.42   
   221.63
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

49.95
 
USD
 
0.21
 
(0.42%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Gaming and Leisure Properties Inc. logo

Gaming and Leisure Properties Inc.

46.12
 
USD
 
-0.56
 
(-1.20%)
79
Rank
Optionable: Yes
Market Cap: 11,555 M
Industry: REIT - Diversified
52 week range    
40.57   
   48.57
General Mills Inc. logo

General Mills Inc.

74.72
 
USD
 
4.46
 
(6.35%)
79
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   73.99
National Retail Properties logo

National Retail Properties

44.27
 
USD
 
0.11
 
(0.25%)
78
Rank
Optionable: Yes
Market Cap: 7,768 M
Industry: REIT - Retail
52 week range    
39.12   
   48.19
Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

34.31
 
USD
 
-0.91
 
(-2.58%)
77
Rank
Optionable: Yes
Market Cap: 421 M
Industry: Capital Markets
52 week range    
30.71   
   53.17
Kronos Worldwide Inc logo

Kronos Worldwide Inc

18.47
 
USD
 
-0.70
 
(-3.65%)
77
Rank
Optionable: Yes
Market Cap: 2,213 M
Industry: Specialty Chemicals
52 week range    
11.64   
   19.78
Cowen Inc. logo

Cowen Inc.

25.01
 
USD
 
-0.34
 
(-1.34%)
75
Rank
Optionable: Yes
Market Cap: 704 M
Industry: Capital Markets
52 week range    
21.35   
   41.61
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

62.82
 
USD
 
-0.80
 
(-1.26%)
75
Rank
Optionable: Yes
Market Cap: 8,600 M
Industry: Specialty Retail
52 week range    
45.85   
   74.09
Strategic Education Inc. logo

Strategic Education Inc.

68.03
 
USD
 
-2.49
 
(-3.53%)
74
Rank
Optionable: Yes
Market Cap: 1,760 M
Industry: Education & Training Services
52 week range    
47.09   
   80.29

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!