Bitcoin Forum

Bitcoin => Project Development => Topic started by: andreadefi on March 14, 2018, 12:03:43 PM



Title: Googlesheet Blockchain and API balance
Post by: andreadefi on March 14, 2018, 12:03:43 PM
I wanted to create a spreadsheet (googlesheet) to monitor the balance of some Bitcoin addresses. I inserted this function in a cell:
= IMPORTDATA ("https://blockchain.info/q/addressbalance/3CzAjBqsMJZV4LLL6KSsQWuH4PbDjEaeu7") and it perfectly returns the budget in satoshi.
What I can not do is replace the address with the contents of the cells where the other addresses are, eg:
= IMPORTDATA ("https://blockchain.info/q/addressbalance/B2"), I tried different systems, like (B2) &B2, etc. but I can not find the correct format to insert the reference to the cell instead of the address.
If anyone can help me, thank you


Title: Re: Googlesheet Blockchain and API balance
Post by: starmyc on March 16, 2018, 10:29:43 PM
Hello,

Did you try CONCATENATE ?

The following works:

Code:
= IMPORTDATA (CONCATENATE("https://blockchain.info/q/addressbalance/",J24))

(with your address in J24, in this case)