Google Sheets: IMPORTHTML not fetching table 10

0
votes

I have been periodically updating my Finance profile with my dividend returns. While the online Yields reported may not be 100% accurate, I still wish to pull the Foward Annual Dividend Yield.

I previously had the following to pull the Yield from Yahoo:

=vlookup("Forward Annual Dividend Yield"&"*",IMPORTHTML("https://finance.yahoo.com/quote/O/key-statistics","table",10),2,0)

It appears now, IMPORTHTML is unable to pull table 10. Reports back to me #REF: 

=IMPORTHTML("https://finance.yahoo.com/quote/O/key-statistics","table",10)

Where as 

=IMPORTHTML("https://finance.yahoo.com/quote/O/key-statistics","table",9)

has no problem reporting back the "Avg Vol (3month) - 1.92M" "Avg Vol (10 day) - 1.55M" and so on.

If there is no problem pulling table 10 from other sites, where am I going wrong?

2
google-sheetsgoogle-sheets-formula

2 Answers

1
votes

as an alternative you can try:

=INDEX(IMPORTXML("https://finance.yahoo.com/quote/O/key-statistics", 
 "//td[@class='Fz(s) Fw(500) Ta(end)']"), 51, 1)

0

0
votes

works just fine on this side:

=IMPORTHTML("https://finance.yahoo.com/quote/O/key-statistics", "table", 10)

0

=INDEX(IMPORTHTML("https://finance.yahoo.com/quote/O/key-statistics", "table", 10), 2, 2)

0