BasicsGetting StartedHow to use MarketXLS

Marketxls New Release Version 9.3

Written by Meesha Ghedia
Tue Jun 01 2021
MarketXLS - new release
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
MarketXLS - new release
 

Key Updates in this Release

1. New Guru Screens Functions

In this release, we have added many advanced Guru Screen functions. Guru Screens are used to filter out stocks based on the winning investment strategies of stock market legends such as Warren Buffet, Benjamin Graham, etc.

Here is a list of Guru Screen functions MarketXLS is offering in this new release: 

=gs_Buffettology_EPS_Growth()

=gs_Foolish_Small_Cap_8_Screen()

=gs_Graham_Defensive_Investor_Non_Utility_Screen()

=gs_Graham_Defensive_Investor_Utility_Screen()

=gs_Graham_Enterprising_Investor_Revised()

=gs_Kirkpatrick_Value_Screen()

=gs_Lynch_Screen()

=gs_Murphy_Technology_Screen()

=gs_O_Shaughnessy_Small_Cap_Growth_And_Value_Screen()

=gs_O_Shaughnessy_Tiny_Titans_Screen()

=gs_Oberweis_Octagon_Screen()

=gs_Walter_Schloss_New_Lows_Screen()

=gs_Wanger_Revised_Screen()

=gs_Weiss_Blue_Chip_Div_Yield_Screen()

=gs_Templeton_Screen()

=gs_T_Rowe_Price_Screen()

=gs_Zweig_Screen()

In the upcoming releases, we will be adding more Guru Screen functions.

Guru Screens

2. New Premium Templates

We have released about 100 new premium MarketXLS templates on various option strategies and stock valuation techniques. Download these templates with the coupon code “JUN-SAVE-20” from the template store below to receive a 20% discount. Here is the link to the premium templates: https://marketxls.com/marketxls-templates/

Options templates

You can download our available free templates: https://marketxls.com/templates

3. Speed Optimization in Refresh-on-Demand Functions 

We have made speed improvements for the Refresh-On-Demand function. Refresh on-demand functions call the real-time stock prices in your Excel and require a click on the refresh button on the MarketXLS menu. This speed improvement will pull real-time data five times faster than before when you click on the Refresh button.

Speed Optimization

4. Options Scanner

We have made improvements in the options scanner and added drop-down menus that allow the user to filter options accordingly. The option scanner lets you choose a group of stocks in excel cells, get all the option contacts for those stocks and lets you filter the best options for you. 

Options Scanner

5. Ascending + Descending order in Historical Functions

With this new version, you will be able to sort your data in ascending and descending order. Sorting data will make it easier for users to analyze their stocks. 

ASC.gif”>Ascending stocksASC” loading=”lazy” src=”https://marketxls.com/wp-content/uploads/2021/06/ASC.gif” data-width=”586″ data-height=”279″ data-link-wrap=”true”>

Users can also use the custom dates function and sort the dates by ascending and descending order. 

ASC.png”>Ascending stocksASC” loading=”lazy” src=”https://marketxls.com/wp-content/uploads/2021/06/ASC.png” data-width=”586″ data-height=”480″ data-link-wrap=”true”>

6. YouTube Channel & Options Strategy Videos

We are posting new videos every day on our MarketXLS YouTube channel. The videos are on options strategies that MarketXLS templates offer. It is a great way to understand the options strategy and how MarketXLS can help you to implement it. Here is the link to YouTube videos: https://marketxls.com/marketxls-video-tutorials/ 

MarketXLS Youtube

7. New Stock Screener

We have added an updated stock screener that will allow you to filter your stocks according to different parameters of your choice. We are continuously adding more columns/parameters that you can use to screen your stocks. 

Stock Screener

8. New Blogs

We continue to publish many informative articles on MarketXLS website. We are sure you will find them useful, please review them at this link below and let us know if you would like us to cover any specific topics.  https://marketxls.com/blog 

Finance blogs

What are we working on for the next release?

We are working on the following items for the new upcoming release:

  1. More stock screening functions
  2. New stock screener
  3. Machine Learning module for pattern recognition and finding market opportunities
  4. New version for Excel Online
  5. Broker integrations with Think Or Swim, Interactive Brokers, etc.
  6. New cryptocurrency data and analytics
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
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

Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

108.01
 
USD
 
-0.39
 
(-0.36%)
84
Rank
Optionable: Yes
Market Cap: 8,953 M
Industry: Auto & Truck Dealerships
52 week range    
72.35   
   119.47
Zim Integrated Shipping Services Ltd logo

Zim Integrated Shipping Services Ltd

64.70
 
USD
 
0.94
 
(1.47%)
80
Rank
Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
33.71   
   91.23
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

24.07
 
USD
 
-0.55
 
(-2.23%)
79
Rank
Optionable: No
Market Cap: 684 M
Industry: Trucking
52 week range    
15.86   
   26.90
NRG Energy Inc. logo

NRG Energy Inc.

45.72
 
USD
 
-0.49
 
(-1.06%)
79
Rank
Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
31.94   
   46.86
Corteva Inc. logo

Corteva Inc.

59.23
 
USD
 
0.23
 
(0.39%)
79
Rank
Optionable: Yes
Market Cap: 41,692 M
Industry: Agricultural Inputs
52 week range    
40.60   
   62.04
Avnet Inc. logo

Avnet Inc.

46.30
 
USD
 
-0.27
 
(-0.58%)
78
Rank
Optionable: Yes
Market Cap: 4,732 M
Industry: Electronics Distribution
52 week range    
35.71   
   48.75
Universal Corporation logo

Universal Corporation

59.59
 
USD
 
-0.47
 
(-0.78%)
77
Rank
Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
46.24   
   63.46
Kronos Worldwide Inc logo

Kronos Worldwide Inc

17.50
 
USD
 
-0.52
 
(-2.89%)
77
Rank
Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
12.06   
   18.48
Boise Cascade L.L.C. logo

Boise Cascade L.L.C.

76.72
 
USD
 
-1.29
 
(-1.65%)
77
Rank
Optionable: Yes
Market Cap: 3,260 M
Industry: Lumber & Wood Production
52 week range    
46.51   
   85.17
Rollins Inc. logo

Rollins Inc.

35.28
 
USD
 
0.95
 
(2.77%)
76
Rank
Optionable: Yes
Market Cap: 17,428 M
Industry: Business Services
52 week range    
28.51   
   40.11

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!