0

The website is: https://www.nordea.no/privat/vare-produkter/sparing-og-investering/fond/vare-fond.html

I'm trying to use the IMPORTXML function on Google Sheets to get the % value under 1d column, of a certain row.

The chrome inspector shows following Xpath for the 1d in the first row:

//*[@id="FundList"]/div[4]/ul[1]/li[8]/span[2]

which returns #N/A (Import Content is Empty), instead of "1,19%" as for today.

I've tried several xpath "helpers" to find the right one, and modified it many times, men always get empty results.

Rubén
  • 34,714
  • 9
  • 70
  • 166
David
  • 1
  • 2
    this page is built using javascript on client side, therefore you will not be able to use importxml https://webapps.stackexchange.com/questions/115664/how-to-know-if-google-sheets-importdata-importfeed-importhtml-or-importxml-fun. Try to find another sote or an api. – Mike Steelson Aug 05 '22 at 09:45
  • Thanks. Sote? this is quite new for me. Any recomendation as a simple start point? It's more than a decade since my last VB program – David Aug 06 '22 at 01:24
  • If you can't find an api or other url, I'm afraid it's impossible. Maybe via Selenium (I don't practice) – Mike Steelson Aug 06 '22 at 04:22

0 Answers0