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 planning to acquire more coins every month using average cost dollar and decided to build a separate Google Spreadsheet to track value changes, gains or loss.

I see investments in crypto currencies as a great alternative to diversify my portfolio. Right now crypto currencies stand 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 the 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 spend on them

and so on.

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

Hope it helps guys!

If you enjoyed this article and you find this Google Spreadsheet helpful, consider donating some bitcoin. Send any amount you are willing to give to the following BTC address: 3DynNNvHojxfgqtBqCFdr5KYX8oRFygRKS