Download free Cryptocurrency Investment Tracker in Microsoft Excel and Spreadsheet. This free excel template is useful in keeping track of your crypto assets and crypto investments. This is useful for fund managers, retail investors and emerging crypto enthusiasts.
Cryptocurrency is a highly volatile market. Hence, one requires a good investment tracker to stay profitable and aware.
About Cryptocurrency Investment Tracker Excel template
This template is simple to download and use. By default, this template comes with the following coins –
- Bitcoin (BTC)
- Ethereum (ETH)
- Litecoin (LTC)
- Ripple XRP
However, you can add more coins and crypto assets as per your portfolio. For that, you will have to insert rows and columns in the template file and link the formulae for automatic calculation. There are two sections in this investment tracker template –
- List of coins and investments
- Transaction List and information
1. List of coins and investments
In this section, you will have to update the list of coins that you currently have in your portfolio. For example, if you buy any coin like Cardano (ADA), you will update the basic information like – Number of coins, average cost, Coin value and current market value of that cryptocurrency. Computation of gain/ loss and return percentage happens automatically.
2. Transaction List and Information
In this section, you will cover the details on transactions that you have done over the period of time. For example, if you buy and sell some crypto currency in a day, you will capture all the details. Details include – Date of transaction, type of transaction (Buy or Sell), Currency ticker sign, Exchange where the transaction happened, Quantity or volume of coins. The transaction value and current value computation happens automatically from Section 1 of the template.
You will find total profit or loss for each transaction.
To make profitable trading career in crypto currency, you will always require a transaction tracker or investment tracker sheet to analyze your past transactions. Learning from mistake is the biggest quality a trader should have. Furthermore, you can also add more information field in this template as per your requirement.
If you want to stay updated with news on cryptocurrency, metaverse and NFT space, visit MetaCruch.org.
Download and Use Cryptocurrency Investment Tracker format in excel
To use this free Cryptocurrency investment tracker format in excel, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets.
After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software. Once extracted, you can open the file using Excel and start entering data or customizing the template.