IMPORTXML - only resulting in #NV

82 views
Skip to first unread message

Beule Beulentum

unread,
May 6, 2020, 10:58:08 AM5/6/20
to Google Finance
Hello,

I'm trying to import some data in Google Sheets using IMPORTXML, but I always get #NV.

For example:
To get the number of shares outstanding I tried the formula following, but didn't get the data, only #NV.
 
=IMPORTXML("https://de.marketscreener.com/ADIDAS-AG-6714534/kurse/";"//*[@id='zbCenter']/div/span/table[4]/tbody/tr/td[1]/table/tbody/tr/td/table/tbody/tr/td[1]/div[1]/table/tbody/tr[2]/td/table/tbody/tr[1]/td[2]")
 
I also tried the import data from other webpages. Same result.
 
Thanks for any help in advance.
Reply all
Reply to author
Forward
0 new messages