Crypto Currency Portfolio Balance

This spreadsheet will help you to keep track of your crypto currency portfolio.

You can click here to download the latest version 1.2.0 of the spreadsheet for free.


1) Application of the Spreadsheet Template

This Video will give you an overview over the application of this spreadsheet and show you the built in functions.

  1. Overview
    • Dashboard worksheet
      • Overview table with information about total portfolio value, investment and the profit in € and percent
      • Table with information about the value, invest, balance and profit in euro and percent of each crypto currency
      • Line chart with plots of the total value, invest and profit trend
      • Pie chart with each currency’s euro value of the portfolio
    • History worksheet
      • Contains history of the total portfolio value, invest, profit as well as the amount, exchange rate and invest of every crypto currency
    • API worksheet
      • Contains information like the latest exchange rate in euro, name and symbol of the 200 crypto currency’s with the highest market capitalization from coinmarketcap.com
  2. Functionality
    • Update Exchange Rates
      • Will make an API get request to coinmarketcap.com and get the latest information of the 200 crypto currency’s with the highest market capitalization
    • Add to History
      • Will add the previously entered amount and investment cost of a currency to the portfolio balance in the history worksheet.
    • Add new currency
      • Will add a new crypto currency to the history balance worksheet

2) Coinmarketcap API

This Video will show you how the coinmarketcap API is used to automatically update the crypto currency exchange rates.

Since 2020 Coinmarketcap changed its API to require an account.
Unfortunately, this means that you will have to open a (free) account and change the API request in order to continue using it.
You can find the documentation for the new API at:
https://coinmarketcap.com/api/documentation/v1/#

3) Update Code

In this Video I will explain the code that is used to add a new entry to the history worksheet and add a new currency to the portfolio.

4) Update to Version 1.1

In this Video I will give you a quick overview over the new features of the Crypto Currency Balance Spreadsheet Version 1.1.

With the new Spreadsheet you will now be able to:
1) add exchange trades between different crypto currencies to your portfolio history

5) Update to Version 1.2

In this Video I will give you a quick overview over the new features of the Crypto Currency Balance Spreadsheet Version 1.2.

With the new Spreadsheet you will now be able to:
1) change between 32 different reference currencies
2) run it on every system – independent of the local datetime format



Please enter the E-Mail I should send the template to:

Since 2020 Coinmarketcap changed its API to require an account.
Unfortunately, this means that you will have to open a (free) account and change the API request in order to continue using it.
You can find the documentation for the new API at:
https://coinmarketcap.com/api/documentation/v1/#

3 thoughts on “Crypto Currency Portfolio Balance”

    1. Just enter your email address at the “Please enter the E-Mail I should send the template to:” section on this page and you will get a mail with the download link.
      Please note that Coinmarketcap changed its API since 2020 to require an account.
      Unfortunately, this means that you will have to open a (free) account and change the API request in order to continue using it.
      You can find the documentation for the new API at:
      https://coinmarketcap.com/api/documentation/v1/#

Leave a Reply

Your email address will not be published. Required fields are marked *