How To Track Your CryptoCurrencies Portfolio Automatically Using Google Spreadsheets

It was just recently I made my first investment in crypto currencies, I spent EUR 50 to acquire about 0.2 ethereum. As I bought them for a long term (buy and hold) and actually I'm planing to acquire more coins every month using average cost dollar,nI decided to build a separate Google Spreadsheet to track value changes, gains or loss.

I see investments in cryptocurrencies as a great alternative to diversify my portfolio. Right now crypto currencies stands at about 0.8% in my portfolio and I'm looking to increase it to about 5% by the end of 2017.

The idea of following spreadsheet was inspired from a regular stock tracking sheet, see: Simple Google Spreadsheet to Track Stock Portfolio Changes Using GOOGLEFINANCE

​Here is a catch, to get real time updates in Google Spreadsheets you will have to use =IMPORTXML function to get real time updates from some crypto currency exchange service. Luckily a Reddit user lawnchairwiz have provided us with solution, see: Easy Way to import ETH price into google sheets

For those that use Google Sheets to track their ETH transactions, here's a quick way to get the price from coinmarketcap.com:

Copy the URL http://coinmarketcap.com/currencies/ethereum/ into cell A1.
In cell B1, type in =IMPORTXML(A1,"//span[@class='text-large']")

You now have the ETH price in cell B1

I built a simple crypto currency Google Spreadsheet tracking real time prices for bitcoin, ethereum and litcoin

Tracking crypto currency portfolio with Google Spreadsheets

Tracking crypto currency portfolio with Google Spreadsheets 

Let me explain a bit in details:

Column A - Currency - pretty self explanatory

Column B - for each crypto currency entered in Column A add respective value from coinmarketcap.com

Column C - paste following:

=IMPORTXML(B3,"//span[@class='text-large']") you will get real time price in USD

Optional

I'm purchasing coins in EUR currency and I would love to see their value both in USD and EUR

Column D - paste following

=C3*GoogleFinance("CURRENCY:USDEUR")

Using GoogleFinance function you will get real time USD EUR value

Column E (Coins) - enter how much coins you have

Column F - how much did you spent on them

and so on.

Here is a working Google Spreadsheet, open -> save as copy and give it a try!

Hope it helps guys!