I'm surprised that people are trying to create a mining pool with a pyramid scheme. Well, I guess I'm not that surprised.

Feel free to copy (or steal!) my spreadsheet formulas. Yeah, Google docs is pretty powerful.

This is useful to me since for my savings account, I will rarely send money out. And when I do and there is a new return address, I will just add that address to my spreadsheet. I wish the client will let me specify a return address and not just create a new one, but that's another topic.

If you would provide the getsentbyaddress or getbalancebyaddress, I can make the spreadsheet use those APIs. Otherwise, html scraping is the best way.

But I need both getreceivedbyaddress and getsendbyaddress. Do you plan to implement the latter? Or better yet, how about getbalancebyaddress?

Check this transaction out:
http://blockexplorer.com/tx/15571140b463eb09c05da9b69e317cfa6c4ca4e4838fe61bc602982336d88efc#i1425815

You basically sent the full 1.04 out and .0395 got returned to you at another address.

ghost: thanks, I will make the change. I have not run cross this issue since I don't play with accounts with more than 1000 bitcoins

eternex: thanks. If you really want the account value to be real time, check out the workaround code in the mtgox price cell. I didn't do that for the other cells because in most cases, you don't need it.

I posted this to the main forum: http://forum.bitcoin.org/index.php?topic=23422.0

I'd like to share this google spreadsheet I created:
https://spreadsheets.google.com/spreadsheet/ccc?key=0Amu2Hoiel5SYdFJMVV95cG5pbFppSHc4YnVwUzZwanc&hl=en_US&authkey=CIa_g-AM

I created this spreadsheet because I wanted to keep a secure savings account. For this savings account, I have 12 bitcoin addresses that I use for sending money to. And since I rarely need to take money out of my savings account, I would prefer to keep my wallet.dat file encrypted and not point the bitcoin client to that wallet much. But I still want an easy way to check how much money I have in that account. I figured out that I can use blockexplorer.com to check the balance of each of my 12 bitcoin addresses. So I created this spreadsheet to do the work for me. Now, I will never need to decrypt my savings account wallet file unless I need to send money out of it. I can just use this spreadsheet to make sure that my money is still safe and sound.

This may be helpful for others too, so I made this example spreadsheet. To use it, make a copy of it to your own account. If you want the total balance to be accurate, be sure to copy all your receiving bitcoin addresses into the spreadsheet and create more rows if you need to.

Thanks will try it out.

I agree Bitless deserves more donation. But the truth about mining is that if EVERYONE gets 3% improvement, the difficulty level will just go up by 3% and everyone ends up making the same. So that's why some people may be hiding their private optimizations so that only they alone benefit. Anyways, but I truly appreciate what Bitless has done. Hope you get more donations.

Thanks for the donation... whoever that is. I'm glad people are finding this useful.

Worked for me. 380 -> 392 (3.16%)
Thanks. This is worth donating for!

I'd like to share this google spreadsheet I created:
https://spreadsheets.google.com/spreadsheet/ccc?key=0Amu2Hoiel5SYdFJMVV95cG5pbFppSHc4YnVwUzZwanc&hl=en_US&authkey=CIa_g-AM

I created this spreadsheet because I wanted to keep a secure savings account. For this savings account, I have 12 bitcoin addresses that I use for sending money to. And since I rarely need to take money out of my savings account, I would prefer to keep my wallet.dat file encrypted and not point the bitcoin client to that wallet much. But I still want an easy way to check how much money I have in that account. I figured out that I can use blockexplorer.com to check the balance of each of my 12 bitcoin addresses. So I created this spreadsheet to do the work for me. Now, I will never need to decrypt my savings account wallet file unless I need to send money out of it. I can just use this spreadsheet to make sure that my money is still safe and sound.

This may be helpful for others too, so I made this example spreadsheet. To use it, make a copy of it to your own account. If you want the total balance to be accurate, be sure to copy all your receiving bitcoin addresses into the spreadsheet and create more rows if you need to.