1

I'm trying to get a value in google sheets from https://www.mae.com.ar/mercado/datos-del-mercado/mae-today

Here is my formula so far:

=IMPORTXML("https://www.mae.com.ar/mercado/datos-del-mercado/mae-today","//td[@class='market-table-td-value active']")

For some reason I don't understand, the result is #N/A. What am I doing wrong?

Here is an image of the value I want from that website:

enter image description here

Here is an image of the code of that website with the value I want:

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
user11221377
  • 125
  • 9

1 Answers1

1

#N/A, in this case, is a result of trying to scrape JavaScript content/elements which Google Sheets does not support. you can test this simply by disabling JS for a given site and what's left can be scraped. in your case it's nothing:

0

DisappointedByUnaccountableMod
  • 6,656
  • 4
  • 18
  • 22
player0
  • 124,011
  • 12
  • 67
  • 124
  • Do you know if it's posible to retrieve this value using Apps Scripts? I tried using UrlFetchApp.fetch but it doesn't get the value either – user11221377 Feb 20 '20 at 20:51