Bitcoin Forum

Bitcoin => Bitcoin Discussion => Topic started by: coblee on June 27, 2011, 08:32:11 AM



Title: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: coblee on June 27, 2011, 08:32:11 AM
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.


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: nvmind on June 27, 2011, 08:40:00 AM
Thanks for the info I might find this useful later.


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: MadSweeney on June 27, 2011, 08:54:27 AM
This is worth a look. Thanks for sharing.


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: nhodges on June 27, 2011, 09:10:01 AM
Spreadsheet wizard, this is awesome!


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: coblee on June 27, 2011, 09:21:37 AM
Thanks for the donation... whoever that is. I'm glad people are finding this useful.


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: Maged on June 27, 2011, 07:56:09 PM
Good stuff!


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: iMiner on June 27, 2011, 09:25:43 PM
Wow, didn't know Google Docs was so versatile - but there was certainly some geniality involved as well.

Donated for this excellent tool!


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: andes on June 27, 2011, 09:33:56 PM
Wow, congratulations, excelent work.


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: XIU on June 27, 2011, 10:10:23 PM
Awesome idea, made a copy for myself :p


Title: Re: Use Google Spreadsheets to automatically keep track of your wallet balance
Post by: coblee on June 27, 2011, 10:26:48 PM
I posted this to the main forum: http://forum.bitcoin.org/index.php?topic=23422.0