A Trail of Screenshots: Filtering and Ranking

These screenshots will start embarrassingly simple, and get more elaborate.  So stay tuned…
First, lets find large companies!

Now, within that set of companies we want to find companies with decent valuation:

That’s nice, but we have some companies with really tiny PE values:

Let’s filter them out (using add term on the <, and dragging and dropping the terms):

This is nice, but where did I get those 3 and 12 from.  Lets do something more molded to the stocks in question.  Enter the rank-across operator:

We quickly learn that among large caps, that pe range is too strict:  the 5th percentile is a PE of 9.47.  The 20th percentile is a PE of 15.We can do multiple rankings:

Where did they all go?  It turns out that the two overlapping ranks outlawed a lot of companies, since P/E and momentum work against each other.  We can nest our rankings, and get more results.

This term gives us the top 15% of the prior matches, sorting by momentum.

How does this do?  It is not amazing in the last few years, but before that…

it does pretty well.  If all those average PE, rank, etc lines are confusing you can unplot them all with Ctrl-Shift-U: