Did you try CONCATENATE ?
The following works:
Code:
= IMPORTDATA (CONCATENATE("https://blockchain.info/q/addressbalance/",J24))(with your address in J24, in this case)
Topic: Googlesheet Blockchain and API balance (Read 92 times)
Hello,
Did you try CONCATENATE ?
The following works:
(with your address in J24, in this case)
Did you try CONCATENATE ?
The following works:
(with your address in J24, in this case)
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
= 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
Jump to: