The problem is: If your Sheet has 100 or more cryptocurrencies, then soon the server will block your IP address and your Sheet, because of too many requests, queries, and too many requests queries everytime it reload. My Sheet was blocked.
I think that the solution is: Put the url "https://api.coinmarketcap.com/v1/ticker/?convert=USD&limit=70" or "https://api.coinmarketcap.com/v1/ticker/?limit=100" or "https://api.coinmarketcap.com/v1/ticker/?limit=1000" or whatever you want to local computer cache. After that then read from the local computer cache, and you can have as many queries as you need and the server will not block you.
And Please also put an option to modify how long the function will update and reload, for example "5 minutes, 15 minutes, 1 hour, everyday, and elses". This is a good Script, Thank You!
hey can you elaborate further on this local computer cache stuff?