percentage decline from 52 week highs

sandy

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

gord

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.

gord

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.

sandy

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
leading to a definitive answer.

gord

Sorry Sandy, by switching things around a little on a standard scan, I didn't mean include both clauses in the scan. IE you can't look for a 52 week high and also look for a 20% decline from a 52 week high all in the same scan, nothing will meet both. I was just trying to show you how to modify a clause to do what you needed.

Your scan should look like this.

[type=stock]
and [group is SP500]
and [today's high< yesterday's daily max(253,high) * 0.8]

let us know how it works

sandy

That did not work. My kids are visiting next week and I'll have them show me how to attach things and submit them for suggestions. I'll sign off for now.