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