Excel Stock Screener: Comparing Stocks
The MarketXLS stock screeners are designed to help you prioritize and research stocks in the most efficient way. If you want to learn how the excel stock screener work, you should read our articles Stock Screeners by MarketXLS and Stock Screener: In-depth Research of a Stock.
In this article, we will focus on our excel stock screener ‘Comparing Stocks’ that allows you to compare metrics for multiple stocks. Let’s say you are looking at Earnings Before Interest and Tax (EBIT) for Pfizer, and you want to compare it with the EBIT for Merck & Co. This screener allows you to do exactly that. As you can see, in the following screen, I have selected the two stocks from the Company selection box, and EBIT in the Metric selection. The chart shows me the 10-year comparison of EBIT for the two selected stocks.
While it is important that you select only one metric at a time for meaningful results, you are free to select as many companies as you want and compare their metrics on the chart.
Just like the Stock Screener: In-depth Research of a Stock, this excel stock screener also follows the associative principles which makes it easy to select/deselect anything you like at any time in your stock research. For example, let’s say that you want to add one more stock to your comparison, i.e., Johnson & Johnson, first relook at their EBIT and then compare their free cash flow per share.
In the following screen, I’ve added Johnson & Johnson to the list, and can compare their EBIT.
Now that I have compared their EBIT, I can go ahead and compare their free cash flow. To do so, I will first deselect EBIT, change the Financial Statement group to Metrics & Ratios, and then select the metric Free Cash Flow per Share. The chart will immediately reflect the new metric.
These multiple stock screens complement each other and allow you to research stocks and look at the data from multiple dimensions with the goal of providing a complete picture.