Troubleshoot

#1. API Keys

  • Recreate your API keys and paste them into the sheet.

  • Don't share API keys with other apps or your bot. All our sheets can use the same keys.

  • Don't use IP address restriction on your exchange. The Google Cloud has many IP addresses ;-)


#2. Set (startup) Triggers

Set the recommended Triggers by clicking the Trigger button in CONFIG.

Refresh the url or exit the sheet and open it again.

If Triggers are set, a startup Trigger will automatically run the script when the sheet opens.


#3. See our Exchange Specific Notes

All exchanges are different and they all have different APIs.

Please see our Exchange Specific Notes for any specifics


#4. Look at the log file

In Cointrexer, set Debug to ON in CONFIG (*1) and add 'debug' as Third Attribute in CtrXL - watch video

Run the script by pressing the update button

Open the script editor [Tools], [Script Editor]

View the logs [View], [Logs] or Ctrl+Enter

(*1) this switch is available for most exchanges and pops-up a windows with the raw data it received from the exchange. See Exchange Specific Notes

Copy the Log details:

Click the Logs windowsSelect All (ctrl-a) Copy to clipboard (ctrl-c)Open Notepad or an other editor (or email) and paste the clipboard content with ctrl-v

#5. Numbers are way off!!!

Check the decimal settings in Google Sheets.

File, Spreadsheet setting

Set the Locale to United Stated


#6. Sheet 'suddenly' stopped working but worked before?

  • Check our website to see if there is an update

  • Make a new copy from the website to troubleshoot if it is related to your copy

  • Did you change anything in the Script Editor?

Try:

Set the correct runtime (disable V8):

- [Tools], [Script Editor]

- [Run], [Disable V8 Runtime]


#7. Evaluation Expired

Please see howto unlock the Trial version


#8. Mobile Client - sheet does not update

The Google Sheets Mobile client (IOS or Android) does not support scripts but there is a workaround:

Option 1: Use Chrome in Desktop Mode

  • Uninstall the Google Sheets Mobile Client if it is on your device (uninstall it)

  • Start Chrome and load your sheet in Chrome

  • On the upper Right Top corner, click on the three dots. A drop-down menu Opens

  • Select "View in Desktop Mode".

  • Notice, the button your Spreadsheet is now clickable, as the sheet interprets the user to be logged on to a PC

  • Now, Just Click on the button and let the script do its magic


Option 2: Manually change Triggers

  • You can manual tune your Triggers to minutes or to update on cell change

  • Please be aware of the Google Quota of your free Google Account and respect the exchange APIs so please turn caching ON in CtrXL

  • Menu [Tools],[Script Editor] do not enable the V8 runtime!

  • Click the Clock icon to access the Trigger Menu


#9. Ask Moosy

Feel free to drop us an email. We are happy to support you and to get you going.

moosylog@gmail.com - CET (Central European Time)


USEFUL LINKS:

Remove authorizations and re-authorize: https://myaccount.google.com/permissions

Google Quotas: https://developers.google.com/apps-script/guides/services/quotas

Review all script executions: https://script.google.com/home/executions

Your Triggers: https://script.google.com/home/triggers


#TIP: How to stop receiving email failures for Google Apps Script

By default, Google script sends execution failure messages to your mailbox.

How to stop receiving email failures for Google Apps Script: Email Scheduler for Gmail? Read this or see this howto video: https://youtu.be/sr0f5DzyoTs

Get an overview of all executions: https://script.google.com/home/executions