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)
This will be of great help especially when deciding whether it is the right time to sell or not. I just installed it.
Congratulations @qnosde! You have received a personal award!
Click on the badge to view your own Board of Honor on SteemitBoard.
Congratulations @qnosde! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Do not miss the last post from @steemitboard:
Vote for @Steemitboard as a witness to get one more award and increased upvotes!