Jul 09 2020 01:30 PM
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=AAPL200918C00395000 .
The Google Sheet implementation is as follows and its results are attached:
=IMPORTXML(("https://finance.yahoo.com/quote/AAPL200918C00395000?p=AAPL200918C00395000"),"//tr")
Help much appreciated.
Jul 09 2020 01:55 PM
If copy/paste your formula to Google Sheets it returns
In Excel you may Power Query from Web, transform and return two tables
Jul 09 2020 01:56 PM
Jul 09 2020 02:16 PM
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.