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.
Create a Google Spreadsheet doc, and name it something cool.
Install this to get updated information from the market. https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn
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)