Bitcoin Forum
February 25, 2017, 08:42:29 PM *
News: Latest stable version of Bitcoin Core: 0.13.2  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Use Google Spreadsheets to automatically keep track of your wallet balance  (Read 1548 times)
coblee
Donator
Legendary
*
Offline Offline

Activity: 1134


Creator of Litecoin. Director of Eng at Coinbase.


View Profile
June 27, 2011, 08:32:11 AM
 #1

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.

1488055349
Hero Member
*
Offline Offline

Posts: 1488055349

View Profile Personal Message (Offline)

Ignore
1488055349
Reply with quote  #2

1488055349
Report to moderator
1488055349
Hero Member
*
Offline Offline

Posts: 1488055349

View Profile Personal Message (Offline)

Ignore
1488055349
Reply with quote  #2

1488055349
Report to moderator
1488055349
Hero Member
*
Offline Offline

Posts: 1488055349

View Profile Personal Message (Offline)

Ignore
1488055349
Reply with quote  #2

1488055349
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
nvmind
Newbie
*
Offline Offline

Activity: 14


View Profile
June 27, 2011, 08:40:00 AM
 #2

Thanks for the info I might find this useful later.
MadSweeney
Full Member
***
Offline Offline

Activity: 163



View Profile
June 27, 2011, 08:54:27 AM
 #3

This is worth a look. Thanks for sharing.

nhodges
Sr. Member
****
Offline Offline

Activity: 308


View Profile
June 27, 2011, 09:10:01 AM
 #4

Spreadsheet wizard, this is awesome!

coblee
Donator
Legendary
*
Offline Offline

Activity: 1134


Creator of Litecoin. Director of Eng at Coinbase.


View Profile
June 27, 2011, 09:21:37 AM
 #5

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

Maged
Legendary
*
Offline Offline

Activity: 1260


View Profile
June 27, 2011, 07:56:09 PM
 #6

Good stuff!

iMiner
Jr. Member
*
Offline Offline

Activity: 37



View Profile
June 27, 2011, 09:25:43 PM
 #7

Wow, didn't know Google Docs was so versatile - but there was certainly some geniality involved as well.

Donated for this excellent tool!
andes
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 27, 2011, 09:33:56 PM
 #8

Wow, congratulations, excelent work.
XIU
Member
**
Offline Offline

Activity: 84


View Profile
June 27, 2011, 10:10:23 PM
 #9

Awesome idea, made a copy for myself :p

1xiuHwHk81j4TRnLuLBMvH2ctqtTsubT6
coblee
Donator
Legendary
*
Offline Offline

Activity: 1134


Creator of Litecoin. Director of Eng at Coinbase.


View Profile
June 27, 2011, 10:26:48 PM
 #10

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

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!