I'm guessing you only want to track your Bitcoin holdings? If so, you can use Bluewallet (available on mobile). Just import your master public key, and it'll automatically show your holdings whenever you receive funds (in any address in that wallet).
Some more advanced options that support both altcoins and exchanges is: Delta tracker.
Yes, I would like to track my holdings. At the same time, it would be good if it could tell me how much loss or profit I made. I'm happy to add it manually in order to avoid adding my public key. I'm running a node, but still unsure how much of privacy I would loose when adding my public key to Bluewallet.
I'm not in any way a fan of having to connect all these third-party apps to your wallets and possibly have a security breach now or later. you can do this by yourself by configuring as little as an excel sheet on your local computer and track your investment by recording the amount you bought any of your holdings, and the quantity. After configuring the sheets with the formulars I would show you below, then you only need get the recent price of the crypto currency to update your investment status, good thing is that you may necessarily not need to get the recent price by yourself since there are free Apis that can be connected to the sheet to update the prices for you as soon as the sheet is opened.
for example
https://api.diadata.org/v1/assetQuotation/Bitcoin/0x0000000000000000000000000000000000000000Simply create an excel sheet that would look like this
| S/N | Quantity | Cost Price($) | Price at Purchase($) | Current Price($) | Profit($) | Loss($) | Net Profit($) |
| 1 | 0.01 | 605 | 60500 | 67500 | 75.2 | 0 | 50.2 |
| 2 | 0.01 | 695 | 69500 | 67500 | 0 | 20 |
Now to get the profits, you Use a conditional operator(eg the if statement) to check whether the CURRENT PRICE is greater than the PRICE AT PURCHASE. If its lower, return a zero to the field, then if yes, calculate with the formular below:
firstly we would get the % increase in price from 60500 to 67500, which is 7000/60500 * 100 = 11.57%
Then we proceed to get this same increase in relation to the cost price which is 11.57/100 * 650 = $75.2, now your profits for this transaction is $75.2
For the second record we had a loss, so we calculate the % decline in price from 69500 to 67500 = 2000/69500 * 100 = 2.88%
Again you proceed to get the same decline in relation to the cost price = 2.88/100 * 69500 = $20, now your loss for this transaction is $20
For the net profit, you can sum you can remove the total losses from the profits and use a green color to display the result if profits are more than losses and a red color for the latter.
Then you can enhance your customization to knowing the worth of your investment currently by getting the total of the cost price and adding the net profits to it or removing from it where necessary.
Good thing is that all these calculations need only be done once for the first row, and you would drag down the formulars to other similar rows to update the calculations.
you can also upgrade to doing it online by uploading the sheet to your drive and access it from anywhere or creating your simple site where you can implement same algorithm.
