Reverse Iron Condor Options Strategy (Using Excel Template)

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://www.marketxlswp.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/

Verelq News |
27.04.2024

alexistogel

alexistogel

alexistogel

link alexistogel

alexistogel rtp

link alexistogel

situs alexistogel

alexistogel

alexistogel gacor

alexistogel rtp

alexistogel macau

alexistogel

link alternatif alexistogel

alexistogel

bandar alexistogel

situs alexistogel

bandar alexistogel

alexistogel terpercaya

alexistogel gacor

alexistogel terpercaya

alexistogel

alexistogel

alexistogel

situs alexistogel

alexistogel toto

alexistogel

alexistogel togel slot

slot gacor alexistogel

alexistogel gampang menang

alexistogel online

alexistogel

alexistogel 4d

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

agen togel online

شرط بندی پرسپولیس شرط بندی استقلال شرط بندی روی تراکتورسازی تبریز شرط بندی روی سپاهان شرط بندی رئال مادرید بارسلونا شرط بندی شرط بندی psg سایت شرط بندی جام جهانی شرط بندی جام جهانی 2026 سایت شرط بندی جام جهانی 2026 بازی انفجار رایگان سایت انفجار ضریب بالا بهترین سایت شرط بندی فارسی شرط بندی بدون فیلتر شرط بندی بازی رولت شرط بندی پوکر شرط بندی مونتی شرط بندی سنگ کاغذ قیچی شرط بندی بلک جک کرش رویال بت پاسور شرط شرط بندی تخته نرد آنلاین انفجار 2 بت شرط بندی بازی اسلات شرط بندی بازی پوپ سایت سامان بت ریور پوکر 2024 سایت 4030bet ورود به بازی انفجار دنس بت شرط بندی انفجار دنس آموزش بازی پوکر سایت شرط بندی 123 بهترین شرط بندی بهترین سایت شرط بندی انفجار اپلیکیشن بازی انفجار دانلود بازی انفجار انفجار بازی ربات بازی انفجار کازینو آنلاین ایرانی انفجار پولساز ورود به بازی انفجار بازی انفجار با شارژ 10 تومن سایت bet betyek وان ایکس برو آدرس سایت بت یک سایت دوست دختر اونلی فنز فارسی پیدا کردن دوست دختر ورود به ریور پوکر پدرام مختاری پویان مختاری نازنین همدانی مونتیگو داوود هزینه بیوگرافی آیسان اسلامی بیوگرافی دنیا جهانبخت سایت رسمی حسین تهی بیوگرافی کوروش وانتونز سایت آرتا وانتونز رها وانتونز بیوگرافی ربکا قادری سحر قریشی بیوگرافی تتلو بیوگرافی مهدی طارمی الناز شاکردوست سایت عادل فردوسی پور بیوگرافی نیلی افشار بیوگرافی محمدرضا گلزار سایت armin2afm بیوگرافی شادمهر عقیلی بیوگرافی سردارآزمون بیوگرافی علیرضا بیرانوند بیوگرافی رامین رضاییان وریا غفوری بیوگرافی علی دایی بیوگرافی پوریا پوتک مدگل سایت حصین بیوگرافی صدف طاهریان فرشاد سایلنت بیوگرافی آریا کئوکسر بیوگرافی sogang بیوگرافی میا پلیز بیوگرافی مهراد هیدن سایت رسمی سهراب ام جی بیوگرافی علیرضا جی جی بیوگرافی بهزاد لیتو اشکان فدایی بیوگرافی رضا پیشرو بیوگرافی گلشیفته بیوگرافی هیپ هاپولوژیست بیوگرافی سارن بیوگرافی آدام مرادی بیوگرافی محمد هلاکویی بیوگرافی علی حسنی سایت رسمی علی حسنی بیوگرافی ساسی خواننده بیوگرافی ابی باربد معصومی حسینی فایننس بیوگرافی امیرحسین نام آور بیوگرافی امین فردین بیوگرافی فرزاد وجیهی سایت سیب بت سایت jetbet آدرس جدید بت فوروارد وان ایکس بت سایت abt90 بازی انفجار سایت شرط بندی فاز بت بهترین سایت شرط بندی انفجار ورود به آلپاری آلپاری فارکس آدرس بروکر آلپاری بدون فیلتر ثبت نام در بروکر آلپاری فارسی صرافی کوکوین ربات فارکس بهترین سایت تتر

alexistogel toto online

bandar alexistogel

alexistogel bandar gacor

alexistogel link

alexistogel online

alexistogel bandar togel

link alternatif alexistogel

alexistogel

alexistogel

alexistogel

alexistogel daftar

alexistogel toto macau

alexistogel bandar macau

alexistogel slot

alexistogel agen slot

situs alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel bandar slot

alexistogel

Alexistogel Toto Macau

bandar alexistogel

slot alexistogel

alexistogel bandar togel

alexistogel

alexistogel slot

alexistogel

daftar alexistogel

alexistogel online

rtp alexistogel

alexistogel slot

alexistogel gacor

link alternatif alexistogel

alexistogel login

alexistogel

alexistogel slot dana

agen togel online

bandar togel online

alexistogel rtp

alexistogel slot

alexistogel daftar

slot online dana

situs slot online

alexistogel

bandar togel online

slot online terpercaya

togel slot online

agen slot online gacor

rtp live slot online

bandar slot online

bandar slot online gacor

agen slot online

daftar bandar togel slot

bandar togel online

togel slot hari ini

link alternatif togel slot

rtp slot online gacor

slot online gacor

alexistogel terpercaya

rtp slot gacor

slot online gacor

tips slot maxwin

togel slot gacor

prediksi togel

game slot gacor

trik slot online

prediksi togel jitu

game slot online

togel online terpercaya

daftar togel slot online

bandar togel terpercaya

slot online gacor

trik slot bonus

prediksi togel online

rtp slot online

panduan togel online

prediksi togel

RTP LIVE

Bandar Toto Macau

Situs Slot Gacor

bandarbola855 resmi

bandarbola855 gacor

bandarbola855 slot

link bandarbola855

bandarbola855 rtp

bandarbola855 link

bandarbola855 bandar

bandarbola855

bandarbola855 slot

bandarbola855 terpercaya

bandarbola855 slot

bandarbola855 daftar

bandarbola855 link

bandarbola855

bandarbola855

bandarbola855

iosbet

iosbet

link iosbet

slot online iosbet

iosbet link login

slot iosbet

iosbet gacor

iosbet

slot iosbet

agen iosbet

bandar iosbet

iosbet

iosbet link

iosbet

iosbet

iosbet

iosbet

liatogel

login liatogel

liatogel totomacau