Skip to main content
All CollectionsTutorials
How to Paginate using CoinGecko API Endpoints in Cryptosheets
How to Paginate using CoinGecko API Endpoints in Cryptosheets

Many CoinGecko endpoints have a maximum limit for results per call and per page. You can easily pull the full results by paginating.

C
Written by Chris Ware
Updated over a week ago

How to Paginate using CoinGecko Endpoints


To create a larger data set simply create several paginated calls​ and place the formulas (and their outputs) arranged next to and/or below each other.
​

Excel

  1. ​=CS.QUERYA("CoinGecko","Coins Markets","vs_currency","usd","per_page","250","page","1")​

  2. ​=CS.QUERYA("CoinGecko","Coins Markets","vs_currency","usd","per_page","250","page","2")​

  3. .... etc


Google Sheets

  1. ​=CSQUERYA("CoinGecko","Coins Markets","vs_currency","usd","per_page","250","page","1")​

  2. ​=CSQUERYA("CoinGecko","Coins Markets","vs_currency","usd","per_page","250","page","2")​

  3. .... etc

CoinGecko Resources

​

​

​

Did this answer your question?