Forum Discussion
JohnTertx1204
Jul 09, 2020Copper Contributor
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=...
SergeiBaklan
Jul 09, 2020Diamond Contributor
If copy/paste your formula to Google Sheets it returns
In Excel you may Power Query from Web, transform and return two tables