Stock Options Trade Position Comparison Spreadsheet

This worksheet has been added to our stock options trading spreadsheet, and will allow for the entry of two different positions and get a profit graph that will compare their risk reward.

The worksheet tab is called PosComp [Position Comparison], and although it has similarities to our other position spreadsheets, the ability to see the 2 different profit graphs is very beneficial:

  • The position spreadsheet is for tracking and adjusting your actual stock option positions
  • The option position spreadsheet is for tracking an options position and seeing how the theoretical value and profit will change
  • The stock option position worksheet is for comparing a stock option position to a stock only position

Whatif position modeling is an important part of trading and preparation for making trade adjustments, along with seeing the risk reward of an options position you may want to trade into.

When I did the short options entry timing video, the profit graph used was the position comparison worksheet being discussed in this video.

Let’s go into the trading spreadsheet and look at the inputs and how this worksheet is used.

Comparing 2 Stock Options Positions

You are looking at the profit graph comparing the 2 short positions that were traded into:

  • Blue graph = -1 50c 2.00 +1 45c 1.45
  • Yellow graph = +1 49p 1.65 -1 44p 1.45

Comparison Of Call Put Debit Spreads With Different Prices

Now, whatif you would like to combine these 2 option spreads and compare them to the same spreads entered at the same time, instead of using short options timing setups:

  • Blue graph = position math for the spread that was traded into – it could have been a whatif for a resistance reject entry that was completed at sup
  • Yellow graph = position math for entering both spreads at the same time

Interestingly, the 2 spreads at those strikes and prices could have been entered at a credit, even though they were long spreads.

But compared the profit math to the call and put timing spreads, and the huge difference in risk reward.

Call Put Debit Spreads Compared To Short Ratio Spreads

We’ll talk more about this in another video, but just to show another spread position comparison, we are going to compare the 2 long timing spreads to what the position would look like if we had planned to do 2 ratio short spreads:

  • Blue graph = 2 long debit spreads using the entry timing setups
  • Yellow graph = profit math for 2 short ratio spreads using the same strikes and entry setups as the debit spreads

Position Comparison Worksheet Inputs

Download latest options trading spreadsheet.

You are looking at the trade input spreadsheet and what you are seeing is the position worksheet that has been split into 2 separate input areas – this is what allows us to overlay the 2 separate position graphs.

You are already familiar with how to do the inputs:

  • The top input area is for entering stock option position1 and the lower section is for entering position2
  • You can see how I separated these by the gray cell rows
  • Enter whether the trade is an options trade or underlying trade – by inputting an o for option and u for underlying
  • The enter the quantity, strike, type if it’s an options trade, and price
  • Then go to the inputs to the right of the chart
    • Leave 100 in the yellow mult cell, since we are trading equity options
    • Enter the amount you want for an incremental change to the graph
    • And enter the price you want the graph to start at

That’s the end of the stock options position comparison video.  I think that you will find it very useful for comparing and modeling different trade positions at different prices, or the difference between 2 different position types.