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
Dynamic Gantt Chart Excel
1,330
0
  Data Sheet 1 There is First Column in "Data Sheet" name "Options" by selecting any cell you can add…
Monthly Payroll Template
1,580
0
It is a payroll document in which you can record payroll data for multiple employees along with a automated Salary…
Recruitment Template (HR)
1,675
0
 1. Information:  I have created this template to help you conduct a follow-up in the employee recruitment process. - Know…
Learning and Development Planning
1,756
0
NOTE: After downloading the Template please upload it into Google Sheets without making any changes (If you face any problem…
Resource Planning Template
1,810
84
Resource Planning TemplateResource Bandwidth HeatMap  
Dynamic Appointment Scheduler / Calendar Monthly View
2,589
5
Build a calendar showing all days in a chosen month with corresponding scheduled events. 1. Add event to the monthly calendar.2. See…
See All