Cryptocurrency Portfolio v3 for Google Sheets
I’m sharing my cryptocurrency portfolio template for Google Spreadsheet (again!).
There are many crypto exchanges and multiple ways to store your coins. I couldn’t find an easy way to manage my cryptocurrency portfolio. I wanted to track where all my coins are stored. And I wanted flexibility so I could customize. With Google sheet it’s really easy to customize.
The sheet uses CoinMarketCap.com API. This is the third version. There were some important changes to coinmarketcap’s API. They will deprecated the old API, so I had to update to make it work. They came out with a “Pro” API, and you need API KEY to access the new API. So users have to sign up for their pro API service. There is a “free” starter plan, but you only get 200 API calls per day. So I had to optimize to minimize calling the API. Now it is only 1 API call per “UPDATE”.
You can register a timer to run the script to get prices periodically/automatically.
Here are some features portfolio sheet provides:
- fetch price data(price in USD, BTC, 1h/24h/7d change, rank, market cap, available supply, total supply) from coinmarketcap.com. It also displays price in secondary fiat currency(you can choose) and also in ETH.
- Track where your crypto assets are located. You can add new columns. Just make sure the sum(MY COINS) is correctly calculated. Price of your assets in BTC/USD/Secondary currency is calculated automatically.
- graph of % holdings for each asset
secondary fiat currency (EUR, KRW, AUD …)
ratio between local wallets, exchanges and fiat (keep your assets mostly inside your local wallet)
- (daily) history
Here is the link for the Cryptocurrency Portfolio v3 for Google sheet:
https://docs.google.com/spreadsheets/d/1d1LIILS7Kny-wPZn2-lkPyfTuDbcWMYvUp1NIzhQWqM/edit?usp=sharing
Please watch the YouTube video for initial setup. You will need to get a free API KEY from https://pro.coinmarketcap.com/signup. You also need to allow access from the script editor.
Youtube Videos:
Setup:
Changing secondary currency and hide/unhide columns:
If you have any problems using the sheet or you have some suggestion for improvements, please feel free to contact me.
If you want to contribute, please follow below link and signup on Trybe.one. Trybe.one is a new social platform running on EOS blockchain.
https://trybe.one/cryptocurrency-portfolio-v3-for-google-sheets/ref/5326/
Congratulations @mix1009! You have completed the following achievement on Steemit and have been rewarded with new badge(s) :
Award for the number of posts published
Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word
STOP
Coins mentioned in post:
Thanks a ton for making this great portfolio, mix.
One question for you: How can I automate/script the portfolio percentage column or the dollar value (per asset, USD, or Percentage) column to automatically sort from Z-A (highest value to lowest value)? I would like to do it whenever I hit the amazing update button you have added. Thank you very much, again.
I love this spreadsheet you made, and used V1 for a long time. Now switching over to V3 and ran into a snag.
After getting a new API from CMC and adding it to the script, the script shows error 401 (missing/invalid API key). Found the following thread on Stack Overflow, but don't see a "const" in the script. Any ideas? (FYI, I'm not a coder).
https://stackoverflow.com/questions/55287525/coinmarketcap-api-integration-401-error-javascript