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?