Option StrategiesOptionsOptions strategies

Iron Condor (Excel Template)

Written by Ashesh Mathur (Individual Contributor)
Mon Mar 01 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

Iron Condor

The Iron condor is a limited risk, non-directional option trading strategy designed to have a significant probability of earning a small limited profit when the underlying security is perceived to have low volatility. The iron condor strategy can also be visualized as a combination of a bull put spread and a bear call spread.


The iron condor is an improvisation over the short strangle. The iron condor is a four-legged option setup.

  • Sell 1 OTM Put
  • Buy 1 OTM Put (Lower Strike)
  • Sell 1 OTM Call
  • Buy 1 OTM Call (Higher Strike)

I’ve used the MarketXLS template to set up Iron condor. As can be seen from the figure above, it has limited profit potential and limited downside risk.

How to use this template?

In the active template:

1. Mention the Stock symbol.

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

3. Enter the ATM Strike price.

4. Enter the Spread (Difference between higher and lower strike price).


While trading options, if you hedge your position, then the risk of losing capital reduces drastically. If your capital loss is minimal, then it implies that your broker’s risk is also minimum. Now, if the risk for the broker reduces, it also means the risk for the exchange reduces.

Generally speaking, the lesser the risk you carry, the lower the margin requirement. Higher the risk, the higher the margin requirement.

Therefore, this means whenever you initiate a hedged strategy, the margins blocked by your broker is less compared to the margin required for a naked position.

When to use this strategy?

This strategy lets you retain the premium as long as the stock price stays within a range. Besides, this is also a great way to trade volatility. Whenever you think the volatility has shot up and therefore the option premiums, then you’d want to be an options seller and pocket the high premiums. Short strangles is perfect for such trades.

However, the margin requirements for short strangle can be really high. An iron condor improvises a short strangle by plugging in the open ends. The risk in iron condor is completely defined. You have clear visibility on the worst-case scenario.

Hence, the strategy can be summarised as below-

  1. Spread – The difference between the sold strike and its protective strike.
  2. Max Profit = Net Premium Received – Commissions Paid
  3. Max Profit Achieved When Price of Underlying is in between Strike Prices of the Short Put and the Short Call
  4. Max Loss = Strike Price of Long Call – Strike Price of Short Call – Net Premium Received + Commissions Paid
  5. Max Loss Occurs When Price of Underlying >= Strike Price of Long Call OR Price of Underlying <= Strike Price of Long Put
  6. Upper Breakeven Point = Strike Price of Short Call + Net Premium Received
  7. Lower Breakeven Point = Strike Price of Short Put – Net Premium Received

Natural calendar spread, long put butterfly and iron butterfly are some of the similar strategies you might be interested in if you like Iron condor.

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 to help users collect the required information from various sources deemed an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.


To learn about short strangle, click here

To learn about long straddle, click 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.

Optionable: Yes
Market Cap: 8,953 M
Industry: Auto & Truck Dealerships
52 week range    
Zim Integrated Shipping Services Ltd logo

Zim Integrated Shipping Services Ltd

Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

Optionable: No
Market Cap: 684 M
Industry: Trucking
52 week range    
NRG Energy Inc. logo

NRG Energy Inc.

Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
Corteva Inc. logo

Corteva Inc.

Optionable: Yes
Market Cap: 41,692 M
Industry: Agricultural Inputs
52 week range    
Avnet Inc. logo

Avnet Inc.

Optionable: Yes
Market Cap: 4,732 M
Industry: Electronics Distribution
52 week range    
Universal Corporation logo

Universal Corporation

Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
Kronos Worldwide Inc logo

Kronos Worldwide Inc

Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
Boise Cascade L.L.C. logo

Boise Cascade L.L.C.

Optionable: Yes
Market Cap: 3,260 M
Industry: Lumber & Wood Production
52 week range    
Rollins Inc. logo

Rollins Inc.

Optionable: Yes
Market Cap: 17,428 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!