MS Excel Cryptocoin Portfolio

in cryptocurrency •  7 years ago 

I created a simple CryptoCoin Portfolio in MS Excel. It uses the Coinmarketcap.com API for the over1300 various coin and token prices.

You can download it from my OneDrive here:

Crypto Coin Portfolio

CCPortfolio.jpg

The green section represents columns that require manual entry.

  1. The acronym for your coin or token
  2. What type of tender you used to buy it
  3. How it was purchased Manual vs Auto (i.e. using a BOT)
  4. What you paid per coin/token
  5. The cost of one of those coins or token at the time of purchase
    The following columns are auto calculated
  6. The total you spent
  7. What the price is now per coin/token
  8. What your total position is worth
  9. Your position profit
  10. Growth percentage of the position
    This last column is manual as well. You may just want to remove it or make it a date field.
  11. When you bought it.
  12. The GREEN area signifies other columns you are required to fill in
    This is what controls the updates:
  13. Go to the data tab
  14. Click Refresh Data for a manual update, otherwise t refreshes every minute

Enjoy!

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Nice job. You used VBA to do the API calls?

I'll check it out.

Thanks! I had originally thought I would have to code the API connections, but I was able to get it all going through the Excel UI.