Coronavirus and S&P

It is the first time that I have a situation like this while studying indicators like these ones, so I am going to document what is going on.

The starting snapshot

4 weeks after the historical highest SPX when was at 3400 points this is what happens.

Initial view

  1. The McClellan oscillator seems to decrease the fall, in theory it begins to draw a divergence, which to me it still needs a few days to confirm.
  2. The “strong hand” sales volume is supposed to be decreasing, but the SPX is still down.

Things to watch:

  1. The US senate, congress and the FED agree;
  2. the impact of the COVID-19 in US.

To be updated soon…

Boldgrid

Boldgrid makes it easy to create beautiful websites on WordPress. The suite of tools and plugins lets you build and manage professional websites.

With BoldGrid’s free website builder you can instantly launch WordPress in the cloud and test building out a free fully functional website.

BoldGrid is powered by WordPress so you can take your website with you to any web host (this is what I did).

Templates and a builder plug-in that enables you to compose the pages and blog entries with infinite ways or shapes.

SEO capabilities to enable the right population of tags, key words and other aspects that are in benefit of being found,

The result?

I created a simple blog for posting pictures of the kids, so family is up to date of what’s going on with kids.

http://www.joapen.com/jepc/

Utility Stocks-2020

This article, 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.

To me this table is very good summary. 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.

So, how could I do it?

Sources of data

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.

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

Last but not least, I missed some data, so I went to yahoo finance and I got what I missed.

The sheet

I have build a sheet that tries to:

  • Build quickly a numeric analysis of a list of companies (as in this example utilities companies).
  • Be able to define the data I want to analyze using the map of finviz.com and other related data from yahoo finance.
  • Be able to adequate 5 – 8 indicators oriented to whatever you want to analyze: fundamental analysis on growth, technical analysis, fundamental analysis on revenue and gross margin…

The outcome

This google sheets document contains the analysis I did on the same list of utilities companies.

It’s not as complete and professional analysis as the one done by Eric Landis, but it’s a quick way to discard companies and then focus on a short list.

Things to improve

Some of the parameters do not refresh always in the right way, so from time to time you have to review the tables where the data come from: specially from yahoo finance.