Hi, this is an awesome sheet, and just what I've been looking for. I followed the instructions but when I run the UPDATE the following error appears:
Request failed for https://api.coinmarketcap.com/v1/ticker/powerledger?convert=EUR returned code 404. Truncated server response: { "error": "id not found" } (use muteHttpExceptions option to examine full response). (line 73, file "Code")
Any suggestions on how I can fix it?
I receive the same error. Did you manage to solve it?
I solved my error: in coin Id, I had to state the exact name as it appears on Coinmarketcap (e.g. "Stellar" instead of "Stellar Lumens"). With that it updated correctly :)