Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
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
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get 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

Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

42.74
 
USD
 
1.08
 
(2.59%)
85
Rank
Optionable: Yes
Market Cap: 451 M
Industry: Capital Markets
52 week range    
28.41   
   50.14
Midland States Bancorp Inc. logo

Midland States Bancorp Inc.

27.57
 
USD
 
0.66
 
(2.45%)
83
Rank
Optionable: No
Market Cap: 589 M
Industry: Banks - Regional - US
52 week range    
23.48   
   30.60
Kroger Company (The) logo

Kroger Company (The)

48.41
 
USD
 
-0.78
 
(-1.59%)
83
Rank
Optionable: Yes
Market Cap: 35,325 M
Industry: Grocery Stores
52 week range    
41.82   
   62.78
Ingles Markets Incorporated Class A Common Stock logo

Ingles Markets Incorporated Class A Common Stock

100.76
 
USD
 
-0.34
 
(-0.34%)
83
Rank
Optionable: Yes
Market Cap: 1,910 M
Industry: Grocery Stores
52 week range    
74.63   
   102.88
Amdocs Limited logo

Amdocs Limited

89.99
 
USD
 
1.13
 
(1.27%)
82
Rank
Optionable: Yes
Market Cap: 10,525 M
Industry: Software - Infrastructure
52 week range    
69.79   
   90.77
Tecnoglass Inc. logo

Tecnoglass Inc.

30.37
 
USD
 
1.37
 
(4.72%)
81
Rank
Optionable: Yes
Market Cap: 1,349 M
Industry: Building Materials
52 week range    
16.05   
   34.08
Interpublic Group of Companies Inc. (The) logo

Interpublic Group of Companies Inc. (The)

34.46
 
USD
 
0.10
 
(0.29%)
81
Rank
Optionable: Yes
Market Cap: 13,330 M
Industry: Advertising Agencies
52 week range    
25.14   
   39.98
Guess? Inc. logo

Guess? Inc.

20.71
 
USD
 
-0.05
 
(-0.24%)
81
Rank
Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
14.27   
   25.27
Bristol-Myers Squibb Company logo

Bristol-Myers Squibb Company

80.88
 
USD
 
0.60
 
(0.75%)
81
Rank
Optionable: Yes
Market Cap: 168,030 M
Industry: Drug Manufacturers - Major
52 week range    
55.76   
   81.44
Best Buy Co. Inc. logo

Best Buy Co. Inc.

86.47
 
USD
 
1.17
 
(1.37%)
81
Rank
Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    
60.79   
   112.96

More Features