Are you using IBKR data? I built my sheets using their sample excel spreadsheet, but they randomly stop working and I have to keep rebuilding them. Have you come across a stable solution, as I’d prefer to keep using their data
Yes I just have my sheets calculate price using the Black-scholes formula. You can find it online. So all I need to do is add IV....if you want to use an import instead then you can use the Barchart excel addon...but I think it is 10 minutes delays. https://www.barchart.com/excel
lol … it has to be real time data. I’ll see if I can find your sheets online and compare them to my hoadley sheets. I liked how you had everything on one page
Mine aren't technically real time because I have to update the IV...80% gets you close most of the time, but in a spike there will be large price discrepancies until I update IV. I use it more to project pnl potential more than current pnl. You can try Option net: https://www.optionnetexplorer.com/Default.aspx Make sure to watch the tutorial to know how to use it...after that its pretty straight forward.
I I’m only wanting stable excel or google sheets with live IBKR option data. I’m not too worried about the profit and loss charts. I’ll have a look at XLQ