Bitcoin Forum

Ok, after a week and a half of searching it is CLEAR that there is no easy solution to this problem.

The goal or problem is checking the balance of a ton of addresses without having to import them with keys without having to run a linux machine, without having to run anything in python, just plain and simple copy a list of addresses......

1EMXdJrLUhyh5ycijPzmJKWGStQ915VGSJ
1EmXdS1QPA7wmJqH7WtfwaV6rM88LC9t6F
etc....
etc....
etc.....



Then paste them into an input window, click submit or what have you, and have their balances checked say a 100,000 addresses at a time, or a million at a time, or whatever large number.

I have seen this question asked over a few hundred times in my week and a half search and have found 0 answers to it. 0 real answers that a non software developer, non linux running, non python familiar person can take advantage of.


So i ask again, on behalf of myself and the hundreds of other people out there that have been asking the same thing and all ended up with over technical non useful results.

Is there any way to check the balance of a ton of addresses by simply copying and pasting them into an input field.

Things we dont need:

Links to your software that will not run easily on widows or mac without having to install a ton of other stuff
Your explanation on how someone could code this software, Myself, and the others who have asked are obviously not developers
simple one line replies referencing someone else's block parser or other non windows/mac programs with no "how to use this for dummies" help.

you get the point, do a quick google search and you can see for yourself how this has been a discussion hundreds of times with no resolution.

Side note: if you are a able bodied developer, and the solution is as easy as (this) as has been answered many times before, maybe you can spend the few hours people say it would take to make such a software for the community to use.

I'm not aware of any service or easily installed and used software that will accomplish what you want.

I suspect you will get a lot of advice that you have already said you don't want from a lot of people who won't bother reading your entire post.  In the future, if you try asking the question again, I suggest you start a "self-moderated" thread.  That way you can delete all the undesired advice.

Thanks danny, i appreciate your feedback (no easily installed and used software ), as for the self moderated thread, the whole point of defining non-viable solutions or un-needed advice is to avoid having to moderate a thread.

Anyways, i guess there is always Fiverr.com, i have managed to get a ton of development done through them for next to nothing with BitcoinJ so if over the next day or two nobody else has a viable solution, i will hire some guy from India or Pakistan for $5 to copy/paste a few lines from BitcoinJ to make what i need since i have no clue what any of the stuff in the BitcoinJ zip file is and they seem to read it like a kid reads cat in the hat.

Unfortunately, part of the problem is that at the protocol level, there is no such thing as an "address" or a "balance".  There are only "outputs" and scripts that set up requirements that must be met in order to reassign the value from those outputs.  The concept of a "balance" or even a "bitcoin" for that matter are just abstractions that we humans use to make it easier to talk about transferring control of value.

Therefore, the only way to find the "balance" of a very long list of "addresses" is to have a database of all currently unspent outputs, and then check every address against the scriptPubKey of each unspent output. Any software to do this would need to stay synchronized with the blockchain, and therefore would need to be kept running or the user would have to wait for synchronization every time they start it up.  Any service to do this would need to be able to handle the HUGE number of requests to search the entire database for every address for every potential user of the service.

I fully agree with everything you said, although my coding abilities stop at basic PHP and MySql, my hardware abilities and budget have landed me with a BackBlaze 4.0 storage pod (http://www.45drives.com/products/) which after a few days worth of cussing and swearing i got assembled and on my network, as well as a home brew semi-supercomputer with 128 gig ECC ram and 10 quad core intel processors with haswell architecture.

I have tried my hand at resolving this myself using the Insight software and API (http://insight.is/), and tried my hand at chopping (cutting and pasting) java code to work my own solution. but was left with "i should just stick to making websites" as i know jack squat about java, C, or for that matter anything not HTML or PHP related.

I am really beginning to think i am going to have to take advantage of some poor developer from some far off country through fiverr to do the coding for pennies of what it is worth. In the end it will be a solution though which is better than whats out there now.

Edit: I get PMs from time to time asking for help with the below software. The API in question is no longer operational, thus you will need to use the curl version -> https://bitcointalk.org/index.php?topic=736607.msg9982506#msg9982506

---
I read this thread a day or two ago and though, well this should be easily done in ruby... and then I read it completly.

I spend a few hours and made a tiny java programm [1] that does what I think you want.

You simple have to paste all the addresses in a file named in.txt (seperated by line breaks, see the in.txt that I put there for testing), run it with

and watch it work. When done it will make you a file named out.txt (be carefull any existing file in the same directory with that name will be overwritten).

Which looks like this:


I used the blockchain.info API [2] to get the balance, so it will need internet access. The connection will not be encrypted.
It is quick and dirty and will not catch any exceptions, if anything goes wrong (e.g. no internet, file not found) it will just terminate.
Please do not blindly trust me and read the code! Even with limited copy pasta knowledge of java you should be able to understand what it does.


I know these are a lot but, but [3] I hope it will help you.


[1] includes source, readme and example files https://mega.co.nz/#!ckQ1gSSY!gsqAlZojlt-ACxZB7179g95zgWrhKAxwMMalPG_7Jlo
[2] https://blockchain.info/q
[3] aaand another one ;)

What community is this useful for? Other people I've seen asking for this are trying to crack brainwallets (ineptly).

How the #$*@ did you end up a moderator?

1: having a list of addresses and being able to check them all at once has absolutely NOTHING to do with brain wallets Without the priv key you can do nothing with an address.

2: having the ability to monitor a ton of addresses without having to have any keys neither public or private has many uses, if i had more patience with people who are quick to make statements or accusations without first pulling their head out of their @$$ and reading the full OP i might even list them for you.

3: i dont know how in your twisted little head you came to the conclusion that checking balances without keys is for brainwallet cracking. If that were the case, blockchain.info and any other similar service are out to destroy BTC because they all allow it one address at a time, worse they let us explore the blockchain. If there were any logic behind your statement we all better sell all of our BTC as fast as we can as anyone can generate an address in 2 seconds and want to check the balance of it or even a million of them.


As for you...

I friggen love you man. ( in a non-homo kind of way)

Thats an awful lot of very defensive text without any explanation at all. I've encountered inept brainwallet crackers multiple times who had the laughable strategy of attempting a key and querying bc.i for its balance, until they rapidly find themselves banned, then they show up on the forum or chat asking a question a lot like yours— a way to query a lot of addresses.  Especially when they're asking about querying at a scale compariable to or larger than the number of addresses with spendable coins in existence in total.

In any case— I didn't say _you_ were attempting to do this,  I asked what you were doing and pointed out what my past experience is with the question (so that you might be aware of the kind of speculation your question might inspire).

Generally if you're seeking help it's advisable to describe what you're actually trying to accomplish so that people with experience can point you to the best solution— often when you've found yourself in an unsolvable rut it's because you took a wrong turn a few steps back, and are now headed down a blind ally—  and only asking complete questions can save you.

Ah, so since you weren't helpful in your response I thought I'd research some...

Looking at your past posts I see you were previously asking:


Then you complained about Bitcoin QT misbehaving with many addresses loaded (which means you have >100k loaded in it),  and here you're talking about millions.

I guess too would have a hard time explaining how being a "faucet and referral program whore" results in needing to scan 100k-1m+ addresses, and what use audible alerts were in relation to old inactive addresses of yours…

Incidentally, the private key of the first address in your list is

5HpHagT65TZzG1PH3CSu63k8DbpvD8s5ip4nEB3kEtHwQJ6fmT7

and the second

5HpHagT65TZzG1PH3CSu63k8DbpvD8s5ip4nEB3kEsz591qCUVs

And anyone who thinks a bit about how I know that will probably share my conclusion that you're a fool and a wanna-be thief.  Buzz off.

I'd educate you on precisely why your moronic approach isn't going to net you any coins, but it's probably better for the world if you continue to remain in the dark until your moral character catches up with your typing ability.

Nice sleuthing Greg.  Perhaps he hopes to try all the private keys starting from zero lol.  

https://i.imgur.com/4QOEFrp.png

Oh yes, that must be it, i must be lacking in 5th grade math enough to not understand that the probability of finding 1 in 115792089237316195423570985008687907852837564279074904382605163141518161494337 is astronomically impossible.

Or

i must have missed the trillion threads that point out the obvious that generating 115792089237316195423570985008687907852837564279074904382605163141518161494337 64 charecter hex strings one at a time even with the most powerful computer on the planet would take about 5 million lifetimes

Or

i missed the million threads that again state the obvious that even if i could generate 115792089237316195423570985008687907852837564279074904382605163141518161494337 private keys, there are not enough Hard Drives on the planet to store the 115792089237316195423570985008687907852837564279074904382605163141518161494337 X 32 bites of data.

Or

Maybe i missed that someone published a few hundred trillion private keys on a website (directory.io) and that of ALL of them it did not amount to 1% of all possible keys, and not a single key he published contained a balance or for that matter, will ever in our lifetimes. But myself, with my little 4.2g 8 core processor on a 6 month old desktop thought i could do better. ??????????


Or...
Or.......
Or.........

Now your all $@#ing idiots and cannot wrap your heads around maybe someone has a few million addresses they want to monitor for a pet project. and coincidentally they are smart enough to know that "cracking bitcoin" is IMPOSSIBLE as stated about a billion times since October of 2013.


Me, i'm in for the last one, your all idiots who read waaaaaaaay to much into crap as you are part of a community which was founded on and surrounded by thief's, scam artists, conn's and other nefarious types and it has since become your single train of thought in life that everyone who wants anything to do with bitcoin is up to something bad (except yourselves of course, your the only one who has good intentions ). You should do yourself a favor and sell all your bitcoin and run away as fast as you can before it melts what little bit of a brain you have left. 

Summary, your effin insane and bitcoin has melted your mind, and furthermore, someone with your mentality, the mentality of not being able to ask "hey, what do you need to check the balances of a few million addresses for?" before you automatically not only assume, but accuse a person of being a wanna be theif, is the perfect display of why there is no way in hell you should be a moderator.

quoted for reference, by the way thanks for the trust rating about something you know jack shit about based on your wild assumptions. what a troll. 

Actually that website 'publishes' all of them.

And for all those words, you still can't seem to explain what you're doing... Or why I knew the private keys for the addresses in your example. The tantrum is not making you any more convincing.

[Edit: Incidentally, there is no point in crapping up the thread with "quoted for reference" posts, I can delete or edit every post here.]
[Though, of course, I have no reason to do so, I'm completely comfortable with what I've written, much more so than you seem to be with your own position, which you continue to leave with the not-all-that-mystifying lack of justification— I'm just pointing out the quoting is a waste of space.]

a) There is not a big problem to parse the whole blockchain, get ALL addresses ( both p2pkh and p2sh ) used from the beginning of bitcoin epoch with their balances. There are ~40-45 mln addresses right now, so the database will be 1-2gb - suitable for any modern computer

b) There is not a big problem to connect to bitcoin network, parse blocks and transactions and keep this database up-to-day (up-to-block to be correct)


pseudo-code:

There is a problem that such tool is absolutely useless and can be made only for fun.
No one will spend significant time to create and run this.
But... You may ask somebody to write such program for you. I think that 20...50 BTC is reasonable price.

May be he just found d.io site?

Sure, then in a totally unrelated sequence events sought a client that could import keys and beep when it received a transaction, claiming to have thousands of faucet keys from long ago he needed monitoring.

Then, again unrelated, his bitcoin-qt was falling over because it had so many keys loaded (which in my experience doesn't even happen at 100k keys).

Then totally unrelated his next question was software to check the balances of millions of addresses (when only a couple million in total have balances, but like totally they're all his), and his examples by complete and total coincidence happened to be keys one might have copied from d.io.

Then I asked what he was actually trying to achieve, because I'm totally evil and not because I noticed his repeated failure to make yak shaving progress, and also in passing ask if he was trying to crack keys— again because I'm an abusive moderator and not because I've seen people on many occasion ask a similar sequence of questions when they were and don't care to spend my time helping people rip people off in the Bitcoin community, and totally not because I'd noticed that his posts were inconsistent.

Then when he flipped out, wisely offending me— because I am totally not someone who could just hand him his answer directly or quickly cross compile some tool for his OS—, while also managing to provide zero information to explain what he was doing, both making himself look suspicious and failing to provide the required information so that other people could help him achieve his goals... and the fact that I was able to guess the private keys for his example pubkeys (which he ranted that he couldn't possibly be trying to crack because he'd have to know the private keys for them— it's really just my own idiocy why I can't understand how an import function that requires you to have the private keys doesn't imply that he has the private keys), this was all coincidence and in no way suggested his (still unspecified) goals were actually evil.

In reality there is some totally harmless and legitimate reason that he needs a programming free solution to monitor more addresses than are currently being used for funds in the whole network, beep when they receive them, while working with insanely low value near sequential private keys, while asking questions that mislead about his ultimate goals (and getting answers that are poor fits: Bitcoin-qt is an acceptable way to monitor thousands of addresses, not millions), and he can't disclose this reason because my puny mind is totally too small to contain an understanding. So the fact that I might suspect some foul play here is entirely my own fault and I deserve a heap of abuse for it.

Yea, you're right. That must totally be what happened here. :P

We have to thank S.N. for the bitcoin technology, which allows us to have a consensus even with evils (if the number of them wouldn't >=51%).
OK, does he really want to empty the Pacific Ocean with a pipette? I can sell him a couple.

 ::)


Uhm yeah....

Here is the PM I got, I will answer this in public.


Not sure what the problem is, its just a very simple jar file.


No it wont. It might accept 1 million lines, not sure about that, I never had to work with Java on that scale. I actually never had to work with anything on that scale. Anyway the bc.i API will certainly ban you. I dont see any personal use in checking a million addresses. Care to tell me why do you need to check so many? This code is definitly not company ready and I was under the impression that you are a person that wants to check the balance of your own address without the need of a wallet. E.g. to watch the balance of your paperwallets or something like that. Thats basically the extent what you can do with it. Put in a couple of addresses, run it and be happy that your paperwallets are still loaded. I probably understood the "a ton of" wrong in your first post.

Edit: I probably should have read the OP more carefully...  >:(


Yes, this would be an option. This would however require you to follow DannyHamiltons advice and build a database, so my few lines of Java code will not help you there. If you allready have a local database that can just return a "getbalance" request you dont need an external tool that makes these requests.


No, I actually get a bad feeling every time someone asks me whether I have skype. Call it personal experience.


After I read this thread Id rather not help you. 1 Million keys is -as was argued allready by others above- not personal use. I have no idea what you are trying to do here and I honestly do not want to know.

The way you reacted [1] on gmaxwell's question make me not want to work with you, not even in the very unlikely case that you are indeed looking for an employee and need this for your very good running bussiness that legitematly has 1 million addresses (e.g. 1 for each customer) to track.

Enjoy the rest of your life. (http://www.reactiongifs.com/r/padnw.gif)




[1] see my 1st quote as well as this thread https://bitcointalk.org/index.php?topic=739699.0

The only way to do this, is by indexing the blockchain into some database. Note, this will consume a lot of space.

Why are you so angry?  ;D
It has bad manners, but the main problem not in it
He does not know math  :-\

I am not angry, just a little sad.

too bad there isn't a search function on the directory.io database, would be nice to check any addresses against it, if they really did get 1 percent of all addresses, it will be just a matter of time until someone put a shit ton of coins in one of them. but then, maybe its a good idea not to have a search function, lol...

Do you want me to make this for you? Sounds pretty easy using blockchain.info's API. If someone could offer me free hosting I'd be able to work on this tonight.

They don't have 1% of the addresses, they have ALL the addresses.  It is impossible to put a search function on it, they generate the addresses on the fly with a program, they don't actually store them all in a database.  Therefore, there is nothing to search.

Nevermind, just noticed the java version of this someone made. I'm uselesssss

OK, not a problem. Look at http://chbs.esy.es
It has search function, but a database is slightly smaller than d.io  ;D

just randomly picked one and it had 15 cents worth of btc in it... i left it alone... but wow, this could be dangerous with someone with a lot of time on their hands, lol...on the directory.io site..

Hi, I've just checked this nice tool. But it does not work. Can you help me?

Maybe. Whats wrong?

Looks like bc.i does not return any data for some reason. Not sure why. They limit the number of requests for 1 every 10 seconds, but this should not block the 1st response. I honestly dont want to bother with bc.i further.

You could use blocktrail [1] instead, but they require an API key and limit to 2 requests per second (burst) so youd have to include wait states.

[1] https://www.blocktrail.com/api/docs/jquery#api_address

Thanks bro..can you help me with this blocktrail. Can you post a simple example of 2 btc adresses.

Not as a finished tool, no. I dont have an API key and youd need your own anyway. They have examples with the docs for several languages and even provide libraries for python, PHP and NodeJS.

----

Edit:

This is exactly what I need!  We need more people like you. Thanks for your time! I will finish it.

not to support this guys ideas but i think that if we take his intentions out of the equation, it's a good question and may come in handy for other people if it gets an answer.

I actually bumped into a pull request on the 0.9 branch https://github.com/bitcoin/bitcoin/pull/3652/files (https://github.com/bitcoin/bitcoin/pull/3652/files) which goes a long way into giving slightly more advanced users a function they've been asking for.

Try  https://www.blockonomics.co ,  you can easily check balance , tag/label your addresses and also get email notifications on transactions.
Its dead simple to use

I too have been looking for this exact same solution, ive downloaded this .jar programme it seems to do something but leaves an ampty out.txt file - any ideas? Ive got internet connection and it does the same thing with the test in.txt file so its not the formatting of the in.txt file.

Bc.i changed their API you can either use the source and change it to your needs or use the curl version I wrote a bit later[1] thats working with the blocktrail.com API.

[1] https://bitcointalk.org/index.php?topic=736607.msg9982506#msg9982506

Sorry to be really dim but im not sure how I implement the script on windows? I tried putting this in a .bat file but didn't work. Im also unsure which file in the source code I need to amend or how to build/compile it when I have. I'm guessing its the main.java in the src folder? Do I literally have to change the blockchain.info address to an another address?

Happy to send you a donation if you can get this working for me.

Not sure how to get it to work on windows. You need curl[1] and something similar to grep. You will also need an API key for blocktrail[2]. I remember I got a PM from someone saying they got the curl version running on windows, Ill see if I still have the PM and ask whether they can post their solution here. Nope, sorry no mention of Win.


I made it with eclipse 4.4[3] if you send me changes to the source I can upload a compiled version for you.


Yes, the following line (#81) would have to be replaced by a similar line for another API as long as this other API returns just a number and nothing else. As you can see the curl version needs to filter the returned data.



[1] http://curl.haxx.se/download.html
[2] https://www.blocktrail.com/api/docs
[3] https://wiki.eclipse.org/Eclipse/Installation

I at some point found a script to do this in google drive's spreadsheet program.

Add this to a spreadsheet using the script editor:


Put your first address in cell A1, put the following in another cell (like B1):
=BlockchainBalance(A1)

Put the rest of you addresses in column A, copy the formula down in column B.

Don't think this way will be helping in anything , are you trying to brute force bitcoin addresses private keys ?  think
you may like to read little about the bitcoin privates keys  ;D , also i already test that with python and php ; genreating
50 to 80 k private keys and check them with php , using the blockchain.info and a sleep for 0.1 sec in each request  :o ;
and that really was none value work  ::) .

My solution to check multiple address is to use blockchain.info and php :) don't forget to use sleep function 0.1 sec
in each time it check , u can run a cron job to check 1k every 10 minutes and save result in the database or email
you when the address not 0 fund  ;) .

Good Luck ,
Bitcoin Boy .
 

Will be studying this code. OP didn't want software but I think you solved the problem in just the same that I would have (Java and Blockchain.info API). Thanks for sharing!

I tried Shorena java software, but it not work for me.

I have a thousand address on different computer / android / paper wallet and also
trying to find way to simple track all this addresses.

The java version does not work because bc.i is no longer answering this kind of API requests. Use the curl shell script (I edited the post it has a link) which uses blocktrails API. You will need an API key and you will be limited to ~20-30 requests over a few sections. Thus its probably best to modifiy the code if you have >>30 addresses to check.

Thank you for fast answer  ;)

We recently added support to search upto 1000 address at one go in blockonomics (https://www.blockonomics.co) . You can try that out.