Cool Relative Strength Technical & Fundamental Tables!

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:

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:

• Purple = Turning Bullish - I keep a strong eye out for these. The 50 day moving average is FALLING, BUT the current stock price is ABOVE the 50 day moving average, AND the 10 day moving average is RISING. In the sample, ATN, AGYS, and MYE
• Yellow = Turning Bearish - The 50 day moving average is RISING, BUT the current stock price is BELOW the 50 day moving average, AND the 10 day moving average is FALLING.
• Green = Bullish - The stock price is above the 50 day moving average AND the 50 day moving average has been rising for more than 1 consecutive day.
• Red = Bearish - None of the above conditions are met.

______________________________________________________________________________________________________________________________________________

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:

• % OFF 1 YEAR HIGH = Stock Price / 1 Year High
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list that are closest to their 1 year high, percentage-wise. In the sample, TBI, IDXX and MAG are very near their 1 year high
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list that are closest to their 1 year high, percentage-wise
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list. It would be furthest from its 1 year high, percentage-wise

• % OVER 1 YEAR LOW = Stock Price / 1 Year Low
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list that have the greatest percentage gain to their 1 year low. In the sample, MAG, BW and CANI are all up over 300% over their 1 year low
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list that have the greatest percentage gain to their 1 year low
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list. It would be closest to its 1 year low, percentage-wise

• %GAIN TO 1 YEAR HIGH = 1 Year High / Stock Price
- This column helps add perspective to the gain required for a certain loss. EXAMPLE, a stock 50% below its 1 Year high would require a 100% return to recapture that high.
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list that require the least percentage gain to reach their 1 year high
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list that require the least percentage gain to reach their 1 year high
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list. It would require the greatest percentage gain to recapture its 1 year high. In the sample, ROXI requires a 153.4% gain to reach its 1 year high, being off that high by 60.7%

• %GAIN TO 5 YEAR HIGH = 5 Year High / Stock Price
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list that require the least percentage gain to reach their 5 year high. In the sample, IDXX and TBI are not only reaching 1 year highs, but also 5 year highs.
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list that require the least percentage gain to reach their 5 year high
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list. It would require the greatest percentage gain to recapture its 5 year high. In the sample, PRGX requires a 1012.4% gain to attain its 5 year high price.

______________________________________________________________________________________________________________________________________________

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:

• 65 DAY ADJ = Adjusted 65 Day Average Volatility - Averages the past 65 trading days of daily volatility for the stock. The three highest and lowest volatility days are not considered to avoid skewing of the result from an extreme situation. The three days are picked up in the "High % Risk" and "Pot % Risk" columns. In the sample, ARQL and ROXI both have the highest average daily volatility over 65 trading days of 7.5%. NNN has the lowest average daily volatility over 65 trading days of just 1.5%

• 5 DAY ACT = Actual 5 Day Average Volatility - Averages the past 5 trading days of daily volatility for the stock. You can easily judge whether volatility is rising or falling by comparing this figure to the 65 day average figure. All days are considered. In the sample, BRKT has a 5 day average daily volatility of 19.8%. Certainly a major event has occurred.

• HIGH % RISK = Highest Volatility Day In The Past 65 Trading Days. In the sample, again, BRKT leads this category with a single day's highest volatility of 69.5% while TBI's highest volatile day in the last 65 trading days is only 4.4%

• POT % RISK = Average Of The 3 Highest Volatilty Days In The Past 65 Trading Days. Since three days are considered, your chances are greater of experiencing this high volatility number in one day with this stock. In the sample, BRKT, CANI, ROXI, ARQL, LENS, and IRN all have relatively high volatility potential.

• LOW % VOL = Lowest Volatility In The Past 65 Trading Days. This is actually the 3rd lowest volatility day in the past 65 trading days. I weed out the two lowest to eliminate holiday trading sessions an an attempt to give the "almost" guaranteed daily volatility for the stock. In the sample, ARQL, CANI and ROXI lead with a 3rd lowest volatility day in the past 65 trading days of over 3% each.

COLOR CODING FOR ALL VOLATILITY COLUMNS:
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list in volatility (highest) for the column
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list in volatility (high) for the column
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list in volatility (lowest) for the column

______________________________________________________________________________________________________________________________________________

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.

• 10 DAY SMA = Consecutive Number Of Trading Days The 10 Day SMA Has Been Rising or Falling(-)
• Purple = Early Stage Rise - Purple to get your attention, these stocks 10 Day SMAs have been rising only 1 to 5 trading days. In the sample, CURE, ROXI, CANI, USFC and SXI have recently turned positive.
• Bright Green = Top 10% - These stocks are in the top 10% bracket of all stocks in the list with the greatest number of consecutive rising trading days. If less than 10% of the stocks listed have rising 10 Day SMAs, the shortest consective falling day string will be added to the color consideration. Thus, in extreme bear markets, some falling 10 Day SMA stocks may appear bright green - the number will be negative. This consideration will not override the above "purple" "early stage rise" coloring, but will count them as part of the 10% consideration.
• Green = Rising 10 Day SMA More Than 5 Consecutive Trading Days - Unless overridden by the "bright green" condition above.
• Red = Falling 10 Day SMA - These stocks 10 day SMAs have been falling the indicated number of trading days (shown as a negative number) except when the "bright green" condition above overrides in extreme bear markets.

• 20 DAY SMA = Consecutive Number Of Trading Days The 20 Day SMA Has Been Rising or Falling(-)
• Purple = Early Stage Rise - Purple to get your attention, these stocks 20 Day SMAs have been rising only 1 to 10 trading days
• Bright Green = Top 10% - These stocks are in the top 10% bracket of all stocks in the list with the greatest number of consecutive rising trading days. If less than 10% of the stocks listed have rising 20 Day SMAs, the shortest consective falling day string will be added to the color consideration. Thus, in extreme bear markets, some falling 20 Day SMA stocks may appear bright green - the number will be negative. This consideration will not override the above "purple" "early stage rise" coloring, but will count them as part of the 10% consideration. In the sample, TBI leads having its 20 Day SMA rising for 33 consecutive trading days.
• Green = Rising 20 Day SMA More Than 10 Consecutive Trading Days - Unless overridden by the "bright green" condition above.
• Red = Falling 20 Day SMA - These stocks 20 day SMAs have been falling the indicated number of trading days (shown as a negative number) except when the "bright green" condition above overrides in extreme bear markets.

• 50 DAY SMA = Consecutive Number Of Trading Days The 50 Day SMA Has Been Rising or Falling(-)
• Purple = Early Stage Rise - Purple to get your attention, these stocks 50 Day SMAs have been rising only 1 to 15 trading days. In the sample, ROXI's 50 Day SMA has recently turned positive...is the 130 Day SMA next?
• Bright Green = Top 10% - These stocks are in the top 10% bracket of all stocks in the list with the greatest number of consecutive rising days. If less than 10% of the stocks listed have rising 50 Day SMAs, the shortest consective falling day string will be added to the color consideration. Thus, in extreme bear markets, some falling 50 Day SMA stocks may appear bright green - the number will be negative. This consideration will not override the above "purple" "early stage rise" coloring, but will count them as part of the 10% consideration.
• Green = Rising 50 Day SMA More Than 15 Consecutive Trading Days - Unless overridden by the "bright green" condition above.
• Red = Falling 50 Day SMA - These stocks 50 day SMAs have been falling the indicated number of trading days (shown as a negative number) except when the "bright green" condition above overrides in extreme bear markets.

• 130 DAY SMA = Consecutive Number Of Trading Days The 130 Day SMA Has Been Rising or Falling(-)
• Purple = Early Stage Rise - Purple to get your attention, these stocks 130 Day SMAs have been rising only 1 to 20 trading days
• Bright Green = Top 10% - These stocks are in the top 10% bracket of all stocks in the list with the greatest number of consecutive rising trading days. If less than 10% of the stocks listed have rising 130 Day SMAs, the shortest consective falling day string will be added to the color consideration. Thus, in extreme bear markets, some falling 130 Day SMA stocks may appear bright green - the number will be negative. This consideration will not override the above "purple" "early stage rise" coloring, but will count them as part of the 10% consideration.
• Green = Rising 130 Day SMA More Than 20 Consecutive Trading Days - Unless overridden by the "bright green" condition above.
• Red = Falling 130 Day SMA - These stocks 130 day SMAs have been falling the indicated number of trading days (shown as a negative number) except when the "bright green" condition above overrides in extreme bear markets. In the sample, PRGX is really lagging having a falling 130 Day SMA for 247 consecutive trading days

______________________________________________________________________________________________________________________________________________

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.

• Curr PRICE TO 50D SMA = Current stock price-to-50 day SMA (+/- percentage)
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list in price-to-50 day SMA (highest) for the column
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list in price-to-50 day SMA (high) for the column
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list in price-to-50 day SMA (lowest) for the column

• RANGE MID POINT AVG = Channel mid-point for the current 50 day SMA rise/fall duration in price-to-50 day SMA percentage terms.

• RANGE HIGH AVG = Channel top for the current 50 day SMA rise/fall duration in price-to-50 day SMA percentage terms.

• RANGE LOW AVG = Channel bottom for the current 50 day SMA rise/fall duration in price-to-50 day SMA percentage terms.

• PRICE TO RANGE = Where the current price-to-50 day SMA falls within the calculated LOW/HIGH range above on a percentage basis. 100% would be the top of the range, 0% would be the bottom of the range.
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list within the channel range (highest) for the column
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in the list within the channel range (high) for the column
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list in within the channel range (lowest) for the column

• LINE SLOPE = The current slope of the 50 day SMA line presented as a percentage based on the current 50 day SMA divided by the previous day's 50 day SMA.
• Dark Orange = Top 15% - This stock is in the top 15% bracket of all stocks in the list in 50 day SMA line slope (greatest percentage rise) for the column
• Light Orange = Between Top 15% to 30% - This stock is in the second 15% bracket of all stocks in 50 day SMA line slope (percentage rise) for the column
• Blue = Bottom 20% - This stock is in the bottom 20% bracket of all stocks in the list in 50 day SMA line slope (greatest percentage fall) for the column

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.