search

diegomanuel / binance-to-google-sheets

Google Spreadsheets add-on to get data directly from Binance API without any intermediaries! :rocket:
GNU General Public License v3.0
426 stars 76 forks source link

Formula Parse Error #78

Open nhoornweg opened 3 years ago

nhoornweg commented 3 years ago

Can't get this to work... Copy-paste exact instructions and still get a "Formula Parse Error". See attached file. I'm using the scripts etc just as described. The add-in is authorized and seems to be working, yet I don't get a value.

What am I doing wrong? 27 05 2021_12 09 38_REC 27 05 2021_12 09 57_REC

vladgaidar commented 3 years ago

Same problem, help with solution

nhoornweg commented 3 years ago

Update: Really strange but when I open a totally new Google sheet, incl. the script etc. as per described, it works...

JoaoPauloSouza commented 3 years ago

Update: Really strange but when I open a totally new Google sheet, incl. the script etc. as per described, it works...

seems we have a similar root issue #77, i just created a new sheet and works like a charm.

nhoornweg commented 3 years ago

Update 2: Just found the issue (I think). Go to file, spreadsheet settings, generale. Under dropdown 'locale' change to United Kingdom... And poefff, the formulas work... Before I had it set to Netherlands. Once I changed to UK it worked... Don't know why. Also works when changing to United States... Didn't try other countries... Anyway, solved :)!

EduardoJabour commented 3 years ago

I had the same problem, but I tried booth creating a new sheet and updating 'locale' to UK/US and the error persists. Any ideas?

JoseSolana commented 2 years ago

Update 2: Just found the issue (I think). Go to file, spreadsheet settings, generale. Under dropdown 'locale' change to United Kingdom... And poefff, the formulas work... Before I had it set to Netherlands. Once I changed to UK it worked... Don't know why. Also works when changing to United States... Didn't try other countries... Anyway, solved :)!

It works for me.

Thank you very much!

l4r53n commented 2 years ago

Make sure the option "Always use the names of the functions in English" is checked in locale settings