Bitcoin Forum
August 16, 2017, 10:17:59 PM *
News: Latest stable version of Bitcoin Core: 0.14.2  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Help Please: HTML Import Google Doc for Current BitCoin Address Balance  (Read 1336 times)
sunnankar
Legendary
*
Offline Offline

Activity: 1031



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)


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

Activity: 616



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



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
Legendary
*
Offline Offline

Activity: 1031



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
Legendary
*
Offline Offline

Activity: 1031



View Profile WWW
May 21, 2012, 01:29:34 AM
 #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



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
Legendary
*
Offline Offline

Activity: 1031



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:  

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!