Topic: Help Please: HTML Import Google Doc for Current BitCoin Address Balance (Read 1478 times)
June 06, 2012, 02:30:19 PM
Those those that are interested ZNORT987 has created some awesome tools for Google Doc importation. Follow the thread.
May 20, 2012, 09:22:52 PM
Actually i noticed that too, i forgot to add that part, after the regexreplace do +1-1 to get a usable number
May 20, 2012, 08:29:34 PM
=REGEXREPLACE('the cell with the x.xxx BTC"," BTC",)
OR
=REGEXREPLACE((ImportHtml("http://blockchain.info/address/"&D6, "table", 2))," 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.
May 20, 2012, 08:24:24 PM
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)
=ImportHtml("http://blockchain.info/q/addressbalance/"&D6)
May 20, 2012, 08:22:34 PM
=REGEXREPLACE('the cell with the x.xxx BTC"," BTC",)
OR
=REGEXREPLACE((ImportHtml("http://blockchain.info/address/"&D6, "table", 2))," BTC",)
OR
=REGEXREPLACE((ImportHtml("http://blockchain.info/address/"&D6, "table", 2))," BTC",)
May 20, 2012, 08:15:28 PM
May 20, 2012, 08:01:47 PM
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:
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)
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)
Jump to: