Bitcoin Forum
December 04, 2016, 06:14:24 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: « 1 [2]  All
  Print  
Author Topic: Use Google Spreadsheets to automatically keep track of your wallet balance  (Read 8262 times)
sunnankar
Legendary
*
Offline Offline

Activity: 1030



View Profile WWW
September 05, 2011, 04:33:35 PM
 #21

Nice sheet.  You will need to export all your public keys including the hidden ones if you want the balance to be accurate.  And as theymos says, you really need to be using the mytransactions API to avoid hammering his server, I am querying 50 addresses at a time so only perform 3 GET requests for my entire wallet.

My android wallet balance viewer (link in my sig) does the same thing on Android. Shameless plug. Smiley

Will

It appears blockexplorer with a TradeHill deposit address does not yield an accurate balance.

Anyone have the code for getting your TradeHill balance via their API imported to Google Docs?

If it cannot be directly imported via formula line in Google Docs then the HTML code for a POST request on my own server would sure be a handy work around that I could scrap with the ImportHTML function.

Pretty please. Thanks.

There are several different types of Bitcoin clients. EWallets are like banks -- a central organization has complete control over your money. You shouldn't put much money in EWallets.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480832064
Hero Member
*
Offline Offline

Posts: 1480832064

View Profile Personal Message (Offline)

Ignore
1480832064
Reply with quote  #2

1480832064
Report to moderator
Sukrim
Legendary
*
Offline Offline

Activity: 1848


View Profile
September 05, 2011, 10:50:47 PM
 #22

It appears blockexplorer with a TradeHill deposit address does not yield an accurate balance.
Got an example?

As far as I understand it, deposit adresses do not show higher amounts if you just do trades.
e.g.:
You deposit 10 BTC --> Balance on TH: 10 BTC; Balance on the address: 10 BTC
You trade the 10 BTC for 100 USD --> Balance on TH: 0 BTC; Balance on the address: maybe still 10 BTC (as it is on an adress owned by tradehill and another adress might get "billed" on payouts)
BTC crashes and you buy 100 BTC for 100 USD --> Balance on TH: 100 BTC; Balance on the address: maybe still 10 BTC, maybe less.

I don't really get what you want to achieve... you can track how much you paid to TH over time accurately though.

https://bitfinex.com <-- leveraged trading of BTCUSD, LTCUSD and LTCBTC (long and short) - 10% discount on fees for the first 30 days with this refcode: x5K9YtL3Zb
Mail me at Bitmessage: BM-BbiHiVv5qh858ULsyRDtpRrG9WjXN3xf
piuk
Hero Member
*****
Offline Offline

Activity: 910



View Profile WWW
September 06, 2011, 01:16:08 AM
 #23

Nice idea. I made this for those who don't have google docs.

Rassah
Legendary
*
Offline Offline

Activity: 1624


Director of Bitcoin100


View Profile
September 06, 2011, 03:02:38 PM
 #24

Very nice. I'll have to set one up for my savings, too.
Btw, I decrypt my savings wallet file about once a month, because I don't trust data integrity of backups. So, I decrypt it, test it, and encrypt it, making another copy of the file with the file name including the date of the time it was tested. This way i have a rolling backup with multiple copies of the wallet file in my backup locations. If there is some corruption and I can't open the newest file, I'll at least have some older backups to fall back on. I'm paranoid like that.

sunnankar
Legendary
*
Offline Offline

Activity: 1030



View Profile WWW
September 06, 2011, 11:45:26 PM
 #25

It appears blockexplorer with a TradeHill deposit address does not yield an accurate balance.
Got an example?

I am using Tradehill like an online wallet and not trading in the account. If I use the Deposit Address to search the block explorer it does not return the available balance in Tradehill.

I would like to have an =importHTML() function for Google Docs which brings in the Available balance from Tradehill.

It would be nice to pull it directly from Tradehill via the API. But if needed I could pull from the API, create a webpage on my server that displays it and then reference that webpage with the function.

Problem is I do not understand the API or PHP well enough to either pull it directly into the Google Doc or create the HTML/PHP for a webpage that displays the Available balance.


sunnankar
Legendary
*
Offline Offline

Activity: 1030



View Profile WWW
September 17, 2011, 04:30:03 AM
 #26


That is pretty cool. Anyone figured out how to get Tradehill's API to echo a balance?

pazor
Legendary
*
Offline Offline

Activity: 966



View Profile
January 06, 2012, 04:52:40 PM
 #27

Hello coblee,

nice work... thanks for the inspiration!

greetings
pazor

treuhand-Dienst gewünscht? - frag per PM an
BTC 174X17nR7vEQBQo4GXKRGMGaTmB49Gf1yT
tvbcof
Legendary
*
Online Online

Activity: 1974


View Profile
October 29, 2013, 12:58:03 AM
 #28


I feel OK about necro-ing this thread because I've been using it off and on for the last several years and it's been pretty reliable.

The other day, my permutation gave me a start when it switched to Yuan from BTCChina.  Fixed that.

Now it barely works at all, though it seems to probably be an issue with blockexplorer producing odd results.

Anyone got a more modernized form and/or ideas about a more suitable data source than
'http://blockexplorer.com/q/getreceivedbyaddress/1blahblahblah...'

Also, I sort of ran out of capacity for Google docs to make remote queries at about the same time as I ran out of addresses that I wanted to query so I never bothered to look for other options.  A single source for balance on an address rather than several and some math would eek things out a bit longer.


coblee
Donator
Legendary
*
Offline Offline

Activity: 1078


firstbits.com/1ce5j


View Profile WWW
October 29, 2013, 01:05:47 AM
 #29

You can use http://blockchain.info/q/addressbalance/1blahblah or http://blockchain.info/q/getreceivedbyaddress/1blahblah
But be careful as that returns a number in satoshis, so you have to divide it by 100000000

tvbcof
Legendary
*
Online Online

Activity: 1974


View Profile
October 29, 2013, 01:17:56 AM
 #30

You can use http://blockchain.info/q/addressbalance/1blahblah or http://blockchain.info/q/getreceivedbyaddress/1blahblah
But be careful as that returns a number in satoshis, so you have to divide it by 100000000

Thanks coblee.  I think that blockexplorer is probably rate-limiting some of Google's address space.  Manual queries I do work OK.  I saw some reference to Cloudflare in the output on the spreadsheet.  Dunno if blockexplorer has been using them forever or what (but I kind of doubt it, and was surprised to see it actually.)


willphase
Hero Member
*****
Offline Offline

Activity: 770


View Profile
October 29, 2013, 10:44:29 AM
 #31

I just create a new wallet on blockchain and pull the public keys of the addresses I wish to monitor into that wallet, then get the balance using

=importData("https://blockchain.info/merchant/WALLET-GIUD/balance?password=PASSWORD")

then just regextract to pull the balance in satoshis

=regexextract(A1,"\d+")

and divide by 10,000,000

=A2/100000000

Since only the public keys are on there, I don't worry about putting a password in my Google doc.

Will

Pages: « 1 [2]  All
  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!