Have you wanted to track sector rotations through time and get a feel for the biggest winners and losers? I have. The SectorsUP and SectorsDOWN worksheets are pretty useful. Find them among the tabs at the bottom.
If you have a Windows machine, or a Mac with any recent Excel except 2008, you will want to enable Excel macros so you can get the most out of this and other tools that will be introduced soon. If you can, enable macros now.
Activate the SectorsUP sheet and look at the notes in row 1. The SectorsDOWN sheet is similar but works in reverse.
Notice that the top row (row 2) is for today (today’s date is in column 1). The cells to the right show today’s top 8 winning stocks in each sector. The top line in each cell contains a “sector symbol,” which you can find in the “AllStocks” sheet. The sectors are sorted by the average of the 1-day percentage change of the top 20% of liquid stocks in the sector; it is helpful to think of those winning stocks as a proxy for the sector in the “up” direction. I have found this method of sorting sectors to be more useful than sorting by the 1-day percentage change of all the liquid stocks in the sector because I’m not holding the whole sector.
The number just below the “sector symbol” is the average, 1-day percentage change of all the liquid stocks in the sector. Again, the “AllStocks” sheet contains a list of those stocks, for today. They change slightly every day.
Consider that you may want to pick a sector and see how it has ranked recently. If you have Excel macros enabled, you can click that sector, on any row, to highlight it on every row. Do it. Hopefully, you will find the highlighting to be a big time-saver! I do.
Compared to the Persistence lists, and the Momo tools to be introduced next, the Sectors tool has no special algorithm. It is just one of many such presentations for sectors and stocks data that have been available for years. Let me know if you find it useful or you know of ways to improve it. (daytrend at gmail or @daytrend)
Enjoy… and hit me with any questions or problems.