Bitcoin Forum
November 21, 2018, 06:55:53 AM *
News: Latest Bitcoin Core release: 0.17.0 [Torrent].
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Googlesheet Blockchain and API balance  (Read 39 times)
andreadefi
Newbie
*
Offline Offline

Activity: 13
Merit: 0


View Profile
March 14, 2018, 12:03:43 PM
 #1

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
1542783353
Hero Member
*
Offline Offline

Posts: 1542783353

View Profile Personal Message (Offline)

Ignore
1542783353
Reply with quote  #2

1542783353
Report to moderator
1542783353
Hero Member
*
Offline Offline

Posts: 1542783353

View Profile Personal Message (Offline)

Ignore
1542783353
Reply with quote  #2

1542783353
Report to moderator
1542783353
Hero Member
*
Offline Offline

Posts: 1542783353

View Profile Personal Message (Offline)

Ignore
1542783353
Reply with quote  #2

1542783353
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1542783353
Hero Member
*
Offline Offline

Posts: 1542783353

View Profile Personal Message (Offline)

Ignore
1542783353
Reply with quote  #2

1542783353
Report to moderator
1542783353
Hero Member
*
Offline Offline

Posts: 1542783353

View Profile Personal Message (Offline)

Ignore
1542783353
Reply with quote  #2

1542783353
Report to moderator
1542783353
Hero Member
*
Offline Offline

Posts: 1542783353

View Profile Personal Message (Offline)

Ignore
1542783353
Reply with quote  #2

1542783353
Report to moderator
starmyc
Member
**
Offline Offline

Activity: 194
Merit: 86

Software engineer


View Profile WWW
March 16, 2018, 10:29:43 PM
 #2

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)

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!