It was just recently I made my first investment in cryptocurrencies, 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 dollar cost averaging and decided to build a separate Google Spreadsheet to track value changes, gains, or losses.
For support please visit the Terramatris website: Custom Google Spreadsheet Development for Crypto Currency Portfolio Tracking
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.
Update: This article originally was written back in 2017, the formula(s) listed in this article have changed several times. If not working look into the comments section for any help
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 cryptocurrency Google Spreadsheet tracking real-time prices for bitcoin, ethereum and litcoin
Tracking cryptocurrency portfolio with Google Spreadsheets
Let me explain a bit in details:
Column A - Currency - pretty self-explanatory
Column B - for each cryptocurrency entered in Column A add respective value from coinmarketcap.com
- Ethereum - http://coinmarketcap.com/currencies/ethereum/
- Bitcoin - http://coinmarketcap.com/currencies/bitcoin/
- Litecoin - http://coinmarketcap.com/currencies/litecoin/
- And so on
Column C - paste following:
=IMPORTXML(B3,"//span[@id='quote_price']/@data-usd")=IMPORTXML(B3,"//span[@class='cmc-details-panel-price__price']")
you will get a 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, File -> Make a copy
For support please visit the Terramatris website: Custom Google Spreadsheet Development for Crypto Currency Portfolio Tracking