Overview

ConfigDefine your starting date and the initial equity that will be invested. On a second tab, list all cryptocurrencies that will be traded containing their code.
PurchasesRecord all your purchases in a row per transaction. Each row should be fully filled with the date, the cryptocurrency that was purchased, transaction fee, the amount invested, and the currency quote at the time. On columns "I" and "J" you will get automatically the quantity purchased and the total amount of that specific currency on your portfolio.
SalesRecord all your sales in a row per transaction. Each row should be fully filled with the date, the cryptocurrency that was purchased, transaction fee, the amount sold, and the currency quote at the time. On columns "I" and "J" you will get automatically the total received and the total amount of that specific currency on your portfolio.
General Investment ReportView the number of purchases and sales you made monthly and the amounts involved in these trades.
Equity Evolution DashboardAn automated and beautiful dashboard that represents how much your money is yielding to you. Review your monthly metrics of gains and losses.
Portfolio DashboardList with all the crypto-coins you traded and their respective values. This is the area for you to analyze whether you made a profit or a loss with a certain crypto-currency and the possibilities you still have for-profit according to the current quotation of each one

Reviews Add a review
No reviews yet

More From Hafiz Ali

Browse our top rated business templates. See All
Bitcoin Sale and Purchase Excel Template
302
0
ConfigDefine your starting date and the initial equity that will be invested. On a second tab, list all cryptocurrencies that…
Learning and Development Planning
273
0
NOTE: After downloading the Template please upload it into Google Sheets without making any changes (If you face any problem…
Resource Planning Template
351
25
Resource Planning TemplateResource Bandwidth HeatMap  
Calendar Monthly View
390
0
Build a calendar showing all days in a chosen month with corresponding scheduled events. 1. Add event to the monthly calendar.2. See…
Tracking the Employee Leaves is Easy
408
0
This Excel Leave Tracker template can be used to record and monitor employee leaves for a year (of a financial…
Excel Gantt Chart
623
0
This template contains the core functionality needed to create a simple Gantt chart easily. Each row of the worksheet represents…
See All