How to Get Real-Time Cryptocurrency Prices in Google Sheets
How to get real-time prices of any cryptocurrency, fiat currency pairs in Google Sheets using the free Crypto Currency Tracker Google Sheets Add-On.
How to install the add-on:
Source link
It doesn't refresh the price for me unless I force it to do it manually. This is useless if it doesn't refresh automatically and I'd like to be able to select how often it refreshes.
Can't get it to work either. errors even on your templates. Far too complicated for a non programmer. Great idea though for those that can program.
Is this error a spreadsheet or a link/url error??
#ERROR!
Request failed for https://openexchangerates.org/api/latest.json?app_id=https://openexchangerates.org/api/latest.json?app_id=182b298c5f584cc28e345c7bdb0186a3 returned code 401. Truncated server response: { "error": true, "status": 401, "message": "invalid_app_id", "description": "Invalid App ID provided. Please sign up at https://openexchang… (use muteHttpExceptions option to examine full response) (line 169).
I'm getting errors while following these steps, help