The grass is rarely greener, but it's always different

Following them Cryptos

Near the end of 2020 Bitcoin experienced a surge and if I was not very interested about crypto before, I got acquainted with it very quickly. It is fascinating the gold rush cryptocurrencies are experiencing in this very same moment, awash with people trying to become rich overnight.

I already had plenty of acquaintances getting into crytpo and even a couple close friends working in blockchain-related projects, but it really never got ahold of me. Either ways I thought I'd just read as much as I could about the fundamentals and like any other basic investment put a negligible amount of money every month and take advantage of dollar-cost averaging.

To help me keep track of what I put on crypto every month and track the performance I scrapped together a simple Notion template to introduce the amount of each currency I buy every month, it looks like this with some fake figures I put to illustrate it better.

The Crypto invested in a given year:


This picture is easy to understand, each row corresponds to a month of the year and each column accounts for the amount of the currencies I chose to put money on that month. Since I am not trading coins 24/7 I don't complicate myself.

The crypto returns per month in a given year:


                toNumber(prop("Total Portfolio Value")),
                toNumber(prop("Related Previous Current Market Value")))
                toNumber(prop("Total Portfolio Value")),
                toNumber(prop("Related Previous Current Market Value"))), 2)
    ) * 100
) / 100

Important to know that when there is no valid data to read the PNL will mark a spurious number (200%) until it's filled. Additionally, the PNL formula gives the absolute percentage difference between to amounts but won't show the sign of the difference (+/-).

This is my quick & dirty way of counting all those movements.

Have fun!

#learning #crypto