Cannot read property 'toUpperCase' about coingecko HOT 15 CLOSED

I'm not sure where the issue comes from. The toUpperCase() function works fine in my country. I know not all Google Sheets have the same specifications. Depending on the country, I've seen differences.

Here is a public template sheet with the embed CoinGecko.gs code.
If you duplicate, it should work fine.

https://docs.google.com/spreadsheets/d/1QODede4loYFnd9ig_f4vRiO4J4uptxn8zIx3qRsLDeA/edit?usp=sharing

from coingecko.

Same issue no luck. The pull gets hung up in "Error Loading Data..."

from coingecko.

+1 same issue here.

from coingecko.

I think I know what MY issue was, maybe it is similar. I just had too many pull requests from google. I left my google sheets up and went to bed. It timed everything out for 24h, gave it a break and it worked. I have since moved on, but I really liked this idea.

from coingecko.

Issue seems to come from the localization of Sheet.

Depending on the country, formulas are written differently.

In File Spreadsheet setting, check that Locale is set as United States

If it's not you can, for example for France, you would call formula using a semi-colon instead of a comma.
Let's say you want Bitcoin's price:

When locale is set to United States formula is:
=GECKOPRICE("BTC","USD")

When locale is set to FRANCE formula is:
=GECKOPRICE("BTC";"USD")

from coingecko.

Im having the same problem.

I changed my spreadsheet time and local to United Stated but it still doesnt read the "toUpperCase" method

from coingecko.

Did you try the 2 formulas one with comma and the other one with semi colon:
When formula is, what do you get ?
=GECKOPRICE("BTC","USD")

When formula is, what do you get ?
=GECKOPRICE("BTC";"USD")

FYI: you can reach me here:
https://t.me/TheCryptoCurious
It's easier to trouble shoot.

from coingecko.

from coingecko.

from coingecko.

Hello,

I'm getting the same issue as stated above.

I have the spreadsheet settings to be in the United States. I've tried copying the spreadsheet you linked above as well, I get the same error when debugging the code on that sheet too.

Has there been any fix for this?

from coingecko.

Hello,

Thank you for letting me know. I changed the settings of the sheets. It should work now when you make a copy of the following sheet:https://docs.google.com/spreadsheets/d/1QODede4loYFnd9ig_f4vRiO4J4uptxn8zIx3qRsLDeA/edit?usp=sharing

from coingecko.

I don't know why but I'm still getting this issue. :/

I've duplicated the sheet, tested it on my own, ran the debug, and it's still not liking the toUpperCase and toLowerCase function.

I'm not sure what other troubleshooting I can do. Any advice?

This is what I'm getting still;
Apr 24, 2021, 2:24:50 PM
Error TypeError: Cannot read property 'toUpperCase' of undefined
at GECKOPRICE(CoinGecko:53:17)

from coingecko.

from coingecko.

What is the message you get when entering your formula in Google Sheets? Can you print screen your formula?

from coingecko.

I don't know what changed, but I made a third copy of the spreadsheet linked above and it seems to be working now.

Thank you for the quick responses, I really appreciate the help and the scripts! :)

from coingecko.