Forum Discussion
Replicating the ImportXML function from Google Sheet in EXCEL
How do I replicate in EXCEL this ImportXML function that returns the content of the table of a stock option contract like AAPL200918C00395000 at https://finance.yahoo.com/quote/AAPL200918C00395000?p=...
Where do you do your options trading? I ask because, as a Fidelity client, I've been just downloading the kind of Options data you're talking about for years, from Fidelity's Active Trader Pro. I don't know for sure, but would be surprised if most of the larger financial services firms don't offer competitive products.
The data is real-time, not 20 minutes delayed......granted, it is immediately a bit out of synch, but unless you're day trading that shouldn't be a problem.
Anyway, another idea.