Is there a tool for comparing P/L for stock vs option on a single chart?

[wxytrader]

Do you use BSM for the final outcome at expiry, or do you use some own calcs?
Or asked generally: how do you calc the plot lines? Are you using a library component or so?

All done with spreadsheet forumulas.

 

[wxytrader]

I mean this one https://optioncreator.com/long-butterfly (but it should be possible in yours by using 2 short legs with qty=1 instead of the 1 leg with qty=2)
Do you use BSM for the final outcome at expiry, or do you use some own calcs?
Or asked generally: how do you calc the plot lines? Are you using a library component or so?

 

[wxytrader]

I am experimenting with theoretical value displayed on the chart. This is showing the theoretical theta decay over the life of the option @ the current price. If the chart showed the whole thing it would eventually hit your max loss. So if by Mar15 (63) price hasn't moved you would have lost $136.01. If we compare to tos Apr19 210 (63) the prices are $4.31/$11.57 which coincides pretty close with the BS spreadsheet calculations below of $4.56/$10.29

So 4.56-5.92=-1.36
I think I did that right...

Now I can adjust the stock price to forecast what the premium will be in the future. I will add this into the chart...just testing things out. You can see how close the spreadsheet is to the actual prices on tos.

(if stock price is 205 (63) then my position would be $5 otm so comparing to tos contract that is $5 otm (63)

 

[teachamantofish]

Great work, please open source sheets so we can all improve it

I posted the link above. Also here:

 

[wxytrader]

I think I got it! (for a single leg)

If price reaches 209 on Mar15 then the P/L would be $183.67 for a 210 call.
Check the math on tos with a (63) IWM call that is 2 otm and premium is 7.22
The spreadsheet Black Scholes calc has it as 7.76 so rounded this is pretty good as price is in between strikes right now @ 201.66

7.76-5.92=1.84

Now I can filter positions automatically into the P/L chart and all I would need to adjust is the IV to track P/L dynamically....no api or imports necessary! This will be useful since I am not typically concerned with P/L at expiry so much as by a certain date.

 

[wxytrader]

Black Scholes calculation on the spreadsheet is within $4 of TOS real time data when I include fees.

 

[wxytrader]

I managed to get spreads to work! Just for those new to the topic, this is all being done within google sheets using only googlesheets formulas... no scripts, no API/importing of data.

Here is the TOS MAY17 200/205 short call spread theoretical P/L if price is 195 on April.23

Here is The TOS MAY17 195/190 short put spread theoretical P/L if price is 200 on April.23