Create an Address and Wallet Watcher for free with Excel+ Blockchair API

[bitmover]

For a long time I have been searching for a solution for a simple problem that I have:

Too many addresses to monitor in different wallets. Additionally, I have receive bitcoins more than once a week, just like many here do.

I was for a long time using easybalance , which is a great website, but it doesn't support native segwit addresses.

So I decided not to be lazy and create an address monitor on my own using blockchair api data. It was pretty easy.

I will show you how:

1 - Download Excel Power Query https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=c9c9ec0d-5336-4ba8-a6a7-7b229fb861ac

2 - Click Add Data From Web


3 - On the URL enter:

https://api.blockchair.com/bitcoin/dashboards/addresses/{:address}
{:address} = (for a set of up to 100 addresses, comma-separated, further referred to as the addresses dashboard)
(source=https://blockchair.com/api/docs)

4- Once API data shows up, click in Data > Record.
Then click Set > Record

5 - Then click convert Into Table


Now you just go to Balance tab (which is zero in this picture, but you should do with a set of addresses with balance). Then you should create a formula like =B5/100000000 to show balance properly (otherwise it will show in satoshis, not in Bitcoins.

Hope you it helps somebody

[guigui371]

Thanks !!

[Coding Enthusiast]

I created a desktop app a couple of years ago to do this, it has been supporting bech32 addresses as soon as I found a block explorer API that supported it (Jan 2018): https://bitcointalk.org/index.php?topic=1616888.0

[bitmover]

I created a desktop app a couple of years ago to do this, it has been supporting bech32 addresses as soon as I found a block explorer API that supported it (Jan 2018): https://bitcointalk.org/index.php?topic=1616888.0

Nice! I was searching for this.

I think we lack a good online page that does that. Easy balance was nice, but it doesn't support segwit. I will try to do one web page that does that.

[TheBeardedBaby]

Damn, just hold on until I'm a merit source (hopefully this month)
Nice one  in additon to the great tool, you are giving me a very good idea how to orgineze some other things with this Power Query which I had them soo messted up. Thank you again

[bitmover]

Nice one  in additon to the great tool, you are giving me a very good idea how to orgineze some other things with this Power Query which I had them soo messted up. Thank you again

Thanks.
Power Query is a great tool. I use it a lot to update values of my personal finances sheet every month

It is so easy to use. We just need to find good free API