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.

Update 08/April/2020

  • SPX climbed from 2250 to 2789.
  • McClellan turned green, but ADX is still not on a positive trend.
  • Big buyers are still selling.

Update on 08/May/2020

  • A channel has been build between 2800 and 3000
  • ADX is positive and McClellan keeps being green.
  • Buy buyers are still selling, but closed to the buy line.
  • Fed continues sending money to the market, it’s incredible.

Update on 08/June/2020

  • Market flying since May 27th over 3000. It’s when big buyers started to buy strongly.
  • All green.
  • Fed continues sending money to the market.

Update on 08/July/2020

  • Now a channel between 3000-3150 is build.
  • McClellan always around zero and red is predominant.
  • Market breadth is still positive, no news.

Update on 08/August/2020

  • The channel between 3000-3200 has been passed and now is over it.
  • McClellan always around zero and red is predominant.
  • Market breadth is still positive, no news.

Big buyers are buying consistenly:

I stop adding comments to this post by the moment,as I’m focused on the POMO purchases and the actions of the FED.


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.

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 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 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.



My triple screens layers (by Alexander Elder)

In the book The New Trading for a Living,   Alexander Elder describes an useful and mechanic way to analyze and filter opportunities for investing: triple screen.

The 3 layers have a main purpose these are:

  • Top screen                 = censorship purpose.
  • Intermediate screen   = determine if there is an opportunity
  • Bottom screen           = refine the short

What do I check on each screen?

Top screen

  • Time frame = Weekly and daily
  • Support and resistance
  • Konkorde indicator (by blai5)
  • EMA(200), EMA(50), EMA(20)
  • Gatillo indicator (by Miguel Larrañaga)

Intermediate screen

  • Time frame = daily
  • Bollinger bands
  • EMA(200), EMA(50), EMA(20)
  • Volume Price Confirmation Indicator (by LazyBear)
  • Squeeze Momentum Indicator (or “SQZMOM” by LazyBear )

Bottom screen

  • Time frame = hour and 15 minutes
  • Double Bollinger Bands (by blai5)
  • Moving Average Convergence Divergence (MACD)
  • Gatillo indicator (by Miguel Larrañaga) (being evaluated).




The Dividend Investing Resource Center

This is a must link I am using since some time, and I wanted to keep it outside of my laptop.

I love the excel with the updated data, specially:

  • The table of changes of the major dividend players, specially those that are “out” of the dividend kings or aristocrats lists.
  • The fact that is in excel, that enables me easily to have the Chowder number.


Robinhood App is down

Today, March 2nd 2020 Robinhood application is down. One interesting day to trade as volumes are up, so I cannot do it.

Yes, fees are small, and they are covered by the acceptance of the terms of use, but by this reason I operate with this broker only the R&D portfolio.