I love Portfolio Performance and I’m using it since a couple of months.
I’m trying to track my crypto investments in the easiest way possible but without success so far
I don’t want to track every transaction but just the total value of the crypto portfolio and its evolution and total return of investment
If the total crypto portfolio is worth 100 Euro I was thinking about adding a “virtual” security called “Crypto”, buying 100 shares for 1 Euro each.
If the portfolio at the end of the month is worth 110 I will update the quote manually (110 Euro/100 shares = 1.10 Euro each)
Problem is that if I want to invest more money (or to disinvest) in the crypto portfolio I have to do very complex calculations to be sure to “sell” and transfer to my deposit account just the right amount of shares.
Is there a better way to keep track of the evolution and the real return of investment of my crypto portfolio?
I would like to import my ETH wallet into PP as well
It has many small ETH deposits as a result of mining activity …
I exported the ETH wallet to CSV but I don’t see any way of importing this CSV into the ETH security in PP …
Out of curiosity, can someone past an example CSV for the cryptos and what you would expect to see in terms of transactions (purchase, sale).
And then one more thing: PP tracks cryptos as an instrument not as a currency. Therefore the kind of transactions are limited. The model allows for a purchase or delivery of investment instruments, but the result of a mining activity is rather something like dividend paid in the instrument itself (which is not supported unfortunately)
I was facing the same dilemna a year ago. Here is what I did (it requires a bit of basic Python and Pandas knowledge):
On portfolio performance side I created only one line for crypto as a “virtual” home made security, with an associated crypto deposit account.
At day 0, I deposited 1000€ on the crypto deposit account and immediately invested it as 1000 shares on the crypto home security. So at the end of day 0, I had 0€ on the deposit account and 1000 shares on the crypto home made security valued at 1€ each.
I order to get the daily value of the crypto share, i used a little bit of programming, I did a small python/pandas program that:
retrieves all my crypto assets that I hold in my exchanges’ portfolio (binance, kraken, hot wallet, cold wallet whatever). Basically it gives me a csv file listing all the tokens and their amount that I am currently holding.
values it using coingecko api. This gives an amount in euros of the total value of my crypto assets.
divides the total value of my crypto assets, by the number of shares invested in my crypto security.
that returns the share value in euro on a small and simple web table on a 24H raspberry PI webserver (actually all the calculation runs on a rapsberry pi every 4 H in order to keep a kind of dynamic “real time” tracking, it could only be done only on demand, but at least once a day for tracking purposes)
Portfolio Performance automatically retrieves the share value from the web table. (actually this feature stopped working, see my post on this topic)
Now that I have an access to a dynamic share value of my investment, let say it was valued to 0.9€ at day 30 (-10% in 30 days), If I want to invest 100€ more at day 30, I put 100€ on the deposit account and buy the adequate amount of share of the home security: 100€/0,9 = 111,11. This is to say that at day 30 I will have invested 1100€ in total that represents 1111,11 shares.
I then use the 100€ in my crypto exchange to buy tokens and redo all the calculation with python pandas without forgetting to update the total number of shares in my portfolio (1000 → 1111,11) as an input of my python program.
This system gives you a total flexibility within any crypto exhange, you can trade whatever crypto you want, whenever you want as long as you do not retrieve or add money, which in this case you have to record in portfolio performance.
