Bitcoin Forum
March 28, 2024, 07:21:26 PM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Help Please: HTML Import Google Doc for Current BitCoin Address Balance  (Read 1464 times)
sunnankar (OP)
Legendary
*
Offline Offline

Activity: 1031
Merit: 1000



View Profile WWW
May 21, 2012, 01:01:47 AM
 #1

Since BlockExplorer is being unreliable I am trying to find a more efficient way to import the current value of a bitcoin address. Unfortunately, it looks like Blockchain.info import's with a BTC at the end so the numbers cannot be manipulated very easily.

Does anyone have a single cell HTMLimport formula for importing the current value of a BitCoin address? Pretty please.

Example:

Code:
C9=BitCoin Address
A1=ImportData("http://blockexplorer.com/q/getreceivedbyaddress/"&C9)
A2=ImportData("http://blockexplorer.com/q/getsentbyaddress/"&C9)
Current Balance = A1-A1

OR

=ImportHtml("http://blockchain.info/address/"&D6, "table", 2)

(spits out the final balance but is not usable because of the BTC at the end)


1711653686
Hero Member
*
Offline Offline

Posts: 1711653686

View Profile Personal Message (Offline)

Ignore
1711653686
Reply with quote  #2

1711653686
Report to moderator
1711653686
Hero Member
*
Offline Offline

Posts: 1711653686

View Profile Personal Message (Offline)

Ignore
1711653686
Reply with quote  #2

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

Posts: 1711653686

View Profile Personal Message (Offline)

Ignore
1711653686
Reply with quote  #2

1711653686
Report to moderator
1711653686
Hero Member
*
Offline Offline

Posts: 1711653686

View Profile Personal Message (Offline)

Ignore
1711653686
Reply with quote  #2

1711653686
Report to moderator
1711653686
Hero Member
*
Offline Offline

Posts: 1711653686

View Profile Personal Message (Offline)

Ignore
1711653686
Reply with quote  #2

1711653686
Report to moderator
terrytibbs
Hero Member
*****
Offline Offline

Activity: 560
Merit: 501



View Profile
May 21, 2012, 01:15:28 AM
 #2

http://blockchain.info/q/addressbalance/<address>

Divide by 1e8
drakahn
Hero Member
*****
Offline Offline

Activity: 504
Merit: 500



View Profile
May 21, 2012, 01:22:34 AM
 #3

=REGEXREPLACE('the cell with the x.xxx BTC"," BTC",)

OR

=REGEXREPLACE((ImportHtml("http://blockchain.info/address/"&D6, "table", 2))," BTC",)

14ga8dJ6NGpiwQkNTXg7KzwozasfaXNfEU
sunnankar (OP)
Legendary
*
Offline Offline

Activity: 1031
Merit: 1000



View Profile WWW
May 21, 2012, 01:24:24 AM
 #4


With the URL I get the 9 digit balance but I cannot seem to import that into the Google Doc so I can divide by 1e8. What am I missing with the Import formula?

Code:
D6=BitCoin Address
=ImportHtml("http://blockchain.info/q/addressbalance/"&D6)

sunnankar (OP)
Legendary
*
Offline Offline

Activity: 1031
Merit: 1000



View Profile WWW
May 21, 2012, 01:29:34 AM
Last edit: May 21, 2012, 01:50:58 AM by sunnankar
 #5

=REGEXREPLACE('the cell with the x.xxx BTC"," BTC",)

OR

=REGEXREPLACE((ImportHtml("http://blockchain.info/address/"&D6, "table", 2))," BTC",)

Got the first one to work but had to fix the ' and ".

Code:
=REGEXREPLACE(C35," BTC",)

The second one says 'Not a strong: Transactions' so I think it is referring to the first cell imported from the table.


NOTE: After trying to manipulate the numbers this produces I have found it acts oddly. For example, the sum() function will not work but if you add the cells using the + symbol then it will work. Also, the numbers cannot be multiplied if you are using a reference to a cell instead of an integer (Ex. A6 versus 5). Very weird.

drakahn
Hero Member
*****
Offline Offline

Activity: 504
Merit: 500



View Profile
May 21, 2012, 02:22:52 AM
 #6

Actually i noticed that too, i forgot to add that part, after the regexreplace do +1-1 to get a usable number

14ga8dJ6NGpiwQkNTXg7KzwozasfaXNfEU
sunnankar (OP)
Legendary
*
Offline Offline

Activity: 1031
Merit: 1000



View Profile WWW
June 06, 2012, 07:30:19 PM
 #7

Those those that are interested ZNORT987 has created some awesome tools for Google Doc importation. Follow the thread.

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!