-1

I am trying to get "Ex-Dividend Date" in GoogleSheets, by using the following formula.

But it is giving me #NA error.

=if(isblank(A2),"",index(IMPORTHTML(CONCATENATE("https://finance.yahoo.com/quote/",A2),"table",2),7,2))

Is there a way to resolve this?

I tried changing table numbers and colums etc.

Santoh Singh
  • 1
  • 2
  • Seems like you can't scrape https://finance.yahoo.com with IMPORTHTML because Yahoo is blocking it. You might want to take a look at =GOOGLEFINANCE formula. – user11222393 Aug 27 '23 at 07:49
  • @user11222393 Does `GOOGLEFINANCE` return an ex-dividend date? – Tedinoz Aug 27 '23 at 08:33

0 Answers0