Author

Topic: Create an Address and Wallet Watcher for free with Excel+ Blockchair API (Read 277 times)

legendary
Activity: 2352
Merit: 6089
bitcoindata.science
Nice one  Roll Eyes 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 Smiley


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

It is so easy to use. We just need to find good free API
legendary
Activity: 2240
Merit: 3150
₿uy / $ell ..oeleo ;(
Damn, just hold on until I'm a merit source (hopefully this month) Smiley
Nice one  Roll Eyes 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 Smiley
legendary
Activity: 2352
Merit: 6089
bitcoindata.science
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://bitcointalksearch.org/topic/c-watch-only-bitcoin-wallet-support-segwit-and-forks-v31-1616888
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.
legendary
Activity: 1042
Merit: 2805
Bitcoin and C♯ 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://bitcointalksearch.org/topic/c-watch-only-bitcoin-wallet-support-segwit-and-forks-v31-1616888
legendary
Activity: 2114
Merit: 1693
C.D.P.E.M
legendary
Activity: 2352
Merit: 6089
bitcoindata.science
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
Jump to: