Title: Create an Address and Wallet Watcher for free with Excel+ Blockchair API Post by: bitmover on May 04, 2020, 02:01:48 AM 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 (http://www.homebitcoin.com/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 https://i.ytimg.com/vi/cLWCUgCYl5Y/maxresdefault.jpg 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 https://i.imgur.com/3tAklS6.png 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 Title: Re: Address and Wallet Watcher for free with Excel + Blockchair API Post by: guigui371 on May 04, 2020, 03:44:23 AM Thanks !!
Title: Re: Address and Wallet Watcher for free with Excel + Blockchair API Post by: Coding Enthusiast on May 04, 2020, 04:55:25 AM 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
Title: Re: Address and Wallet Watcher for free with Excel + Blockchair API Post by: bitmover on May 04, 2020, 10:13:08 AM 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. Title: Re: Address and Wallet Watcher for free with Excel + Blockchair API Post by: TheBeardedBaby on May 04, 2020, 02:12:06 PM 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 :) Title: Re: Address and Wallet Watcher for free with Excel + Blockchair API Post by: bitmover on May 04, 2020, 03:10:28 PM 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 |