Cryptocurrency Portfolio v3 for Google Sheets

in #cryptocurrency2 years ago (edited)

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.

docfull.png

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.

pricedata.png

  • 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.

holdings.png

  • graph of % holdings for each asset

graph1.png

  • secondary fiat currency (EUR, KRW, AUD …)

  • ratio between local wallets, exchanges and fiat (keep your assets mostly inside your local wallet)

graph2.png

  • (daily) history

history.png

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/

    Sort:  

    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

    Do you like SteemitBoard's project? Then Vote for its witness and get one more award!

    Coins mentioned in post:

    CoinPrice (USD)📈 24h📈 7d
    BTCBitcoin7356.140$1.21%4.04%
    EOSEOS6.463$-0.11%11.06%
    ETHEthereum285.721$-1.29%-2.77%
    KEYSelfkey0.008$0.23%4.03%

    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