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) |