Getting StartedHow to use MarketXLSRelease Notes

Marketxls New Release Version 9.1

Written by admin
Tue Jun 09 2020
Search for a function MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Search for a function MarketXLS
 

Key Updates in this release

1

New Function Search Utility

To make it easier for you to search for a function and get the details on it, in this release, we have a new Search and Help button on the extreme left of the MarketXLS menu. So, instead of browsing through the Excel-based function list, we will update this form with example usage, function names, and other details. We have more than 600 custom functions now.Click on the Search and Help button on the MarketXLS to open the search form. You can search for a function like “dividends,” “options,” “ETFs,” and so on.

Search for a function MarketXLS2

New ETFs data and functions category

In this release, we have added the following functions in MarketXLS, which can give you detailed information on the Holdings within various ETFs. Alongside the holdings within the ETFs, other data like ETF Fund Family, Net Assets, Total Assets, etc. are also available.

Stock ETF functions3

New Stock Volatility Functions

We have added the following functions in this release, which will get you the historical volatility on stocks. These functions are the standard deviation of historical daily stock returns. We calculate the volatility on all US and Canadian stocks and ETFs after every day’s close. The calculation is the standard deviation of the daily returns of a stock.

Stock Volatility Functionsstockvolatility4

Optimizations on Real-time streaming functions, Refresh All, Refresh Selected Buttons

1) The system will not automatically recognize a changed symbol in a cell and will start streaming the real-time data for the new ticker symbol, instead of needing to click on refresh buttons. 

2) The system will understand if the value of a result is nothing, and then it will return NA instead of a message.

3) Various other minor optimizations on the way the streaming data works, to make it faster.

4) New Streaming On-Off checkbox for you to quickly turn off the streaming data if you need to.

5

Options Filter function

This function will allow you to quickly filter out the option chain for the strike prices and expiry dates. qm_list function can also be used for this purpose. But this is a quick and easy way to get to the right options.  

As an example the following function call will return all the contracts from the option chain where the strike price is 10% above the current price. And the expiry dates are between 2020-06-30 and 2020-08-05

=QM_OptionChainFilter(A1,Last(A1)*1.1, , “2020-06-30”, “2020-08-05”)

Edit your caption text here

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

Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.55
 
USD
 
1.94
 
(3.91%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

92.84
 
USD
 
2.48
 
(2.74%)
81
Rank
Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
69.32   
   93.45
BWX Technologies Inc. logo

BWX Technologies Inc.

56.44
 
USD
 
1.35
 
(2.45%)
80
Rank
Optionable: Yes
Market Cap: 4,846 M
Industry: Aerospace & Defense
52 week range    
42.22   
   61.75
Ritchie Bros. Auctioneers Incorporated logo

Ritchie Bros. Auctioneers Incorporated

67.49
 
USD
 
2.43
 
(3.74%)
77
Rank
Optionable: Yes
Market Cap: 6,928 M
Industry: Business Services
52 week range    
48.44   
   75.28
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

24.33
 
USD
 
-0.16
 
(-0.65%)
77
Rank
Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
19.49   
   29.33
General Mills Inc. logo

General Mills Inc.

75.79
 
USD
 
0.34
 
(0.45%)
76
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   75.96
CRA InternationalInc. logo

CRA InternationalInc.

89.15
 
USD
 
-0.17
 
(-0.19%)
76
Rank
Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
78.05   
   115.47
ConAgra Brands Inc. logo

ConAgra Brands Inc.

34.56
 
USD
 
0.32
 
(0.93%)
76
Rank
Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
29.80   
   36.67
Agree Realty Corporation logo

Agree Realty Corporation

73.53
 
USD
 
1.40
 
(1.94%)
76
Rank
Optionable: Yes
Market Cap: 5,522 M
Industry: REIT - Retail
52 week range    
60.78   
   74.67
UNITIL Corporation logo

UNITIL Corporation

61.00
 
USD
 
2.28
 
(3.88%)
75
Rank
Optionable: Yes
Market Cap: 928 M
Industry: Utilities - Diversified
52 week range    
39.90   
   61.08

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!