Quote from: rapazev on October 21, 2016, 07:29:32 PM

why not use blockchain.info? keep your address in a note and copy and paste on blockchain, voila.

Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server usage it sometimes takes time to update my 10 or so addresses.

plus I am lazy and don't what to enter every address like you said

Current code
=importdata(IF(ISBLANK(A),"",CONCAT("https://chainz.cryptoid.info/btc/api.dws?key=@@@@@@@@@@@@&q=getbalance&a=",A1)))
New code or something like this
=importdata(IF(ISBLANK(A),"",CONCAT("http://192.168.1.101/q/addressbalance/",A1)))