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.
All cryptos symbols will be using "nameofcrypto:nameofexchange". We are the only ones in the industry to have this kind of a mechanism of getting different cryptos of different exchanges straight to your excel.
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.
Here is what you can do with Crypto data now being available:
- Get Intraday prices in your excel using =Last() function, =Ask(), =Bid() functions
- Get historical data points on specific days in the past using =close historicals
- Get 20 Technical indicators using technical functions like = SMA, =EMA, etc
- Get Other analytical results like Drawdown and Stock Return functions
- Use mxls_db_query functions to get Min, Max, High and Low from a range of data series.
- Get Volume averages
- Download Historical data for a specific time frame.
To find which functions work with cryptos, click on the 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.
You can use cryptos on numerous functions such as =close_historical(), =stockreturnfifteendays(), =custombetaoneyear() and many more.