Aeromir logo image
Aeromir Join page image

Greatest Options Analysis Tool Spreadsheet

NOTES

Greatest Options Analysis Tool Spreadsheet

Walkthrough Video

Version History

Version Date Description
1.79 4 Jan 2024 Adding a new Straddle/Strangle sheet. Still in development but it works
1.78 19 Dec 2023 Corrected the Calendars Ratio calculation
1.77 18 Dec 2023 Calendars sheet now shows the pre-market estimate of the at-the-money strike in a pink background color
1.76 15 Dec 2023 Fixed a bug on the Calendar sheet. The order buttons had the strikes in the wrong order which created short orders. That is fixed now.
1.75 14 Dec 2023 Added order buttons on the Calendar sheet for Single, Double and Triple Calendars
    Added a Short/Long Ratio on the Calendar sheet
1.74 14 Dec 2023 Added a time to 10:30 Eastern for a Time STOP on the Calendars page.
    Added a new column for Calendars to specify the drawdown per account.. Clicking the Reset button resets all of the draw downs to -1%
    Changed the right columns on the Monitor tab. You can now monitor the profit/loss for the strangle, puts and calls
1.73 12 Dec 2023 Opening the GOAT now also refreshes the options chain strikes
1.72 8 Dec 2023 Calendars sheet now has a table with Calendar prices
    Calendars sheet now calculates your current Profit or Loss correctly
    Worksheet now picks today‘s date during the week and Monday on the Weekends and handles the next trading day for Calendars correctly
1.71 6 Dec 2023 Chain sheet expiration date is automatically set to TODAY() if it is Monday through Friday. Otherwise it sets the date to the next Monday
    Added a "Drawdown" column on the Calendars sheet. Clicking on any of the values copies it to the Drawdown field to calculate contracts and profit and loss numbers for each account
    Added an "Entry Strike" field on the Calendars sheet. Enter the strike of your calendar and this will monitor the distance to the spot price
    Calendars sheet has a new button to copy the ATM strike to the Entry Strike price
1.70 6 Dec 2023 Added a new Calendars sheet for 0 DTE calendar spreads
1.69 21 Nov 2023 Updated the Adding Machine on the Calculators Tab
1.68 20 Nov 2023 Added a Calendar Calculator on the Calculators sheet. Helps plan 0 DTE calendar trades
1.67 17 Nov 2023 Added In/Out STOP orders on the Monitor sheet. Click on the PUT or CALL strike to generate the order. The order is +/- 5 points from the strike. Stop price is $1 above the current mark of the spread
1.66 16 Nov 2023 Bug fix: Monitor sheet Strangle order wasn‘t correct. Now it is.
1.65 31 Oct 2023 Added new fields on the Monitor sheet to track the Strangle performance. The strangle stop price is calculated and clicking on the strangle stop price generates the STOP order for thinkorswim
1.64 26 Oct 2023 Fixed a bug when deleting a call or put on the Monitor sheet if warning sounds are enabled
    Added the current time on the Monitor sheet
1.63 16 Oct 2023 Added Back Ratio 1x2 and Back Ratio 2x3 to the Delta Fixer
1.62 14 Oct 2023 On the monitor tab,replaced the UP and DOWN text with a large arrow to easily see which direction you are rolling short strikes
1.61 13 Oct 2023 Added "Pull" buttons on the Monitor tab to pull the calculated stop prices and contracts for the selected row into the box to generate an order
1.60 12 Oct 2023 Added a direction indication for the Monitor tab when rolling the calls and puts
1.59 12 Oct 2023 On the Monitor sheet, removed the Time column and replaced with two columns for the number of contracts for puts and calls
1.58 11 Oct 2023 Added buttons to Remove a put or call from a row. Click on the row, then click the button to remove either the put or call from that row
1.57 11 Oct 2023 Added a section to the Monitor tab to roll the puts, calls or both via a condor roll
    Video review of version 1.57 updates
1.56 10 Oct 2023 Updated the Monitor sheet to reset the lower and upper adjustment points to the breakeven prices.
1.55 10 Oct 2023 Added a warning sound if the M/S ratios on the Monitor tab are 1.5 or greater. There is also a checkbox to turn the warning sounds on or off. The sound file needs to be a WAV file on your computer. Update the Settings!D22 cell with the full path to your WAV file.
    Download this buzzer sound WAV file for the Monitor audile warnings:
1.54 10 Oct 2023 Added an Adjustment Distance to the Monitor tab. Calculating the lower and upper adjustment points uses this number as the distance from the short strike
1.53 10 Oct 2023 Fixed a bug on the Monitor tab to pull in the prices for the Mark
1.52 8 Oct 2023 Added a Sale*1.5 column to the puts and calls on the monitor tab.
    Updated the Delete Row button to move non-deleted rows below the selected row up one row to fill in the missing row
    Changed the logic to find the next trade number. Now looks for the maximum trade number and increments it for a new row
    Video review of version 1.52 updates
1.51 7 Oct 2023 Added a "Delete Row" button to the monitor tab. Select a row with data to delete, click the button and the row is cleared
1.50 7 Oct 2023 Added a "Push to Monitor" button on the home page. This pushes the current short strikes and breakeven prices to the Monitor tab
1.49 4 Oct 2023 Big updates to the Condors sheet. You can now specify different number of contracts for the long and short legs for puts and calls. You can rebuild only the calls, only the puts or rebuild all.
    Added a "Trade Monitor" tab. This lets you monitor strikes and adjustment prices
1.48 19 Sep 2023 Fixed a small bug on the Condor and Condors page when monitoring the long strike. The Chain tab only pulls the ASK price. If an option is bid 0, ask 0.05 any spread with that option will not be filled. I changed the monitoring to look for an option price of 0.05 instead of 0.00
1.47 18 Sep 2023 Added a "condors" sheet to monitor up to six iron condors
1.46 16 Sep 2023 Added a price to close the short strike in a condor
    Cleaned up the Reset button on the condor sheet
    Allow changing contracts on the Condor sheet. Reset button resets to pull the quantity from the Home sheet
    Added an MEIC section to the condor sheet
    Enabled the OPRA button on the home page. This creates the OPRA codes to paste into a thinkorswim chart to plot the price of the condor
    Video review of version 1.46 updates
1.45 13 Sep 2023 Added a checkbox to add an order to close the condor short strike as part of the OCO order
    Added a new 5-wide butterfly on the Templates page
1.44 16 Aug 2023 Updated the "Templates" price calculation to handle time spreads
1.43 14 Aug 2023 Added a spread price calculation to the "Templates" tab. NOTE: Only works with spreads with the same expiration
1.42 11 Aug 2023 Added a "Probability of Touch" to the chain tab
1.41 7 Aug 2023 Added the "Adding Machine" on the Calculators tab
    Redesigned the Exit Price Calculator
1.40 26 Jul 2023 The Delta Fixer "Single" was not generating an order. Now it is.
    The STOP: Roll Short Calls (and Puts) orders were tweaked to work better
1.39 24 Jul 2023 Added Dan Harvey‘s Straddle and Strangle price monitor on the home tab
1.38 20 Jul 2023 Changed Exit Price Calculators tab to Calculators and added a new target price calculator
1.37 18 Jul 2023 Added buttons on the Flies tab to generate the OPRA codes to monitor the butterfly prices graphically in thinkorswim
1.36 16 Jul 2023 Added an order to the OCO‘s on the Condor tab to close the short strikes for 0.05
    Video review of version 1.36 updates
1.35 16 Jul 2023 Added a section on the Home sheet to monitor the Narrow Iron Condor method 3
1.34 13 Jul 2023 Added a button on the Home tab to generate the OPRA string for the a thinkorswim STRANGLE chart
1.33 3 Jul 2023 Changed the way Excel loads the latest version of the GOAT. Refreshes every two hours now.
1.32 2 Jul 2023 Found the remaining external link and removed it
    Added a new tab called "Flies" for finding and trading primarily short butterflies
    Added a new target profit calculator for the Narrow Iron Condor on the Home sheet in cells S21:V27
    Added a new feature to turn the version background color to RED if your version is less than the latest version. Clicking on the HOME!B3 cell will load the page to download the latest file
    Video review of version 1.32 updates
    Added data validation for Home T14, which should always be a positive number (Delta Fixer)
1.31 19 Jun 2023 Renamed the "Roll Order" to "Roll All" and added "Roll Puts" and "Roll Calls" to the new short strike adjuster.
    Added green arrows to click to copy from the puts to the calls the distance and number of contracts
    Video review of version 1.31 updates
1.30 19 Jun 2023 Added a section on the Home tab to roll both shorts higher or lower
1.29 18 Jun 2023 Added a "Single" type to the Delta Fixer
    Added the Opening EM on the Chain tab
1.28 19 May 2023 Changed the background color of the Delta Fixer strikes to blue. You can enter your own strikes and click the "Reset" button above to the right to reset the strikes to a calculated value
1.27 18 May 2023 Fixed a bug on the HRRFlies tab when selecting call butterflies
1.26 18 May 2023 Fixed a bug on the Vertical tab. Spreads now show the correct contracts for each strike in columns E and M
    Entry Price Calc tab reset button now clears the Thinkorswim adjustment information
    Fixed two templates with the correct number of contracts
1.25 15 May 2023 Fixed a bug on the Vertical tab. When selecting Bullish or Bearish trade direction, the spreadsheet was using the direction set on the "Home" tab. It now uses the direction set on the Vertical tab
1.24 14 May 2023 Added "Vertical - Debit" and "Vertical - Credit" to the combo/risk reversal hedging tool. The tool has been renamed to the "Delta Fixer"
    Separated the trade direction buttons from the Home and Vertical tabs. They are now independent which greatly speeds up the changing of direction on the Home tab
1.23 7 May 2023 Added buttons on the Condor tab to close only the short puts and calls via a stop order
1.22 5 May 2023 Fixed the conditional formatting for the chain tab for option chain #2
    Added a thinkorswim adjustment calculation. Used if you are using "Show All" on the analyze tab to calculate the price of the single buy/sell price to align the Monitor and Analyze P/Ls
1.21 2 May 2023 Fixed a bug when resetting the Condor tab. The EMR cells were erased
    Fixed a bug with the conditional formatting of the EMR for the condor calls and puts
    Added the ability to load the EMR on the Chain tab
1.20 30 Apr 2023 Added the Skew Driver to the GOAT as the "Skew" tab. You have a button to turn it on and off as it requests data for puts 30-days out
    Added conditional formatting on the Home tab if the date is before today. White bold font on a red background so it stands out
    Added a new walkthrough video
1.19 30 Apr 2023 Added a High Reward to Risk Butterfly tab to the spreadsheet. This replaces the Day Trading Spreadsheet‘s 0-dte tab
1.18 28 Apr 2023 Moved the selected template name on the Home tab to above the Template button
    Added an "SPX Projection" if the SPX open has a zero price. This happens overnight. The projection is the SPX previous close plus or minus the ES futures change
    ATM Strike is calculated off of the SPX projection if the Open price is 0.00. This is useful pre-market to estimate what the ATM strike will be based on the futures
1.17 23 Apr 2023 Replaced all ActiveX buttons with Excel buttons and shapes. The spreadsheet should work on Excel for Mac now!
    Recoded the Condor tab to work better
    Updated the Vertical tab to handle an OCO order to take a profit and have protective stops in place
    If you change the Chain expiration date #1, if date #2 is less than date #1, date #2 is set to date #1
    Vertical EMR conditional formatting only applies to Credit spreads. Spread Type is now shown above the strike in the monitoring section
1.16 21 Apr 2023 Sped up the getOptionData function. Data lookups are much faster now
    Modified Reset buttons on the Condor and Verticals tabs to only reset that tab
    Renamed BEIC tab to Condor
    Added a Strangle profit target and LMT price. LMT price is calculated from I17+K17 or manually entered. Strikes are from I5 and J5 and contracts are from C6 cells
    Fixed a bug on the Condor sheet for the Select and Order buttons
1.15 18 Apr 2023 Fixed an Excel 2010 compatability issue with the ISFORMULA function
    Added ORDER TYPE to the confirmation message box popups
1.14 17 Apr 2023 Replace the Combo and Risk Reversal boxes on the Home tab with a new multi-purpose box that handles Combo, Combo plus a long and risk reversals
    Added a profit/loss tracker to the vertical tab
1.13 13 Apr 2023 Added a message to tell you when a Reset is completed
    Added order buttons on the BEIC tab above the "Select" buttons to allow legging into a BEIC
1.12 10 Apr 2023 Added two check boxes on the Vertical tab to show the P/L at expiration or your profit target
    Fixed a bug on the Vertical tab to show the profit if the spread price falls to zero
    Bug fix on Home tab for cells I25:I27 were referencing the short call strike incorrectly. Thanks Stan!
    Bug fix on the Home tab. The ES previous close field was missing the formula
1.11 10 Apr 2023 Modified the "Collapse" and "Expand" buttons to keep showing the tabs and the menu but hide the ribbon
1.10 9 Apr 2023 Added the ability to get Gamma, Vega, Open Interest and Volume on the Chain tab
    Added a section on the Home tab to monitor SPX, ES futures and the VIX prices with the SPX range for the day
1.09 7 Apr 2023 Added "hide" and "show" buttons on the home tab to hide and restore the Excel ribbon, headers and formula bar
    Moved the Help information to the "Help" tab
    Modified the Chain tab so users and type in the number of days in the future for each expiration chain
    BEIC bug fix
1.08 6 Apr 2023 Added a "Vertical" tab for trading vertical spreads
1.07 6 Apr 2023 Added some BEIC monitoring fields
1.06 5 Apr 2023 Added BEIC E and M columns to show what strikes and quantities you are buying and selling
    Fixed Home pricing based on expiration date for rows 8 and 9
1.05 5 Apr 2023 Modified the templates tab to correctly pull the right expiration date into the Home tab
    Added data validation to expiry columns on the Templates tab to require a whole number 0 or greater
1.04 5 Apr 2023 Changed Buy and Sell buttons on the Home tab to say Open and Close
    Added a BEIC tab monitor area below the OCO order buttons
1.03 3 Apr 2023 Added buttons to close an iron condor with a target price and a condition of SPX being above/below either the expected move (EM) or a user defined distance
1.02 3 Apr 2023 Added the Profit Calc and Entry Price Calc tabs from the Day Trading Spreadsheet
    Added breakeven analysis columns on the JOIF tab
    Added the "Show confirmations" checkbox to the BEIC tab
    Added code to check if the user entered a fill price on the BEIC tab when clicking on the buttons to generate the OCO orders
    Added code to suppress N/A and #N/A values when returning option data
1.01 2 Apr 2023 Added the Breakeven Iron Condor (BEIC) tab to find and enter a BEIC and the OCO stop orders
1.00 31 Mar 2023 Initial 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.71.254.218
Page Processing Time: 0.02 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.