Ranking a Group of Stocks by Percent Change


Q: How do I create a list of ETFs sorted by their performance over the past 20 days?

A: You can do that by using an Advanced Scan with our new "Rank By" feature.  Here's what it looks like:

[group is ETF]
rank by [PctChange(20, close)]

Note that when you run that scan, your results will be sorted by %Change.  Also note that the %Change values are shown in the rightmost column of the results page.

You can also add additional clauses to further reduce the number of results.  Here's one that's a little more "real-world:"

[country is us] and [group is ETFNOUI] and [sma(20,volume) > 100000] 
rank by [PctChange(20, close)]

By the way, "Rank By" must appear at the bottom of your scan.

- Chip

Chip Anderson
About the author: is the founder and president of He founded the company after working as a Windows developer and corporate consultant at Microsoft from 1987 to 1997. In this blog, Chip shares his tips and tricks on how to maximize the tools and resources available at, and provides updates about new features or additions to the site. Learn More
Subscribe to MailBag to be notified whenever a new post is added to this blog!
comments powered by Disqus