Get Cryptocurrency Listings Latest

Returns a paginated list of all active cryptocurrencies with latest market data. The default "market_cap" sort returns cryptocurrency in order of CoinMarketCap's market cap rank (as outlined in our methodology) but you may configure this call to order by another market ranking field. Use the "convert" option to return market values in multiple fiat and cryptocurrency conversions in the same call.

How to use CoinMarketCap data in Excel & Googlesheets with Cryptosheets

This article demonstrates three examples of how to pull CoinMarketCap API data into your spreadsheet using the side panel console, custom functions and templates.

Explore more CoinMarketCap endpoints here

Example Parameters:

X-CMC_PRO_API_KEY: Your X-CMC_PRO_API_KEY
start: 1
limit: 100
price_min: 1000
price_max: 6000
market_cap_min: 1000000000
market_cap_max: 2000000000
volume_24h_min: 1000000
volume_24h_max: 2000000
circulating_supply_min: 10000000
circulating_supply_max: 100000000
percent_change_24h_min: 10
percent_change_24h_max: 5
convert: USD
sort: market_cap
sort_dir: asc
cryptocurrency_type: all
aux: num_market_pairs,cmc_rank,date_added,tags,platform,max_supply,circulating_supply,total_supply

Example Fields:

symbol max_supply quote platform error_message percent_change_7d id status last_updated total_supply name data usd last_updated volume_24h notice num_market_pairs market_cap circulating_supply percent_change_24h percent_change_1h timestamp error_code elapsed slug credit_count cmc_rank tags date_added price

Excel:

=CS.QUERY("CoinMarketCap","Get Cryptocurrency Listings Latest",{"X-CMC_PRO_API_KEY","Your X-CMC_PRO_API_KEY";"start","1";"limit","100";"price_min","1000";"price_max","6000";"market_cap_min","1000000000";"market_cap_max","2000000000";"volume_24h_min","1000000";"volume_24h_max","2000000";"circulating_supply_min","10000000";"circulating_supply_max","100000000";"percent_change_24h_min","10";"percent_change_24h_max","5";"convert","USD";"sort","market_cap";"sort_dir","asc";"cryptocurrency_type","all";"aux","num_market_pairs,cmc_rank,date_added,tags,platform,max_supply,circulating_supply,total_supply"})

Googlesheets:

=CSQUERY("CoinMarketCap","Get Cryptocurrency Listings Latest",{"X-CMC_PRO_API_KEY","Your X-CMC_PRO_API_KEY";"start","1";"limit","100";"price_min","1000";"price_max","6000";"market_cap_min","1000000000";"market_cap_max","2000000000";"volume_24h_min","1000000";"volume_24h_max","2000000";"circulating_supply_min","10000000";"circulating_supply_max","100000000";"percent_change_24h_min","10";"percent_change_24h_max","5";"convert","USD";"sort","market_cap";"sort_dir","asc";"cryptocurrency_type","all";"aux","num_market_pairs,cmc_rank,date_added,tags,platform,max_supply,circulating_supply,total_supply"})

NOTE: Some international users may need to substitute commas "," in custom functions with semicolons ";" so for something like =CS.TA("BTC","USD") try =CS.TA("BTC";"USD") instead

Usage

Cryptosheets data can be pulled through multiple interfaces:

Setup

Install the Cryptosheets add-in from the Microsoft AppSource Store
Install the Cryptosheets add-in from the Google GSuite Marketplace
After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel

Using the console

From the Cryptosheets Excel ribbon click data
From the Googlesheets Add-ons menu click Cryptosheets then select Launch side-bar
Type in CoinMarketCap... then click on Get Cryptocurrency Listings Latest
Scroll through the console parameters and input your values
Select the cell you want to place the data into
Click make request

Using custom functions

Tip: For both Excel and Googlesheeets you can use either the QUERY or QUERYA custom function

Excel In any cell type the following:

Googlesheets In any cell type the following:

In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the function/formula builder, then click the clipboard icon to copy the full formula string and paste it into any cell see detailed examples and tutorial

Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell: =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Latest") for Excel or =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Latest") for Googlesheets

Using templates

From the Cryptosheets Excel ribbon click templates OR click on the templates tab in the browse section
From the Googlesheets Add-ons menu click Cryptosheets then select Templates
Load the template called Query Builder and type CoinMarketCap and Get Cryptocurrency Listings Latest
You can also try searching "CoinMarketCap..." for other templates

Signing up for Cryptosheets is free get crypto data in 30 seconds or less

Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work. Learn more here

Helpful Resources:

Visit the API documentation for CoinMarketCap here
See tutorials and examples for CoinMarketCap on the Cryptosheets YouTube channel
Troubleshooting: please reference the following troubleshooting code: QUE-633-2089. Learn more here

Tags: Get Cryptocurrency Listings Latest CoinMarketCap endpoint

Concepts

Functions

Metadata

Providers

Resources

Templates