Here is CryptoCurrency Portfolio Template version 2 for Google Sheets:

https://docs.google.com/spreadsheets/d/1thBM8j6R_q9XWQCKEXtXo59TtHormuyBrFoEduU7iU8/edit?usp=sharing

![Screen Shot 2018-02-08 at 8.20.45 PM.png](https://steemitimages.com/DQmPQ7Aa4iXZJazn4Uq2ttK2smLDZgNYFPid5cauSXQodtb/Screen%20Shot%202018-02-08%20at%208.20.45%20PM.png)

I also made a YouTube video on setup and adding new crypto:
https://www.youtube.com/watch?v=P3EO0p2LBb8

Version 2 Updates:
1. YouTube Video - Setup & Adding Crypto.
2. Added 1h percent changes column. It’s hidden by default. You can show it by clicking arrows between column E and G.
3. Added 3 columns (J,K,L) for marketcap, available supply & total supply. (hidden by default)
4. Added “ETH” column and ETH gains calculator. (Do not delete Ethereum from the sheet for it to function properly)
5. Added “Add” coin button. It will copy last row. You have to fill out the COIN ID and update crypto holdings.
6. Added “Update” button. Don’t abuse it though.
7. Added “Cash holdings” in AM13.
8. Better UPDATE performance when you have a lot of cryptos(>30) : request top 100 coins and uses it as cache.

Here is the link to original steemit post and update post for version 1:
* https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-for-google-sheets
* https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-update

If you want to contribute:
* Please upvote or resteem this article
* Use my referral link to join Binance: https://www.binance.com/?ref=10032265
* You can find my Ethereum and Bitcoin addresses in the template