|
December 28, 2017, 11:57:47 PM Last edit: December 29, 2017, 12:13:39 AM by Kruddler |
|
What is the most accurate way to calculate the estimated value of your portfolio?
It may seem like a simple question to answer, but it's not. On a simple level, you will want to add up all your holdings and multiply those holdings by the estimated values of your coins in the fiat currency. However, there are many issues involved.
Firstly, where do you get the estimated value from? If you get the estimated value from an international exchange, it's likely to be wrong for your locality because the coin will be more or less expensive in your region. Not only that, you may use two or three different exchanges. each may have their own rate that could vary greatly. Surely, coming up with an estimated value would require you to average some values from several exchanges, wouldn't it?
Secondly, there are a lot of fees involved. If you were to sell up everything right now, you'd end up with slightly less than the average prices because each exchange, or wallet would sting you with a fee. All this varies greatly again depending on the coin and exchange.
Thirdly, there's the international fiat exchange rate to consider. If you get a price from an international exchange, they will convert the price of the coin to their local fiat currency, and then use some arbitrary exchange rate calculator to convert that value to your local currency. This is usually not transparent.
Do you have any techniques handy that you use to calc this stuff? Is anyone privy to techniques used by Blockfolio etc. to make the estimated value more accurate based on used exchanges and locality?
Note: I'm interested to hear about how your techniques inside a spreadsheet, but my end result will be done with code. What I'm really asking about here is nuances. I know that it's possible to put all the variables in a spreadsheet and take some guesses about fee variances etc. What I'm hoping to get out of this question is subtle improvements that could be made to calx that result in a more accurate figure
|