Live Updated Cryptocurrency Investment Tracking Spreadsheet

Read the latest version of this article here.

This Google Spreadsheet can help you track your cryptocurrency investments. It gets the prices from an external API and keeps them updated. It supports the 15 most popular cryptocurrencies. It uses Poloniex and Cryptocompare APIs to retrieve latest currency’s rates:

Cryptocurrencies Value Calculator

It uses a script based on FastFedora Project which can be optionally downloaded from GitHub.

Instructions:

  • Go to the Google spreadsheet here.
  • Go to File -> Make a Copy.
  • Put you own cryptocurrencies and values.
  • Enjoy!
  • Hat_trick

    This is great. Thank you!

  • This is fantastic! Thank you!

    I was playing around with it last night and created a version which also keeps track of your transaction history and then determines your balance based on that history. In addition, I added calculations of an asset’s value in USD, BTC, and BTS. I’m really enjoying the Open Ledger decentralized exchange, but I needed a better way to keep track of what the value should be in terms of BitShares. I hope you don’t mind the link, but here’s an article I just posted about it: https://steemit.com/crypto/@lukestokes/the-cryptocurrency-bank-spreadsheet

    Thanks again!

    • pipaman

      Thank you for sharing!

  • does the error related to API limit per day fetching the JSON go away when you clone it to your own sheet? I’m guessing not, haven’t tried obv

  • Onakhe Adrian

    It is posible to get the data directly from coincap.io ? thx