I am attempting to pull from https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm
I want to get the EPS Rating which is the 305th list item, which I found using
var i = 1; [].forEach.call(document.getElementsByTagName("table"), function(x) { console.log(i++, x); }); in the console.
This is the importhtml i have used:
=IMPORTHTML("https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm","list",305)
and the importxml i have used:
=IMPORTXML("https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm","/html/body/div[1]/div[9]/div/form/div[2]/div[3]/section/div/div[9]/div[1]/div/div[2]/ul[3]/li[2]")
but all of them return "#N/A"
Error reads "Could not fetch url: https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm"
Am I approaching the IMPORT functions incorrectly? Or is the structure of this page not compatible with these functions? Any help is appreciated!
I should note that other domain prefixes import fine, such as "in.investors.com"
tested with =IMPORTHTML("https://in.investing.com/equities/jagson-airlines-bo", "table",2)
