Bitcoin Forum
November 15, 2024, 09:31:30 AM *
News: Latest Bitcoin Core release: 28.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Any way to display my total bitcoin balance over multiple electrum wallets?  (Read 168 times)
edward500 (OP)
Jr. Member
*
Offline Offline

Activity: 41
Merit: 50


View Profile
June 11, 2023, 12:23:20 PM
Merited by DdmrDdmr (4), bitmover (1)
 #1

Just wondering as I have a bunch of wallets but have to go into each wallet to check each balance individually.

I was just wondering if there was a safe way to display my total bitcoin balance easily in one total.

Thanks
tranthidung
Legendary
*
Offline Offline

Activity: 2464
Merit: 4279


Farewell o_e_l_e_o


View Profile WWW
June 11, 2023, 12:30:32 PM
 #2

You can import some public keys into one Electrum wallet, watch-only.

After that, you will total balance of all your wallets but because it is a Watch-only wallet, you only can watch its balance and can not spend your bitcoin.

How?
File > New/ Restore
Create a new wallet
Import Bitcoin addresses or private keys.

With your question, copy and paste all Bitcoin addresses you want to import, each address per line, click Next to finish.

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
OmegaStarScream
Staff
Legendary
*
Offline Offline

Activity: 3668
Merit: 6446



View Profile
June 11, 2023, 12:40:46 PM
 #3

-snip-

From my understanding, he has multiple wallets, not addresses so although this solution works, it's probably not the fastest nor the most convenient way.

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
hosseinimr93
Legendary
*
Offline Offline

Activity: 2590
Merit: 5678



View Profile
June 11, 2023, 12:42:56 PM
 #4

You can import some public keys into one Electrum wallet, watch-only.
For creating a watch-only wallet in electrum, you must import your address(es) or your master public key. There is no way to import a public key into electrum.
OP must import his/her addresses to create a watch-only wallet.

After that, you will total balance of all your wallets but because it is a Watch-only wallet, you only can watch its balance and can not spend your bitcoin.
If you want the fund to be spendable, you can import your private keys instead of your addresses.

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Maus0728
Legendary
*
Offline Offline

Activity: 2044
Merit: 1582


View Profile
June 11, 2023, 01:23:35 PM
Merited by bitmover (2)
 #5

In my mind, you are either going to use cointracking apps such as coingecko and blockfolio OR manually input your bitcoin addresses on a web application to see the balance of multiple bitcoin addresses at the same time[1].

[1] https://bitcoindata.science/bitcoin-balance-check.html. (Credits to @bitmover)
o_e_l_e_o
In memoriam
Legendary
*
Offline Offline

Activity: 2268
Merit: 18747


View Profile
June 11, 2023, 04:58:12 PM
Merited by un_rank (2)
 #6

Given that you cannot import multiple master public keys in to the same wallet in Electrum, then your only way of doing this will be to import all the addresses individually from each wallet in to a single watch only wallet.

Rather than copying and pasting each address one by one, in each wallet you want to watch go to the console (if you don't see the console tab then click View -> Show Console) and enter the following command:

Code:
listaddresses()

It will spit out a list of all your receiving and change addresses visible on the addresses tab, so you can copy the whole list at once. You'll still need to manually remove the " and , symbols before attempting to import them, though.
mk4
Legendary
*
Offline Offline

Activity: 2926
Merit: 3881


📟 t3rminal.xyz


View Profile WWW
June 11, 2023, 05:37:17 PM
 #7

Something different but not sure if you'd want it: use Google sheets. Not sure what API to use but I'm sure there's a free one out there that you can use. Basically scrape your address balances, then just use =SUM( to get the total amount of BTC you have.

» t3rminal.xyz «
Telegram Alert Bots for Traders
Stalker22
Legendary
*
Offline Offline

Activity: 1694
Merit: 1415



View Profile
June 11, 2023, 08:11:57 PM
 #8

I was just wondering if there was a safe way to display my total bitcoin balance easily in one total.

Some methods have already been mentioned by others, for example, importing multiple addresses into one Electrum wallet, in watch-only mode.

Another option is to use crypto portfolio tracking apps, such as Delta App, CoinStats, CoinTracking, Blockfolio, Coinigy, etc. These apps allow you to manage and track your cryptocurrency holdings across various wallets and exchanges. You can import your wallet addresses, master public keys or connect directly to supported exchanges to automatically sync your transactions and balances. They provide real-time price updates, portfolio performance analysis, and even customizable alerts to keep you informed about market movements.

Be careful, though, as there have been reports suggesting that some apps might collect and share user data with blockchain analytics companies. I would not use these apps if anonymity is of utmost importance to me.

█████████████████████████
██
█████▀▀███████▀▀███████
█████▀░░▄███████▄░░▀█████
██▀░░██████▀░▀████░░▀██
██▀░░▀▀▀████████████░░▀██
██░░█▄████▀▀███▀█████░░██
██░░███▄▄███████▀▀███░░██
██░░█████████████████░░██
██▄░░████▄▄██████▄▄█░░▄██
██▄░░██████▄░░████░░▄██
█████▄░░▀███▌░░▐▀░░▄█████
███████▄▄███████▄▄███████
█████████████████████████
.
.ROOBET 2.0..██████.IIIIIFASTER & SLEEKER.██████.
|

█▄█
▀█▀
████▄▄██████▄▄████
█▄███▀█░░█████░░█▀███▄█
▀█▄▄░▐█████████▌▄▄█▀
██▄▄█████████▄▄████▌
██████▄▄████████
█▀▀████████████████
██████
█████████████
██
█▀▀██████████████
▀▀▀███████████▀▀▀▀
|.
    PLAY NOW    
RickDeckard
Legendary
*
Offline Offline

Activity: 1148
Merit: 3119



View Profile
June 11, 2023, 10:56:04 PM
 #9

Code:
listaddresses()

It will spit out a list of all your receiving and change addresses visible on the addresses tab, so you can copy the whole list at once. You'll still need to manually remove the " and , symbols before attempting to import them, though.
Would it make sense to use listunspent[1] afterwards? This would allow the OP to get the current balance of each address, albeit it wouldn't provide him with a total sum. Is there any command that he could use in CLI to sum each value from the provided addresses and spit the result at the end? JQ[1] seems very promising to do this kind of filtering but I'm not sure what the command line could be:
Quote
Use JSON for Simple Calculation by Value

Usage Example: Automatically calculate the value of the UTXOs used in a transaction.


You can now go one step further, and request the .amount (or any other JSON key-value) from the UTXOs you're retrieving.

This example repeats the usage the $usedtxid and $usedvout arrays that were set as follows:

$ usedtxid=($(bitcoin-cli decoderawtransaction $rawtxhex | jq -r '.vin | .[] | .txid'))
$ usedvout=($(bitcoin-cli decoderawtransaction $rawtxhex | jq -r '.vin | .[] | .vout'))

The same for script can be used to step through those arrays, but with an added pipe in the JQ that outputs the amount value for each of the UTXOs selected.

$ for ((i=0; i<${#usedtxid
  • }; i++)); do txid=${usedtxid}; vout=${usedvout}; bitcoin-cli listunspent | jq -r '.[] | select (.txid | contains("'${txid}'")) | select(.vout | contains('$vout')) | .amount'; done;
0.9
0.4

At this point, you can also sum up the .amounts with an awk script, to really see how much money is in the UTXOs that the transaction is spending:

$ for ((i=0; i<${#usedtxid
  • }; i++)); do txid=${usedtxid}; vout=${usedvout}; bitcoin-cli listunspent | jq -r '.[] | select (.txid | contains("'${txid}'")) | select(.vout | contains('$vout')) | .amount'; done | awk '{s+=$1} END {print s}'
1.3

Whew!
OP: In order to achieve a better degree of privacy, I would recommend you to run your own node and then you could retrieve this information without relying on any external entity by using Bitcoin Core CLI.

[1]https://thunderbiscuit.github.io/Learning-Bitcoin-from-the-Command-Line/04_2__Interlude_Using_JQ.html

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
o_e_l_e_o
In memoriam
Legendary
*
Offline Offline

Activity: 2268
Merit: 18747


View Profile
June 12, 2023, 05:11:43 AM
Merited by Stalker22 (1), RickDeckard (1)
 #10

Another option is to use crypto portfolio tracking apps, such as Delta App, CoinStats, CoinTracking, Blockfolio, Coinigy, etc.
The problem with this suggestion is the same as the problem with the other suggestions made above such as a blockchain explorer or Google sheets, as you rightly point out - privacy. As the old saying goes, if you are getting something for free, then you are the product. These services are almost certainly harvesting your data and sharing and selling that with third parties. Setting up an Electrum watch only wallet synced via your own node avoids all this.

If you do want to use a crypto portfolio app, then I would suggest manually entering aggregated balances rather than linking it with your wallet or specific transactions, so it cannot track your specific coins.

Would it make sense to use listunspent[1] afterwards? This would allow the OP to get the current balance of each address, albeit it wouldn't provide him with a total sum. Is there any command that he could use in CLI to sum each value from the provided addresses and spit the result at the end?
He can use the command listaddresses(balance=True) to get a list of all addresses alongside their individual balance, or the command getbalance() to get a total wallet balance.

The reason I suggested just doing listaddresses() on its own is because even if he imports a bunch of empty addresses, it means his watch only wallet will automatically stay synced with all this other wallets as he uses more addresses (until he exceeds the gap limit on a wallet, in which case he will need to import the next set of addresses).

OP: In order to achieve a better degree of privacy, I would recommend you to run your own node and then you could retrieve this information without relying on any external entity by using Bitcoin Core CLI.
I obviously agree as discussed above, but actually if OP is going to be running his own node anyway, then he could avoid the Electrum watch only wallet and simply use Core, importing the master public key from each of his Electrum wallets in to a single Bitcoin Core descriptor wallet.
348Judah
Hero Member
*****
Offline Offline

Activity: 910
Merit: 542



View Profile
June 12, 2023, 12:36:46 PM
 #11

Just wondering as I have a bunch of wallets but have to go into each wallet to check each balance individually.

I was just wondering if there was a safe way to display my total bitcoin balance easily in one total.

Thanks

As some have already advised, try get an electrum wallet and you can import those wallets on the electrum but you have to be sure that those other wallets you're intending to import where decentralized wallets with their respective keys, seed phrase and private keys, which means you cannot import a centralized wallet on this because they are having your keys in their custody, then after you might have imported them, ensure you name each wallet accordingly as you're importing them to avoid mixing up one wallet from the other.


░▄██████████████▀█▀▀████████▄░
███████████░░▀██▄░▀▄░█████████
███████████▄▄▄░▀▀▄░░█░████████
██████████▀▀░░░▄▄░░░▀░░███████
████████▀░░░░▀▀█▀░░░░░████████
███▀████▀░░░░░░░░░░░░████▀▀██
███▄████▀▀▀████░░░░░░░████▄▄██
█▀▀▀▀▀▀▀▀▀▀█████░░░░░░██▀▀▀▀▀█
█▄▄▄███████▀█░░░░░░░░▀███▄▄▄█
█████▄▄▄▄███▄▄▄▄▄▄▄▄▄█████████
█████▀▀▀███████████████▀▀██▄██
░▀████████████████▄▄▄▄██████▀░
First Ever⠀⠀⠀───── Powered by: BSC Network
Leverage Driven CLMM + DLMM Model
───▸Dynamic Fee Structure   ───▸Revenue Sharing⠀
.
.       █
.  █   ███
. ███  ███   █
. ███▄▀███▄ ███
▀▀███  ███ ▀███ ▄
. ███  ▀█▀  ███▀█▀
. ███   ▀   ███
.  █        ▀█▀
.            ▀
Trade
.
. ▄▄▄▄▄▄▄    ▄▄▌‎▐▄▄
▄█▀  ▄  ▀█ ███▀▄▄▀███
█    █    ████ ▀█▄████
█    ▀▀▀▀ ████▀█▄ ████
▀█▄      ▄ ███▄▀▀▄███▀
. ▀▀█▄▄█▀   ▀▀█▌‎▐█▀▀
.▄▄▄▄▄
.████████▀▄ ▄▄▄██▀
.   ▀▀▀██████▀▀
Lend
.
.        ▄█
.     ▄███▄▄▄
.   ▀██████████
.     ▀███▀▀▀███
▄    ▄▄  ▀    ▀█
███▄▄███▄
▀█████████▄
. ▀▀▀████▀
.    █▀
Swap
.
.     ██▄▄
.   ██████
.    ████
.  ▄██▄▄▄██▄
.▄████▀ ▀█████
▄█████ ▀███████
██████▀▀ ██████
███████▄███████
.▀▀█████████▀▀
Earn
.
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
WHITELIST ME

⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
ImThour
Copper Member
Legendary
*
Offline Offline

Activity: 1498
Merit: 1619


Bitcoin Bottom was at $15.4k


View Profile
June 12, 2023, 01:11:47 PM
 #12

Why not put all your investment information (Amount of BTC and price at which you bought it) into a google sheet or even a simpler way, use Coinmarketcap's Portfolio option?
It will keep track of your investment value without you having to turn on your PC again and again.

Just download it on your phone and be ready to open your portfolio page almost 100 times a day, good luck.
o_e_l_e_o
In memoriam
Legendary
*
Offline Offline

Activity: 2268
Merit: 18747


View Profile
June 12, 2023, 03:29:59 PM
Merited by RickDeckard (1)
 #13

Why not put all your investment information (Amount of BTC and price at which you bought it) into a google sheet or even a simpler way, use Coinmarketcap's Portfolio option?
Because by using such methods you can absolutely guarantee that a bunch of third parties will also know all the addresses you own and track all the transactions you make.
nc50lc
Legendary
*
Offline Offline

Activity: 2604
Merit: 6407


Self-proclaimed Genius


View Profile
June 12, 2023, 03:46:11 PM
 #14

I was just wondering if there was a safe way to display my total bitcoin balance easily in one total.
If you have a fully synced Bitcoin Core with complete blockchain (not pruned),
you can create a watching-only descriptor wallet and import all of your master public keys with importdescriptors command.
You can still do that with a pruned blockchain though but you'll have to resync from scratch when you need to rescan the blockchain for balance.

Here's the guide on how to do it: https://bitcointalk.org/index.php?topic=5399337.msg60178631#msg60178631

If you're limited to Electrum, then it's not possible since it can't accept multiple master public/private keys/seed.

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
bitmover
Legendary
*
Offline Offline

Activity: 2492
Merit: 6320


bitcoindata.science


View Profile WWW
June 12, 2023, 07:01:50 PM
 #15

Just wondering as I have a bunch of wallets but have to go into each wallet to check each balance individually.

I was just wondering if there was a safe way to display my total bitcoin balance easily in one total.

Thanks
In my mind, you are either going to use cointracking apps such as coingecko and blockfolio OR manually input your bitcoin addresses on a web application to see the balance of multiple bitcoin addresses at the same time[1].

[1] https://bitcoindata.science/bitcoin-balance-check.html. (Credits to @bitmover)

Thank you for mentioning this tool.

I created it because I was in the same situation as the OP.

I had a bunch of different addresses from different wallets and I need to track the overall value from time to time. It was hard to do so manually, so I created this tool.

It has been proven useful for many people, as most of this domain visits are to that tool. I am open to suggestions if you need something diffferent

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!