Cool Relative Strength Technical & Fundamental Tables!

Updated Daily

First a quick word. Some of these tables are huge, 5 megabytes for the first with 716 stocks. Of all the tables I have created, I believe these contain the most comprehensive set of information and easy to spot color coding of important "absolute" trends and "relative" strengths of both technical and fundamental data. They are sorted by their current "weekly MACD" conditions:

The highest rated leads each condition. Within each same condition, stocks are sorted by those closest to their 1 year highs. In this sample, the strongest current "weekly MACD" condition is "Y2" (see more detailed explanations further down the page). The current trading day's condition is to the right. Previous trading day's trail to the left. You are looking at a five trading day trend. Conditions are grouped in similar colors, example: Green being positive - rising "weekly MACD" line, above the signal. Blue being negative - falling "weekly MACD" line, below the signal. The number represents the strength - the higher the stronger. Color coding for these five columns vary from the rest of the table so as to correspond with the many other "weekly MACD" tables on this site.

The tables are designed to be viewed at a screen resolution of 1280 x 1024. Smaller resolutions will require more scrolling. Check the color legend at the bottom. Certain colors represent "absolute" conditions while other colors represent "relative" conditions. "Absolute" meaning the condition "IS" bullish, turning bullish, bearish, or turning bearish. "Relative" conditions meaning at the top or bottom relative to the whole group. These color conditions do not apply to the five "weekly MACD" trend columns, which have their own separate definitions to remain consistent with the many other "weekly MACD" tables throughout my site.

I am trying to find a way to get the column titles to remain fixed at the top, but have not, as of yet, found a way to accomplish this in "Excel to Web Page" conversion. If you know a way in Excel, let me know! It needs to be done in the "save as web page" process. This page is unfinished at this point, so if you have any questions, feel free to email me. My email link is at the bottom of the page.

The Tables:

  • S&P 500 and NASDAQ 100 components, ETFs and my 250
  • S&P 400 MidCap components
  • S&P 600 SmallCap components
  • Screened beaten down stocks on the rise - 25% or more below their 52 week high from the above indexes
  • Below I give full explanations of the table sections (still under construction).

    The Sample Tables - The sample tables below are not current. They are for explanation purposes only. They are taken from an actual historical table and the relative color indicators are accurate for the table they are taken from. The relative color ratings are based on the whole table this sample was taken from and not based on only those in the sample table. The red cells apparently do not take well to JPEG conversion, this occurs only in the samples below - the actual tables are clear. To access the current tables, click the links above.




    SYMBOL AND COMPANY NAME: These are color coded for absolute bullish/bearish conditions based on the 50 day moving average indicator for the stock:


    1 & 5 YEAR HIGH/LOW STATS: - Gives the current stock price relationship to its 1 year high, 1 year low, and 5 year high. The secondary sort of this table is by stocks closest to their 1 year high (the primary sort is by Weekly MACD condition). Stocks furthest from their 1 year high, percentage-wise, are at the bottom within the same Weekly MACD condition group. The four columns are colored based on their "relative" condition among all the other stocks in the table:


    VOLATILITY: - Gives various statistics regarding the stock's "daily" volatility. The five columns are colored based on the stock's "relative" volatility for the column. The number result is actually a percentage (3.1 is 3.1%). A day's volatility is calculated from the previous day's close and the high and low of the current day considered (gaps from the previous days close are in the formula). The highest of those figures is divided by the lowest. The result is the percentage (high/low)-1. No consideration is given to whether the spread was a rise or fall. This is just a pure volatility number:


    MOVING AVERAGE RISE/FALL +/- DAYS: - This group considers four Simple Moving Averages (SMA) and indicates the consective number of trading days the moving average has been rising or falling. The Simple Moving Averages are 10, 20, 50 and 130 day. Positive numbers (usually green or purple..see explanations below) have been rising the indicated number of trading days, Red negative numbers have been falling the indicated number of trading days. I am using absolute colors for this group with a little deviation (see color explanations below). The color code descriptions below are listed in order of priority, as some may overlap.


    50 DAY SIMPLE MOVING AVERAGE (SMA) STATISTICS: - This group expands on the previous groups 50 SMA data. It attempts to establish a channel for the stock price baseed on the current duration of the 50 day SMA's rise/fall. This information is only as dependable as the duration of the rise/fall. A stock with a short duration 50 day SMA rise/fall will not have a well established channel trend so don't give the results much credence in this instance. The longer the duration of the rise/fall, the more credence can be given to the results in this group. The three channel range columns are grey throughout since I am not assigning any relative nor absolute significance. The rest of the data is colored based on relative strengths.

    MORE TO COME....I'm getting there!!

    The charts and tables here do not represent any recommendation from myself to buy or sell any security. I also do not guarantee the accuracy of these charts and graphs as the data is provided to me without guarantee.

  • HOME

    I welcome and encourage feedback.