Google finance sheet question

[valueinvestor123]

(Sorry not sure where to post this)

Hi, I am having trouble importing dividend per share data into my google spreadsheet.

I used to use this website: http://www.investorease.com/xcompany.ph ... &epic=HSBA

and the formula for the sheet was: =Index(ImportHTML("http://www.investorease.com/xcompany.php?disp=share&epic=HSBA","table",15),4,2)

But something changed and can't figure out what the table is (or perhaps something else is wrong?)

It would be helpful to download the dps data and have it update it automatically (and be compatible with google sheets). Any ideas?

[monabri]

Wonder why it says trading is suspended on HSBC ( click on the link )? I also tried LGEN - same result. I don't think HSBA & LGEN have had trading suspended.....

[kiloran]

(Sorry not sure where to post this)

The Financial Software board is probably the best place

Hi, I am having trouble importing dividend per share data into my google spreadsheet.

I used to use this website: http://www.investorease.com/xcompany.ph ... &epic=HSBA

and the formula for the sheet was: =Index(ImportHTML("http://www.investorease.com/xcompany.php?disp=share&epic=HSBA","table",15),4,2)

But something changed and can't figure out what the table is (or perhaps something else is wrong?)

It would be helpful to download the dps data and have it update it automatically (and be compatible with google sheets). Any ideas?

Investorease is no more. It was suspended a few weeks ago. See: http://www.investorease.com/

You need to use another source for your data. Here are some possibilities: http://lemonfoolfinancialsoftware.weebl ... sites.html

--kiloran

[valueinvestor123]

Thanks - but none of the websites seems to have the dps info in a format that can be imported into spreadsheet as investorease did...
Some have the yield but it is too approximate.
That's a pain. Will have to update things by hand I guess which will take forever for hundreds of holdings...