Stock Screener: Comparing Stocks For Fundamentals History

ByMarketXLS Team
onWed Sep 07 2016
Stock Analysis
Stock Screener: Comparing Stocks For Fundamentals History - MarketXLS

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 stock screeners 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 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 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.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets