0

I normally use IMPORTXML or IMPORTHTML succesfully on Google Sheets but in this case none of this works.

For example I want to see the porfolio data of the ETF iShares Core S&P 500 here.

IMPORTHTML

So let's say I want to get the data from table #1 "Asset Class" (same thing will apply for other tables) and I don't want to import any graph obviously, only texts and numbers:

=importhtml("https://www.morningstar.com/etfs/arcx/ivv/portfolio","table",1)

The result is N/A :(

IMPORTXML

I also tried importxml on the table:

//*[contains(concat( " ", @class, " " ), concat( " ", "sal-asset-allocation__assetTable", " " ))]

but it also doesn't work.

Then I tried to find out in the network of this page and I found that it calls this here.

but have no idea on how to work it around and would like to keep it simple. I'm sure someone of you can make the importhtml working.

Any suggestion? Thanks everyone, you guys saved me so many times!!!

Rubén
  • 34,714
  • 9
  • 70
  • 166
megaG
  • 1
  • 3
  • Does this answer your question? [Google Sheets importXML Returns Empty Value](https://stackoverflow.com/questions/61470783/google-sheets-importxml-returns-empty-value) – Rafa Guillermo May 03 '21 at 13:59

1 Answers1

0

This website generates part of it's contents using Javascript. This part cannot be imported. Switch off javascript in your browser and see that majority of content dissapears:

enter image description here

Krzysztof Dołęgowski
  • 2,583
  • 1
  • 5
  • 21