ToS Scan for % change over time

July 15th, 2020, 11:12 PM

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.

July 20th, 2020, 01:30 PM

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

ToS Scan for % change over time

Discussion in ThinkOrSwim

ToS Scan for % change over time