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

T

teachamantofish

I created this spreadsheet because AFAIK thinkorswim does not let you graph multiple positions on separate line in a single chart. Couldn't find one online either.

There is probably a tool out there but I just can't find it. Anyway, here's my attempt:


upload_2024-2-17_11-4-11.png
 
Quanto said:
Options tools are not easy to program, requires much grey matter between the ears :)
So, every help and attempt is welcome. Thx.
More...


You can create a risk profile chart like that just using Google sheets. I got one myself but I haven't made it for multiple stocks (options) but it does single stocks but only at expiry unless you're going to use actual live data.
 
That was done in GS and does any number of comparisons. It was so easy to do I don't know why TOS does have checkboxes or something next to each position. You could compare different trades or even sets of trades in the same chart. Anyway, I'll keep building out my DIY version until I find a commercial offering.

Thanks for the input!
 
teachamantofish said:
That was done in GS and does any number of comparisons. It was so easy to do I don't know why TOS does have checkboxes or something next to each position. You could compare different trades or even sets of trades in the same chart. Anyway, I'll keep building out my DIY version until I find a commercial offering.

Thanks for the input!
More...

Clipboard01.jpg
 
Last edited:
Nice. Your work? Can you place multiple trades on the same chart?

Also, any ideas on how I can get pricing data in a copy/paste or import way rather than typing manually?
 
Last edited:
teachamantofish said:
Nice. Your work? Can you place multiple trades on the same chart?
More...

Thanks! Yes...well I saw it done on yt and made my own version. It's better for just one strategy...would get complicated at least I don't want to put the time in. Yours looks like it would be better for multiple.

teachamantofish said:
Also, any ideas on how I can get pricing data in a copy/paste or import way rather than typing manually?
More...

Yes, use barchart excel addon.

wxytrader said:
I was subscribing getting the options data their exceL add-on , but at the time it was delayed 15 minutes. I liked having it imported directly into my spreadsheets.. but but needed it real time. I wish they had a Google sheets version because I find it far superior to excel.

Anyway, their customer service is great. They totally helped with all the setup and if I encountered any problems with the import.

https://www.barchart.com/excel

Update: it's realtime now!
https://www.barchart.com/solutions/...s-real-time-equity-options-data-and-analytics
More...
 
You must log in or register to reply here.
Back
Top