Aeromir logo image
Aeromir Join page image

Easy Peasy Iron Condors (EPIC) Spreadsheet

NOTES

Easy Peasy Iron Condors (EPIC) Spreadsheet

Walkthrough Video

Version History

Version Date Description
0.69 31 Jan 2024 Added OCO capability to the STOP orders
0.68 16 Jan 2024 Removed check on startup for authentication
0.67 14 Jan 2024 Added an NLV and draw down target to the monitoring sheet.
    Added a total credit and % of NLV for the maximum profit calculation on the Home sheet
    Added a Max Loss calculation using multiple stops. If the loss exceeds the Max allowed drawdown, the number is in RED, otherwise it is GREEN
0.66 13 Jan 2024 Added a Change to SPX for each trade on the Monitoring sheet to the right of the SPX price when you clicked on the order button
0.65 13 Jan 2024 Added a check on the Home sheet if the call or put short strike is in the money, the strikes turn white on a red background as a warning
    Added conditional formatting on the Monitoring sheet when you enter a close price for a leg, non-relevant data is hidden
    Fixed a bug when loading five stops. The fifth stop was not being transferred to the Monitoring sheet
    Fixed a bug when pushing to the monitoring sheet and using multiple accounts. The values for one account are transferred now
    Added a check if the total condors * number of accounts is not equal to the total contracts. When getting the stop orders, an error message displays for you to set the accounts to 1 and try again
    Fixed a bug when using multiple accounts and multiple stops, the stops were not being distributed properly. Now they are
0.64 2 Jan 2024 Fixed the PNL calculation on the Monitoring sheet. Uses the current spread mark or the closed prices you enter
    Added shading to the Close Price columns on the Monitoring sheet as these are for your manual entry
    I save the SPX price when you click the "Condor" or "Put" or "Call" order buttons. This price is pushed to the Monitoring Sheet when you click the "Start Monitoring" button
0.63 2 Jan 2024 Added a Calculator sheet to estimate how many iron condors to trade in an account
    Added a Holidays sheet to correctly adjust the date to a day when the markets are open when opening the workbook
    Rebuilt the Monitoring sheet to improve the layout
0.62 27 Dec 2023 Added a new stop mode button on the Home sheet. Stops can always be spreads or shorts only if the long strike price is less than the settings C18 cell
0.61 8 Dec 2023 Rebuilt the Monitoring sheet. Big changes
    Version 0.61 walk through
0.60 7 Dec 2023 Added conditional formatting for Home!R21 if the cell has hand entered data versus a formula
    I reset the condor price in Home!R21 when rebuilding the option chain
0.59 4 Dec 2023 Added a Help sheet to show how to get authenticated
    Version 0.59 walk through
0.58 4 Dec 2023 Implemented an authentication button. Go to your profile on the member‘s site to get your key and enter it in Settings!E2
0.57 3 Dec 2023 Major update to the stop buttons on the Home sheet. You can now pick how many stops you want and the orders will be split up with the total number of contracts being correct.
    I started adding authentication to the spreadsheet. Some new things on the Home sheet but haven‘t been implemented yet.
0.56 2 Dec 2023 Added background coloring to the options you are long and short. When you select an option to sell, you now see where the short and long legs are. Comparing to the colored Delta column you can see if you will be stepping on strikes
    Added a Stop Mode button on the Home sheet. You can toggle between using separate stops for the puts and calls or the same (essentially MEIC or BEIC modes)
    Version 0.56 Walk Through
    Removed the 9/8 ratio and replaced with a 2/1 ratio on the home sheet spread ratios table
    Replaced the Delta column with Spread Sale price on the Monitoring sheet
    Added conditional formatting on the Home sheet to show put and call long and short strikes. I color code the Delta column. Red is a short strike and Blue is a long strike
    Added yellow highlighting to the long strike of the selected spread on the Home sheet.
0.55 28 Nov 2023 Added a Margin calculation on the Home sheet
    Minor bug fix
    Version 0.55 Walk Through
0.54 27 Nov 2023 Added a "Spread Ratios" table on the Home sheet. When you select a call and put spread, it calculates the ratio between the two spreads. You can click on the values in the W column to rebalance the condor spreads
    Updated the Put and Call Stop buttons based on the total contracts for each side. This uses the ratios you have defined.
    Fixed a bug on the Entry Times tables
    Added a "Market Closed" to the entry times if the current day is on a weekend
0.53 25 Nov 2023 Added a "Total Contracts" on the main sheet. You can type in a number or click the "Reset" button to reset the formula to calculate the total contracts
    Added a button to toggle a check to make sure the put and stop prices for one stop do not exceed the condor price.
    Fixed a bug when pushing a spread with four stops to the monitor tab
    Added an "Early Close" button. This adds 3.5 hours to the current time to adjust the entry times to the times on normal trading days.
    Stop buttons on the MEIC page now are color coded. If you have a number of condors divisible by three, the TWO buttons will be greyed out. Clicking on a TWO button gives an error message.
    Added a "Reset Sheet" button on the Monitoring sheet
    Fixed a bug on the FOUR BOTH stops button
    Fixed a bug when calculating the maximum price of a stop order versus the condor price if the Max = Entry Price button is active
    Added yellow background color to the J,K, T and U columns when pushing a trade to the Monitoring sheet
    Added a line on the monitoring sheet under the last row when adding a new trade
0.52 15 Nov 2023 Added a Position Delta and Difference between the put and call spreads on the main sheet
0.51 14 Nov 2023 Added conditional formatting to the Entry Times table
    Added conditional formatting to the EMR values on the Monitoring sheet
0.50 14 Nov 2023 Updated the MEIC sheet. All buttons on the MEIC sheet are now functional.
0.40 8 Nov 2023 Initial DEV release
Copyright 2018-2024 Aeromir Corporation. All rights reserved. Phone 719-413-4321 SMS
Blog | Privacy Policy | Billing Policy | Disclaimer and Terms of Use | Contact Us
YouTube Icon  Facebook Icon  Twitter Icon
IP address 172.69.58.151
Page Processing Time: 0.056 sec

Aeromir Corporation is NOT a Broker Dealer. Aeromir Corporation engages in trader education and training. Aeromir Corporation offers a number of products and services via the internet at aeromir.com. Aeromir Corporation offers web-based, interactive training courses on demand and live training.

The meetings, trade alerts, workshops, classes, webinars and seminars given by Aeromir Corporation are for educational purposes only. This information neither is, nor should be construed, as an offer, or a solicitation of an offer, to buy or sell securities. You shall be fully responsible for any investment decision you make, and such decisions will be based solely on your evaluation of your financial circumstances, investment objectives, risk tolerance, and liquidity needs.

Options, futures and currencies involve risks and are not suitable for all investors. Prior to buying or selling an option, you must receive a copy of Characteristics and Risks of Standardized Options. Copies are available from your broker, by calling 1-888-OPTIONS, or at www.theocc.com. The information on this web site is provided solely for general education and information purposes. No statement should be construed as a recommendation to buy or sell a security or to provide investment advice. You are fully responsible for any investment decisions you make. Such decisions should be based solely on your evaluation of your financial circumstances. Such decisions should be based solely on your evaluation of your financial circumstances, investment objectives, risk tolerance and liquidity needs. Supporting documentation for any claims, comparisons, statistics or other technical data in this presentation is available at Aeromir Corporation ([email protected]).

Past performance is not necessarily indicative of future results. Parameters relating to past performance of strategies discussed are not capable of being duplicated. In order to simplify the computations, slippage, commissions, fees, margin interest and taxes are not included in the examples used on this web site. These costs will impact the outcome of all stock and options transactions and must be considered prior to entering into any transactions. Multiple leg strategies involve multiple commission charges. Brokerage firms may require customers to post higher margins than the minimum margins specified on this web site. Investors should consult their tax advisor about any potential tax consequences. Simulated trading programs are designed with the benefit of hindsight. No representation is being made that any portfolio or trade will, or is likely to, achieve profits or losses similar to those shown. All investments and trades carry risks.

For personal use only. All information on this web site is for your personal, non-commercial use only. Commercial use requires the written permission of Aeromir Corporation and may involve licensing fees.

Attribution

Aeromir content may contain content from one or more of our partners.

OptionNET Explorer logo

OptionNet Explorer (ONE) software is copyrighted and owned by THJ Systems Ltd

https://aeromir.com/one

TradingView logo

TradingView online charting platform

https://aeromir.com/tv

thinkorswim logo

Thinkorswim software is copyrighted and owned by TD Ameritrade

https://thinkorswim.com

OptionOmega logo

OptionOmega is an online
option back testing platform

https://aeromir.com/optionomega

OptionOmega logo

Option Trader's Assistant is an online option analysis tool

https://aeromir.com/ota

THE RISK OF LOSS IN TRADING FUTURES, OPTIONS AND COMMODITIES CAN BE SUBSTANTIAL. YOU SHOULD THEREFORE CAREFULLY CONSIDER WHETHER SUCH TRADING IS SUITABLE FOR YOU IN LIGHT OF YOUR FINANCIAL CONDITION. IN CONSIDERING WHETHER TO TRADE OR TO AUTHORIZE SOMEONE ELSE TO TRADE FOR YOU, YOU SHOULD BE AWARE OF THE FOLLOWING:

IF YOU PURCHASE A COMMODITY OR EQUITY INDEX EXCHANGE OPTION, YOU MAY SUSTAIN A TOTAL LOSS OF THE PREMIUM AND OF ALL TRANSACTION COSTS.

IF YOU PURCHASE OR SELL A COMMODITY FUTURE OR SELL A COMMODITY OPTION, OR IF YOU PURCHASE OR SELL AN EQUITY INDEX EXCHANGE FUTURE OR SELL AN EQUITY INDEX EXCHANGE OPTION YOU MAY SUSTAIN A TOTAL LOSS OF THE INITIAL MARGIN FUNDS AND ANY ADDITIONAL FUNDS THAT YOU DEPOSIT WITH YOUR BROKER TO ESTABLISH OR MAINTAIN YOUR POSITION. IF THE MARKET MOVES AGAINST YOUR POSITION, YOU MAY BE CALLED UPON BY YOUR BROKER TO DEPOSIT A SUBSTANTIAL AMOUNT OF ADDITIONAL MARGIN FUNDS, ON SHORT NOTICE, IN ORDER TO MAINTAIN YOUR POSITION. IF YOU DO NOT PROVIDE THE REQUESTED FUNDS WITHIN THE PRESCRIBED TIME, YOUR POSITION MAY BE LIQUIDATED AT A LOSS, AND YOU WILL BE LIABLE FOR ANY RESULTING DEFICIT IN YOUR ACCOUNT.

UNDER CERTAIN MARKET CONDITIONS, YOU MAY FIND IT DIFFICULT OR IMPOSSIBLE TO LIQUIDATE A POSITION. THIS CAN OCCUR, FOR EXAMPLE, WHEN THE MARKET MAKES A "LIMIT MOVE".

AEROMIR CORPORATION SHALL HAVE NO LIABILITY FOR THE ACCURACY OF, OR FOR DELAYS OR OMISSIONS IN ANY OF THE INFORMATION PROVIDED TO TRADE ALERT SUBSCRIBERS. AEROMIR CORPORATION SHALL HAVE NO LIABILITY FOR ANY DAMAGES, WHETHER DIRECT OR INDIRECT, WHETHER LOST PROFITS, INDIRECT, SPECIAL OR CONSEQUENTIAL DAMAGES OF THE SUBSCRIBER OR ANY OTHER PERSON SEEKING RELIEF THROUGH SUBSCRIBER, EVEN IF AEROMIR CORPORATION HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN NO EVENT WILL THE LIABILITY OF AEROMIR CORPORATION TO SUBSCRIBERS OR ANY OTHER PERSON SEEKING RELIEF THROUGH SUBSCRIBER PURSUANT TO ANY CAUSE OF ACTION, WHETHER IN CONTRACT, TORT, OR OTHERWISE, EXCEED THE FEE PAID BY SUBSCRIBER OR ANY OTHER PERSON SEEKING RELIEF THROUGH SUBSCRIBER, AS APPLICABLE.

THE PLACEMENT OF CONTINGENT ORDERS BY YOU OR YOUR TRADING ADVISOR, SUCH AS A �STOP-LOSS OR "STOP-LIMIT" ORDER, WILL NOT NECESSARILY LIMIT YOUR LOSSES TO THE INTENDED AMOUNTS, SINCE MARKET CONDITIONS MAY MAKE IT IMPOSSIBLE TO EXECUTE SUCH ORDERS.

A "SPREAD" POSITION MAY NOT BE LESS RISKY THAN A SIMPLE "LONG" OR "SHORT" POSITION.

THE HIGH DEGREE OF LEVERAGE THAT IS OFTEN OBTAINABLE IN COMMODITY OR EQUITY INDEX EXCHANGE TRADING CAN WORK AGAINST YOU AS WELL AS FOR YOU. THE USE OF LEVERAGE CAN LEAD TO LARGE LOSSES AS WELL AS GAINS.

IN SOME CASES, MANAGED COMMODITY ACCOUNTS ARE SUBJECT TO SUBSTANTIAL CHARGES FOR MANAGEMENT AND ADVISORY FEES. IT MAY BE NECESSARY FOR THOSE ACCOUNTS THAT ARE SUBJECT TO THESE CHARGES TO MAKE SUBSTANTIAL TRADING PROFITS TO AVOID DEPLETION OR EXHAUSTION OF THEIR ASSETS. THIS DISCLOSURE DOCUMENT CONTAINS ON PAGES 13 - 14. A COMPLETE DESCRIPTION OF EACH FEE TO BE CHARGED TO YOUR ACCOUNT BY THE COMMODITY TRADING ADVISOR.

THIS BRIEF STATEMENT CANNOT DISCLOSE ALL THE RISKS AND OTHER SIGNIFICANT ASPECTS OF THE COMMODITY MARKETS. YOU SHOULD THEREFORE CAREFULLY STUDY THE DISCLOSURE DOCUMENT AND COMMODITY AND EQUITY INDEX EXCHANGE TRADING BEFORE YOU TRADE, INCLUDING THE DESCRIPTION OF THE PRINCIPAL RISK FACTORS OF THIS INVESTMENT, AT PAGES 16 - 18.

THIS COMMODITY TRADING ADVISOR IS PROHIBITED BY LAW FROM ACCEPTING FUNDS IN THE TRADING ADVISORS NAME FROM A CUSTOMER FOR TRADING COMMODITY INTERESTS. YOU MUST PLACE ALL FUNDS FOR TRADING IN THIS TRADING PROGRAM DIRECTLY WITH A FUTURES COMMISSION MERCHANT OR INTRODUCING BROKER. THE COMMODITIES TRADING FUTURES COMMISSION HAS NOT PASSED UPON THE MERITS OF PARTICIPATING IN A PARTICULAR INVESTMENT OR ON THE ADEQUACY OR ACCURACY OF THE DISCLOSURE STATEMENT.

Aeromir Corporation is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for Aeromir Corporation to earn fees by linking to Amazon.com and affiliated sites

The content of this website is provided for informational purposes only and may not be construed as an offer, for sale or purchase, of any investment product or advisory service. Such an offer may only be made to qualified individuals/entities via the appropriate offering/advisory documents.

Prior to buying or selling an option, investors must read a copy of the Characteristics & Risks of Standardized Options, also known as the options disclosure document (ODD). It explains the characteristics and risks of exchange traded options. Download the Characteristics & Risks of Standardized Options PDF.