Recently I’ve found the post with the instructions how to get prices of crypto currencies from coingecko.com.
After cloning proposed spreadsheet instead of the price it begun to show errors:
Exploring the code a little I undestood, that this happens because of popularity of the published spreadsheet. Many people made a copy of it and start tracking crypto currencies from coingecko. But not many people knows that all requests are go from one block of ip and coingecko has limits on quanitity of requests per seconds from one ip. That’s why many of users faced with the error.
I’ve implemented my own tool with different approach – it uses persistent request engine (upto 20 attempts) and updates list of the currencies on the ‘shortlist’ tab every 15 minutes. In order to make it work you have to copy this tool and run Menu->More actions->Install triggers or ‘Refresh manually’ if you need very fresh prices. Symbols for currency could be found on ‘list’ tab.