You are viewing a single comment's thread from:
RE: How to import coinmarketcap data into Excel and have it automatically update
Found the answer to my question right after I posted it. The default is 100 lines if not specified otherwise. If you want all data available you'll need the following line: https://api.coinmarketcap.com/v1/ticker/?limit=0. More info on formatting the request can be found on the coinmarketcap site at https://coinmarketcap.com/api/.
I have the same issue and had no luck with using ?limit=0. Only seeing the first 100!
Any ideas would be appreciated.
I would use Excel by Google Drive to import "coinmarketcap".
there you can add "=importhtml("domain","table",1)" and you can have the list right away.
and you can used the domain a few time with "/1" once and than with "/2" and like that you can have as much coins as you like.