Cryptosheets Help Center

All Collections

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

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

Google Sheets

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

CoinGecko Resources