Hello, I want to create a scan that will provide % change over a defined period of time. For example, I want to see all stocks that have decreased by 20% or more over the last 60 days in comparison to last close.

Another example: xxx closed at $100 in the previous session. But the average close over the last 60 days 120. If I ran the scan that I am looking for xxx would come in as a result.

I think that it would look something like this:

close(“period” = AggregationPeriod.DAY) is greater than .95 * SimpleMovingAvg(“length” = 50).”SMA”

I think that I need to change the "greater than .95*" to a negative?

Here is another example and maybe a better one:
#The current stock price is trading above the 50-day moving average
close(“period” = AggregationPeriod.DAY) is greater than SimpleMovingAvg(“length” = 50).”SMA”
All I really want to be able to do is add the negative or positive percent variable to this.
#The current stock price is trading X% below the 50-day moving average



I then want to have column in the scan that shows me the actual % change over the 60 days for all of the stocks that meet the criteria.

I have been working on this for days and I just cannot seem to get it right. If anyone can help I would be most appreciative.

The only suggestion I have is to perhaps move the individual portions of your expected results into the 'Search Results' and then calc'ing the difference in a spreadsheet.

Some additional criteria such as price being below the Daily 200 SMA could help if you have too many results initially