Calculate the Estimated Value of Your Portfolio

[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

[vibingpositively]

1)I would say you use a spreadsheet to find your total BTC

2)Then use that total BTC to get an estimate of your total USD in your portfolio

3)From there deduct 2-5% for getting from an altcoin to fiat and that should be your takeaway

**note** shouldn't be too hard only thing is your BTC rate may be different but you will never get it 100% correct as this value is constantly changing

[Sinistlercoin]

I use a spreadsheet that auto updates with the current price on the exhange I would use to convert. I also calculate the capital gains tax that would be due if I cashed out.

[Kruddler]

1)I would say you use a spreadsheet to find your total BTC

2)Then use that total BTC to get an estimate of your total USD in your portfolio

3)From there deduct 2-5% for getting from an altcoin to fiat and that should be your takeaway

Yes, but my local currency is AUD. The exchanges here charge quite a bit more than American exchanges. So, I'm left wondering where I should get my figures from. Why 2-5% ? Is this a guesstimate on fees?

**note** shouldn't be too hard only thing is your BTC rate may be different but you will never get it 100% correct as this value is constantly changing

Yes. Correct. I'm just looking for techniques to get the accuracy a bit better.

[1bitcoinsnet]

Binance has nice running value of tons of coins

So low cost I know instantly all my coins there

BTC and BCH you usually store off line

But Binance has great current value tool

Nice to they are on low site usually way under coinbase

So you can dump into LTC or eth move to them and exit

But first u dump on binance to BTC

BTC too costly and slow to exit with

[Kruddler]

Binance has nice running value of tons of coins

So low cost I know instantly all my coins there

BTC and BCH you usually store off line

But Binance has great current value tool

Nice to they are on low site usually way under coinbase

So you can dump into LTC or eth move to them and exit

But first u dump on binance to BTC

BTC too costly and slow to exit with

My question is in regards to how to more accurately calculate the estimated value of a portfolio. What I see here is that Binance has the value of a lot of coins. But, how accurate is it? Why is it more accurate than other exchanges? Aren't Binance's rates distorted by the fact that the prices are mostly geared toward Chinese investors while I live outside China?

[desi92]

I use a spreadsheet that auto updates with the current price on the exhange I would use to convert. I also calculate the capital gains tax that would be due if I cashed out.

How is it working automaticly? Can you share what kind of spreadsheet it is?
Actually this is the first year i did trading so i dont have much experience how.

[U2]

Just collect everything on an excel spreadsheet or get an app. Nothing will ever be 100% accurate but some can come pretty close and you can choose the exchange you'd like to use for your data.

[Headachez]

Mine is around $18, so its not that hard to calculate 

[plr]

1)I would say you use a spreadsheet to find your total BTC

2)Then use that total BTC to get an estimate of your total USD in your portfolio

3)From there deduct 2-5% for getting from an altcoin to fiat and that should be your takeaway

**note** shouldn't be too hard only thing is your BTC rate may be different but you will never get it 100% correct as this value is constantly changing

This I totally agree you cannot precisely estimate the value of your portfolio, you can only speculate or get an estimate to the nearest value of bitcoin because it goes up and down and that's include your altcoin value too, it's better to estimate in the lowest value so you will not get disappointed.

[Kruddler]

Just collect everything on an excel spreadsheet or get an app. Nothing will ever be 100% accurate but some can come pretty close and you can choose the exchange you'd like to use for your data.

Please read the opening post. It's obvious that an estimated value will never be 100% accurate. I'm only asking if anyone has any ideas on how to make the figure more accurate.

Is one exchange better than the next?

Is there a website that averages values from many exchanges?

Just any ideas that might help to gain some degree of accuracy.

[serjent05]

I just looked at my local exchange rate  then calculate the amount arrived on that platform and withdraw them directly to my bank.  I can withdraw that money on the same bank so that I won't pay any fee.  It is not that complicated actually.  We just need to get the amount where we can exchange it to a fiat currency after the deduction of all the fees needed. I don't know why it is that complicated as you are talking OP.

Just collect everything on an excel spreadsheet or get an app. Nothing will ever be 100% accurate but some can come pretty close and you can choose the exchange you'd like to use for your data.

Please read the opening post. It's obvious that an estimated value will never be 100% accurate. I'm only asking if anyone has any ideas on how to make the figure more accurate.

Is one exchange better than the next?

Is there a website that averages values from many exchanges?

Just any ideas that might help to gain some degree of accuracy.

I agree we should deduct all the expenses and charges.