Stockrow screener is one of the most comprehensive on the web with over 400 financial indicators that you can screen for. As such, it might be a bit overwhelming and hard to find what you’re looking for, so I’ve written this guide to make it easier to find relevant screening criteria.
How the screener works
There are 2 input fields in the screener. One is for indicators, the other for tickers. The first is where you input your desired indicator and parameters, the other is for screening specific tickers and then displaying the columns that you need.
1. Screening by criteria
Stockrow screener is really simple and fast, once you learn to use it. In the first example, we are going to find companies with moderate growth, high return on invested capital, low valuation and high insider ownership.
The first indicator I’m going to find is Revenue growth. Stockrow uses 4 main dimensions for indicators – daily, quarterly, annual and trailing annual. I am going to pick quarterly, since I’m interested in the latest data. Daily refers to indicators like P/E ratio or EV/Sales, which are recalculated every day.
What comes up next is the range input box, where I type “>10”, which means I am looking for companies that grew revenue by more than 10% in the last quarter.
As you can see, it automatically adds the indicator to screener columns, and I can also sort it from highest to lowest or lowest to highest.
Next, I’m going to add all the other indicators: ROIC, EV/EBIT and insider ownership. Notice I have input 5-17 for EV/EBIT, meaning I am looking for companies with Enterprise value/EBIT between 5 to 17. Also, insider ownership is expressed as percentage, so greater than 10 means more than 10%.
Also, I can hover over an indicator with my mouse, and its long-term trend gets displayed. In this case, I want to view the P/E ratio for Arista Networks over time, and as you can see, it's way below its long-term average as shown on the picture.
Now that I have all criteria, I can add more columns. I click on “Advanced mode” and a new screen comes up with all available indicators. Let’s say I want to add EV/FCF indicator as another column so I click on “Valuation category” and click on EV/Free CF (daily) and it gets added to my screener list.
Let's say that I want to filter only companies with positive EBITDA. I type EBITDA into the screener query, select the trailing annual one and input ">0", and it gets added to my columns and filtered. In fact, any item from the income statement, balance sheet, cash flow or metrics can be added to the screener. So I can screen by absolute values as well as ratios.
I am going to do another screener. This time, I want to see companies with at least $100 million in revenue, $10 million in net income, at least 15% free cash flow margins, EV/Operating cash flow between 5-15 and a minimum of 10% sales CAGR per share over the past 5 years. When referring to millions or billions, I can type 100m or 0.1b and screener will recognize it as $100 million. This is how the screen looks like:
2. Screening by ticker
The Stockrow screener also allows users to input individual tickers and then add columns to easily compare them. I am going to use a list of 20 SaaS companies and paste it into the Ticker query:
I have also added columns Revenue growth (quarterly), gross margin, EBIT margin, EV/Sales and operating cash flow to easily compare the companies between themselves. I can quickly see, that Alteryx (AYX), Coupa Software (COUP) and Okta (OKTA) are the fastest growing of the bunch, while some of them already have positive operating margins.
There are literally hundreds of available indicators which are group into categories: valuation, profitability, ratios, per share, price, growth efficiency, income, cash flow, balance sheet and other. You can screen by EV/Sales, EV/EBITDA, P/Operating cash flow, Return on Capital, 3/5/10-year growth rates and many more.
Hope this guide was helpful and if you have any questions, reach out to me at firstname.lastname@example.org!