Guide for cryptocoins-portfolio in Google Spreadsheet. With input-values.

Hey,

I searched the web for a good portfolio-template, but as with most things I realised I had to make my own system. To help others in my previous situation I have decided to create this step-to-step guide on how to make your own. At the end there will be some input-values I have used. Perhaps they will come in handy for you as well.

1. Create a Google Spreadsheet doc, and name it something cool.

2. Install this to get updated information from the market. https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn

3. Make a nice setup you like.

Here is some codes I have used. The easiest will be to copy/paste, or drag them in the spreadsheet.
Just change the names/inputs to what is needed.

Coin/USD
=CRYPTOFINANCE("btc/usd")

Coin/BTC
=CRYPTOFINANCE("eth/btc")

Value in $
=MULTIPLY(E5;G5) You will need to multiply number of coins with Coin/USD

Value in BTC
=MULTIPLY(E7;H7) You will need to multiply number of coins with Coin/BTC

Percentage of portfolio
=(J5/J27) You will need to divide "Value in USD" with total amount in USD.

24h Change in Coin/USD
=CRYPTOFINANCE("btc/usd";"change")/100 Remove the /100 if you don't want to push the % sign next to fonts etc.

Hope this comes in handy.

/Best regards

(If anyone by any means would want the template I can, with a little help as i don´t know how, fix it)