Cryptosheets integrates with numerous popular services in the cryptographic asset space. 

CoinMarketCap

CoinMarketCap is a cryptocurrency market cap rankings, charts, and information website.

Endpoints

Ticker

The ticker is a high level overview of the state of the market. It shows you the current best bid and ask, as well as the latest trade price. 

Importing CoinMarketCap data into Excel

One of the most popular data sources in Cryptosheets is CoinMarketCap. We will use the "Ticker" endpoint in this tutorial.

Required Parameters

  • Currency - Choose what currency you want to display. Default is US Dollar (USD).
  • Limit - specify how many data points you want to return. Default is 10, with the ability to pull all coins offered.
  • Refresh - choose refresh interval. For example, if user chooses 15 minutes, data will automatically pull every 15 minutes, as long as the Cryptosheets window is open. Default is 15 minutes.

Optional Parameters

  • Label - Allows you to customize the tag for specific pulls.

How to pull

After logging in:

Click the "View Dashboard" button in the ribbon

Click the orange "+" symbol at the bottom right of Home

Click "CoinMarketCap Ticker"

Make sure your cursor is in cell A1, and click the "Highlight Range" button

Verify the data will not overwrite any existing cells, and click "Place Data"

Data will be pasted into cell A1 of your worksheet

Resources

CoinMarketCap Website
CoinMarketCap API

Did this answer your question?