08-Ago-2018 Update:
Removed update and queries point to CoinFabrik servers to solve quota issues in both Google and Crypto APIs.
You can get the spreadsheet here. To create your own version go to ‘File’ -> ‘Make a copy’.
Keep updated on my Twitter account.
Thanks to the smart contract development team.
Permalink
I highly appreciate your work. Have been looking for a good spreadsheet for a while now, but one problem.
Can you please get back to me to me on how I can add on a new coin?
Thanks for this but I have noticed an issue (that is in version 2 as well). This new version does not change the coin values when you change the currency. If I change to Euros or UK, the price per coin remains in USD. If I add “*Prices!C4” in the rate column on the positions tab, it converts to the desired currency. It would be nice to have it similar to the original spreadsheet, where the currencies updated automatically but I can’t figure out how to do that yet.