Crypto currency rates tracker for coingecko.com

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.

Enjoy!

UPDATE 2021-10-29

I received a lot of requests about the issue with the currencies with similar symbols. Well, I’ve changed code a little and now you have to pick and place desired ids to the shortlist. Symbols will appear automatically.

Our Visitor

0 0 0 1 5 6
Users Today : 1
Users Yesterday : 2
Users Last 7 days : 13
Users Last 30 days : 41
Users This Month : 1
Users This Year : 155
Total Users : 156
Views Today : 5
Views Yesterday : 13
Views Last 7 days : 34
Views Last 30 days : 67
Views This Month : 5
Views This Year : 204
Total views : 205
Who's Online : 0
Your IP Address : 3.235.180.193
Server Time : 2022-12-01