{"id":4546,"date":"2020-03-23T18:31:08","date_gmt":"2020-03-23T18:31:08","guid":{"rendered":"http:\/\/joapen.com\/blog\/?p=4546"},"modified":"2020-05-15T10:53:04","modified_gmt":"2020-05-15T10:53:04","slug":"utility-stocks-2020","status":"publish","type":"post","link":"https:\/\/joapen.com\/blog\/2020\/03\/23\/utility-stocks-2020\/","title":{"rendered":"Utility Stocks-2020"},"content":{"rendered":"

This article<\/a>, titled as “Top 10 Utility Stocks For Dividend Growth And Income”, show a table with data of the selected companies. The analysis is very rich and didactic about the data he collects and how he assess it.<\/p>\n

To me this table is very good summary.\"\"<\/a>I was thinking about how to retrieve data from different list of companies and have a quick look on dividend growth indicators in a semi-automatic way.<\/p>\n

So, how could I do it?<\/p>\n

Sources of data<\/h1>\n

Google Sheets enables you to retrieve data from their page with a nice set of formulas, it’s very easy to retrieve data, the problem is that the amount of data is very limited.<\/p>\n

Then I went to https:\/\/www.finviz.com\/<\/a> and I discovered that you can take all different parameters of a given company.<\/p>\n

Last but not least, I missed some data, so I went to yahoo finance and I got what I missed.<\/p>\n

The sheet<\/h1>\n

I have build a sheet that tries to:<\/p>\n