Excel sheet to track my cryptocurrency investments
Budget: €30 – €250 EUR
I need an excel sheet that monitors the performance of my cryptocurrency investments in real time, in particular it should have these characteristics:
- the price, the purchase quantity and the purchase date.
- the average purchase price based on the chosen time period.
- the portfolio exposure in relation to that asset compared to the total portfolio.
- the risk based on the total cap I have invested and what I currently have in return or loss.
- future prediction in case we enter a manual price on the chosen asset.
- calculation of the percentages of exposure of cryptocurrencies in the total portfolio.
- calculation of the total investment percentages, i.e. taking the BTC as an example, the value in euros at that moment how much is the percentage of the total portfolio.
- the price, the purchase quantity and the purchase date.
- the average purchase price based on the chosen time period.
- the portfolio exposure in relation to that asset compared to the total portfolio.
- the risk based on the total cap I have invested and what I currently have in return or loss.
- future prediction in case we enter a manual price on the chosen asset.
- calculation of the percentages of exposure of cryptocurrencies in the total portfolio.
- calculation of the total investment percentages, i.e. taking the BTC as an example, the value in euros at that moment how much is the percentage of the total portfolio.