MS Excel Cryptocoin Portfolio

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

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!