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