Crypto Data

Access comprehensive cryptocurrency data across multiple exchanges with MarketXLS's unique symbology system.

No Update Required

This is a server release, so there is no need for you to update your Excel plugin or download anything. Everything should already be working for you.

Available Cryptocurrency Exchanges

Cryptocurrency exchanges available in MarketXLS

Using Exchange-Specific Symbols

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

  • BTCUSD:BINANCE - Get Bitcoin data from the Binance exchange
  • ETHUSD:BITMEX - Get Ethereum data from the BitMEX exchange

DEFAULT Exchange Methodology

Sometimes, you might find that a crypto token is not listed on a specific exchange. We have developed our own methodology and symbology using "DEFAULT" as the exchange identifier.

For example, you can use BTCUSD:DEFAULT to get the default data. Our system will automatically determine where that token is listed and return the most appropriate price and analytics.

Industry-Leading Feature

We are the only ones in the industry to have this kind of mechanism for getting different cryptos from different exchanges straight into your Excel. All crypto symbols use the format: nameofcrypto:nameofexchange

Downloading the Full Crypto List

You can download a complete list of all available cryptos with their exchanges directly to Excel:

  1. Go to Utilities in the MarketXLS ribbon
  2. Select Utilities List from the dropdown menu
  3. Choose Crypto Currencies
  4. The complete list of cryptos with their exchanges will load into your spreadsheet
Crypto currencies menu item in MarketXLS

What You Can Do with Crypto Data

Here are the capabilities now available with cryptocurrency data:

  1. Intraday Prices: Use =Last(), =Ask(), =Bid() functions
  2. Historical Data: Get data points on specific days using =close_historical()
  3. Technical Indicators: Access 20+ technical indicators like =SMA(), =EMA(), etc.
  4. Analytical Results: Calculate drawdown and stock returns
  5. Database Queries: Use mxls_db_query() functions for Min, Max, High, and Low from data series
  6. Volume Analysis: Get volume averages and trading activity
  7. Historical Downloads: Download historical data for specific time frames

Finding Crypto-Compatible Functions

To find which functions work with cryptos, click on Search and Help and search for "Crypto". All the functions you see should be available for cryptocurrency symbols.

You can use cryptos with numerous functions such as =close_historical(), =stockreturnfifteendays(), =custombetaoneyear() and many more. We believe this may be one of the most comprehensive cryptocurrency datasets available in any Excel solution on the market.

← Previous: Growth FunctionsNext: Watch List →