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)
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.
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