BasicsCalculatorsFAQFundamental analysisGetting StartedHow to use MarketXLSInformativeMy AccountScreenersStock ComparisonsStock exchangesStock investmentsStocksUsing MarketXLS

MarketXLS Screener Release

Written by Param Shah
Tue May 31 2022
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

We take pride in announcing that marketXLS isn’t limiting itself to just excel sheets. Our focus lies on providing the best value for your money and hence we are constantly innovating. We are thrilled to announce the launch of our stock screener on the website along with tonnes of other features.

Key Updates –

Get Started – 

  1. We will get into the features soon but before you start using all these features you need to create an account on the MarketXLS website.
  2. Just go to – https://marketxls.com/authorization/registration and enter your details associated with your marketXLS account including the license key that you use to access the MarketXLS excel add-in.
  3. Once done you can proceed to log in to the website and start using all our functionality.
  4. If you have any doubts or problems with registration please reach out to us at – support@marketxls.com or drop us a message on the chatbot on our website

1) MarketXLS Screener

Using the MarketXLS Screener you can find stocks based on hundreds of fundamental and technical indicators on our website itself.
All you need to do is go to https://marketxls.com/screener and add your desired rules to find the stocks as per your liking.

You can also find the screener under the features tab at the top of every page.

Also, you can access the screener directly from Excel by clicking on the screener’s tab on the top. You can add the rules by clicking on the add rule button under the Applied Filters tab.

  1. Here you can select a metric that you want to filter and then proceed to add the corresponding value that you want.
  2. We have categorized metrics under the relevant headings for the best experience.
  3. Once that’s done you can decide on the comparison operator and proceed on to adding other rules similarly.
  4. Once you are done adding all the rules you can simply click the save filters button and add a name and a description to the screen that you are creating.
  5. Here you can choose if you want the screen to be public, private, or shared within a team.
  6. Finally, just click the go-to screen button and the website shall display a table of all the stocks that meet your defined criteria.
  7. If you want these stocks in your excel sheet you can just click on the Save button in the right-hand corner of the screen.
  8. Additionally, you can also see some of the screens that we have created in the left-hand corner.
  9. You can just select any one of those and click go to screen to see the filtered stock list.
  10. You can also share the link to your screen by clicking on the share button in the top right corner of your screen.

2)MarketXLS Watchlist

Additionally, you can also individually select the stocks you want from that list and create a custom watchlist which will be saved on the website and can be imported to excel as well using the save button on the right corner.
If you like a stock from the stock ranks page you can easily add it to your watchlist and export it to excel later.

3) Status Page

  1. We have also added a new status option on the website which indicates which functions are live and which are under maintenance.
  2. You can find it in the top right corner of every page.
  3. You can also access it straight from your excel sheet by going into the settings/help tab and clicking the system status button.

4) Stock Ranks Page

Introducing MarketXLS Stock Ranks which will help you improve your odds of stock picking by making all the fundamental and technical information about a stock easily accessible.We provide the information under the following subheads –

1. Overview –

2. Financials –

3. Value –

4. Quality –

5. Technical –

6. Estimates –

7. Peers –

8. Charts –

9. News –

10. Trend Analysis & Forecast

To further simplify it we also provide a MarketXLS score after considering the technical and fundamental aspects of the underlying stock.

To learn more about how we calculate the ranks you can check out our whitepaper – https://marketxls-downloads.s3.us-west-2.amazonaws.com/StockRanking_Algorithm_Decoded.pdf

If you like a stock you can easily add it to your watchlist and export it to excel later.
This information is also available to non-users, so you can send it to your network as well !

 

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Sanderson Farms Inc. logo

Sanderson Farms Inc.

218.61
 
USD
 
-1.29
 
(-0.59%)
81
Rank
Optionable: Yes
Market Cap: 4,908 M
Industry: Packaged Foods
52 week range    
175.42   
   221.63
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

49.95
 
USD
 
0.21
 
(0.42%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Gaming and Leisure Properties Inc. logo

Gaming and Leisure Properties Inc.

46.12
 
USD
 
-0.56
 
(-1.20%)
79
Rank
Optionable: Yes
Market Cap: 11,555 M
Industry: REIT - Diversified
52 week range    
40.57   
   48.57
General Mills Inc. logo

General Mills Inc.

74.72
 
USD
 
4.46
 
(6.35%)
79
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   73.99
National Retail Properties logo

National Retail Properties

44.27
 
USD
 
0.11
 
(0.25%)
78
Rank
Optionable: Yes
Market Cap: 7,768 M
Industry: REIT - Retail
52 week range    
39.12   
   48.19
Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

34.31
 
USD
 
-0.91
 
(-2.58%)
77
Rank
Optionable: Yes
Market Cap: 421 M
Industry: Capital Markets
52 week range    
30.71   
   53.17
Kronos Worldwide Inc logo

Kronos Worldwide Inc

18.47
 
USD
 
-0.70
 
(-3.65%)
77
Rank
Optionable: Yes
Market Cap: 2,213 M
Industry: Specialty Chemicals
52 week range    
11.64   
   19.78
Cowen Inc. logo

Cowen Inc.

25.01
 
USD
 
-0.34
 
(-1.34%)
75
Rank
Optionable: Yes
Market Cap: 704 M
Industry: Capital Markets
52 week range    
21.35   
   41.61
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

62.82
 
USD
 
-0.80
 
(-1.26%)
75
Rank
Optionable: Yes
Market Cap: 8,600 M
Industry: Specialty Retail
52 week range    
45.85   
   74.09
Strategic Education Inc. logo

Strategic Education Inc.

68.03
 
USD
 
-2.49
 
(-3.53%)
74
Rank
Optionable: Yes
Market Cap: 1,760 M
Industry: Education & Training Services
52 week range    
47.09   
   80.29

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!