Quote from: The Ferox on August 13, 2014, 02:27:05 AM

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 at some point found a script to do this in google drive's spreadsheet program.

Add this to a spreadsheet using the script editor:

Code:

// Blockchain.info ###############################################################

function BlockchainBalance(btcAddress){
// Fetch balance from Blockchain.info API
// EX: =BlockchainBalance("1Namjies9JeJ4ugCzjkAj6dbaWrtjAFKCk")
// http://blockchain.info/address/1dice9wVtrKZTBbAZqz1XiTmboYyvpD3t?format=json
var r = fetchCached("http://blockchain.info/address/" + btcAddress + "?format=json&limit=0")
if ('undefined' == typeof(r))
return 'No data!'
r = Utilities.jsonParse(r)
if ('undefined' == typeof(r))
return 'Malformed JSON!'
r = r['final_balance'] / 100000000
if ('undefined' == typeof(r))
return 0

if (!isNaN(r)){r = r*1}
return r
}

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.

pummle

Posts

Merits