Custom-made portfolio for my needs

Custom-made portfolio for my needs

By TheCryptoHodler | Managing tools | 17 Feb 2021


I would love to share with you my custom-made portfolio, based on my needs.

 

The template for this portfolio was given to me by a friend, but the modifications made so far are specially made for me.

Unfortunately, i couldn't find a portfolio that meets my needs so far and this is the main reason i am using a custom-made portfolio.

 

The main features I love about this portfolio are:

  • Showing the total owned of each cryptocurrency
  • Showing how much FIAT invested for each cryptocurrency, and how much total
  • The average bought price for each cryptocurrency
  • The total worth of each cryptocurrency in FIAT
  • Profits in FIAT
  • Percentage of profit 
  • Percentage of the portfolio for each cryptocurrency
  • The remaining percentage to hit my target for each cryptocurrency (percentage of my portfolio)
  • The remaining FIAT price to invest in order to hit my target for that cryptocurrency
  • Record all my purchases 
  • Record all stake rewards and fees
  • Adjust prices based on my mistakes (lost money) and include my profits taken as well

 

The above are just some of the features I love to keep track of in order to have a good idea of what is happening to my portfolio precisely every day.

 

The main screen looks like this:

f6063fc56d1e5d2004abf543325664715199c331638a7a5452ecd39f0677301e.png

 

 

And this is what a close look looks like:

4c6587c8b0b6b01d2f74a69d01e569679798d1ff1ce13a1e4fb58021f4dd678a.png

 

In the above example, you can find almost all of the results from the information we already input in the other sheets. 

 

The purchases sheet looks like this :

ff4ca9ac66d1ac3d4940849d88c8ee8f7fdcfc5d5efa40717e029e380ecb42d3.png It shows the date of purchase, the price bought, and the quantity. it also calculates the fiat spend

 

 

Here it is how staked & fees sheet looks like:

fe797a449634a5f35034a2332278f31ae08b03fd4902e6f633fa13b7e5f11702.png here is include all the fees from transfers etc and also the stake rewards. it is also calculating the totals above

 

 

I also have a mistakes and cashouts sheet that I include all my lost FIAT or my cashouts

03c0b172675c67b7178b0c7916958e33c7df53f6aec66084f891f1d28494bee2.png

 

After I input everything I also get the totals here:

b837cbad953952ae7a0dd4197c21f1cb43b7cc9fd270502ee409bfdc9b781a53.png showing the totals and the percentage of profits

 

 

And last but not least. the one-sheet I input the crypto prices every time I want my spreadsheet to get updated:

594da79da43afc481dcecf73a766c7a38f0813b745e8c57fc3b9131115893d60.png

 

 

Other features I'm planning to include later on are :

  • Exit strategy: will show how close you are to the next cash out for each cryptocurrency and the percentage I was planning to sell off from that cryptocurrency
    • all exit strategies on one single sheet
  • Get the prices automated from a website
  • Short term portfolio: will arrange and keep track of your assets for short term

 

Hopefully, this helped you to create yours. If not, and you still want to create yours please contact me. I will assist you in any way I can.

 

Thank you for reading.

Also, since I only started a few months ago, I would love to share with you my crypto journey

How do you rate this article?

9


TheCryptoHodler
TheCryptoHodler

Huge crypto enthusiast here!


Managing tools
Managing tools

Here I will share how I keep track of my coins, losses, earnings, and stakings

Publish0x

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.

Page not displaying correctly?