BasicscryptoCryptocurrencyGetting StartedGlobal MarketsHow to use MarketXLSUsing MarketXLS

CryptoCurrency Features in MarketXLS

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

We have been striving hard to make MarketXLS the best investor research tool for you, and your suggestions have been guiding our developments. We are pleased to announce that MarketXLS now includes Cryptocurrency data.

cryptocurrency
stats related to crypto

Now, you may ask, what’s different between MarketXLS data and the rest, so here is why – We have a better methodology of pulling in Crypto data in your Excel.

With MarketXLS, you can use the name of the exchange at the end of the symbol to get the data from that specific exchange.

For example – use BTCUSD:BINANCE to get data from the Binance exchange and ETHUSD: BITMEX to get data from the BitMEX exchange.

However, sometimes, you might find that a crypto token is not listed on an exchange.

So,we have developed our own methodology and symbology for exchanges, which we call “DEFAULT.”

For example –
You can use BTCUSD: DEFAULT to get the default data.

Then, our system will automatically determine where that token is listed and return the most appropriate price and analytics.

You can download a list of all cryptos available straight to your excel by going to “Utilities” and “Utilities List” in the dropdown menu.
Next, choose “Crypto Currencies,” which will open the whole list of cryptos with their exchanges.

crypto features in marketxls

Here is what you can do with Crypto data now being available:
1) Get Intraday prices in your excel using =Last() function, =Ask(), =Bid() functions –

Crypto

Just go to an excel cell and type =Ask(“ETHUSD:DEFAULT”).
Similarly, you can also try other functions such as last and bid to get the desired output.

2) Get historical data points on specific days in the past using =close historicals.

crypto

 

3) Get 20 Technical indicators using technical functions like = SMA, =EMA, etc.

crypto

 

4) Get Other analytical results like Drawdown and Stock Return functions.

crypto

 

5) Use mxls_db_query functions to get Min, Max, High and Low from a range of data series.

crypto

 

6) Get Volume averages.

crypto

 

And a lot more.

To find which functions work with cryptos, click on search and help and search for Crypto. All the functions you will see should be available for crypto symbols.
We have thoroughly changed all the data and analytics, and we believe it may be one of the most comprehensive datasets available in any Excel solution in the market.
Note : Cryptos are not streaming data right now.

Check out our informative knowledge base for a step-by-step guide to MarketXLS.

You can use cryptos on numerous functions such as
=close_historical(), =stockreturnfifteendays(), =custombetaoneyear() and many more.

Our team has also performed minor optimizations to run MarketXLS smoothly.

Email us at support@marketxls.com with any of your concerns or issues that you face.

 

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.90
 
USD
 
0.11
 
(0.10%)
91
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

63.76
 
USD
 
2.46
 
(4.01%)
80
Rank
Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
33.71   
   91.23
Kronos Worldwide Inc logo

Kronos Worldwide Inc

18.02
 
USD
 
1.54
 
(9.34%)
80
Rank
Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
12.06   
   18.31
Group 1 Automotive Inc. logo

Group 1 Automotive Inc.

179.61
 
USD
 
5.39
 
(3.09%)
80
Rank
Optionable: Yes
Market Cap: 3,101 M
Industry: Auto & Truck Dealerships
52 week range    
143.00   
   212.23
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

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

NRG Energy Inc.

46.21
 
USD
 
0.45
 
(0.98%)
79
Rank
Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
31.94   
   46.71
First BanCorp. logo

First BanCorp.

13.64
 
USD
 
-0.16
 
(-1.16%)
79
Rank
Optionable: Yes
Market Cap: 2,795 M
Industry: Banks - Regional - US
52 week range    
10.88   
   16.62
TriCo Bancshares logo

TriCo Bancshares

42.29
 
USD
 
-0.42
 
(-0.98%)
78
Rank
Optionable: Yes
Market Cap: 1,468 M
Industry: Banks - Regional - US
52 week range    
37.41   
   48.96
ManTech International Corporation logo

ManTech International Corporation

94.25
 
USD
 
-0.18
 
(-0.19%)
78
Rank
Optionable: Yes
Market Cap: 3,860 M
Industry: Software - Application
52 week range    
66.91   
   94.73
Universal Corporation logo

Universal Corporation

60.06
 
USD
 
-2.61
 
(-4.16%)
77
Rank
Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
46.24   
   63.46

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!