#### Howdy, Stranger!

It looks like you're new here. Sign in or register to get started.

Options

# percentage decline from 52 week highs

How can I set up a scan in order to find the percentage of stocks in the S&P 500 and the NYSE that are down 20% from their 52 week highs

• Options
Here's a couple of screen shots of the scan I ran and the results page. I ran it after the close today and got 39 hits. A quick check of the charts and yes they all seem to meet the requirement that the current close was at least 20% below the max high which could have happened any time during the last year.

• Options
edited October 2014
Welcome to the forum Sandy. First recommendation is to read the information on scanning which can be found under the ChartSchool tab on the main StockCharts site. There are also lots of how to examples there.

http://stockcharts.com/school/doku.php?id=chart_school:scanning

To help jump start you in the right direction, just use the drop down menus in the advanced scan workbench. Delete the default criteria then select and insert type is stock and group is S&P500, thats the first part.

[type = Stock]
and [ group is SP500 ]

Now select predefined scans and insert new 52 week high.

and [today's high > yesterday's daily max(253,high)]

So notice that this predefined scan code looks for todays high to be greater than the highest high over the previous 253 days (thats 52 weeks of trading days). So lets just switch this around a little.

You want todays high to be at least 20% less than the value of the max high over the previous 52 weeks (253 trading days). Note 20% less is the same as multiplying a value by 0.8 and we want todays high to be less than not greater than.

and [today's high < yesterday's daily max(253,high) * 0.8 ]

Hope this gives you some new ideas.
• Options
In order to determine the percentage decline from 52 week highs on the S&P 500, I used the following criteria: [type=stock] and [group is SP500] and [ today's high > yesterday's daily max(253,high)] and [today's high< yesterday's daily max(253,high) * 0.8]

As my result was a zero count, I'd appreciate any suggestions
• Options