1 of 3 Spreadsheets dont work
Closed this issue · 6 comments
I use this script for several months now in 3 spreadsheets, but today all prices "loading..." the hole time in 1 sheet... but in the other two it works like always.
Didnt change anything, no reloads, restarts and no creating the script from scratch helped... someone please has any ideas??
It should come back in less than 24h, I think in one of your sheets, they hit their daily google limits.
But its the first time i opened this today and that never happend before o.O
You are probably hitting code 429 which is a limit issue not formula/code issue from Coingecko:
https://support.coingecko.com/help/why-am-i-getting-errors-with-a-status-code-429
In google sheets we are all using the same IP addresses so if someone else is requesting many calls at the same time, you will both exceed the limit together.
I already raised the issue with Coingecko but they are not willing to create specific free api keys right now.
So the general api of coingecko keeps on calling coingecko without success which then triggers Google limits.
Thank you for all that you do :)
I also faced a similar issue - when i enter app script and run the coingecko script, i get the following error - I am guessing it is the same code 429 issue that's mentioned above?
@btanjingwen To check whether the coingecko code is well installed on your Google Sheet, you need to test it out directly in the sheet itself using the formulas. For example you can try to write in a cell :
=geckoprice("btc")
If you have been using the script for a long time and are now experiencing errors, it could be link to your Google account.
Google has been having issues lately and the code has been giving Maximum Call stack as an error lately. The solution right now is to be patient.
Hope this helps!