Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Fundamental analysisOthersScreeners

Stock Screener: Comparing Stocks For Fundamentals History

Written by admin
Wed Sep 07 2016
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

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
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

110.06
 
USD
 
0.24
 
(0.22%)
84
Rank
Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
63.45   
   142.78
Darden Restaurants Inc. logo

Darden Restaurants Inc.

132.22
 
USD
 
6.81
 
(5.43%)
82
Rank
Optionable: Yes
Market Cap: 16,207 M
Industry: Restaurants
52 week range    
110.96   
   158.39
Cintas Corporation logo

Cintas Corporation

411.02
 
USD
 
10.18
 
(2.54%)
81
Rank
Optionable: Yes
Market Cap: 39,137 M
Industry: Business Services
52 week range    
343.86   
   461.44
BWX Technologies Inc. logo

BWX Technologies Inc.

53.56
 
USD
 
1.86
 
(3.60%)
80
Rank
Optionable: Yes
Market Cap: 4,886 M
Industry: Aerospace & Defense
52 week range    
42.58   
   62.53
Texas Roadhouse Inc. logo

Texas Roadhouse Inc.

91.28
 
USD
 
4.17
 
(4.79%)
79
Rank
Optionable: Yes
Market Cap: 6,102 M
Industry: Restaurants
52 week range    
68.58   
   96.11
CVS Health Corporation logo

CVS Health Corporation

100.52
 
USD
 
2.76
 
(2.82%)
79
Rank
Optionable: Yes
Market Cap: 131,966 M
Industry: Health Care Plans
52 week range    
81.78   
   111.25
Arcos Dorados Holdings Inc. Class A Shares logo

Arcos Dorados Holdings Inc. Class A Shares

7.84
 
USD
 
0.18
 
(2.35%)
79
Rank
Optionable: Yes
Market Cap: 1,457 M
Industry: Restaurants
52 week range    
4.33   
   8.44
Waste Connections Inc. logo

Waste Connections Inc.

142.67
 
USD
 
4.65
 
(3.37%)
78
Rank
Optionable: Yes
Market Cap: 35,409 M
Industry: Waste Management
52 week range    
113.50   
   148.20
STORE Capital Corporation logo

STORE Capital Corporation

31.37
 
USD
 
0.01
 
(0.03%)
77
Rank
Optionable: Yes
Market Cap: 8,868 M
Industry: REIT - Diversified
52 week range    
24.48   
   36.13
Evercore Inc. Class A logo

Evercore Inc. Class A

91.26
 
USD
 
6.54
 
(7.72%)
77
Rank
Optionable: Yes
Market Cap: 3,572 M
Industry: Capital Markets
52 week range    
78.67   
   164.63

More Features