Bitcoin Forum
December 12, 2017, 04:06:31 PM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Auto updating Wallet balance in Excel???  (Read 1214 times)
Pwnography6
Newbie
*
Offline Offline

Activity: 9


View Profile
January 28, 2014, 02:41:39 PM
 #1

Hello everyone,

I have recently setup an Excel spreadsheet for keeping track of my various coins. I was wondering if there is any way that anyone knows of to auto update the coin amounts in Excel as my wallet recieves a deposit or sends coins. I am a total excel noob so dont even know where to start and help would be great.

-Cheers Smiley
1513094791
Hero Member
*
Offline Offline

Posts: 1513094791

View Profile Personal Message (Offline)

Ignore
1513094791
Reply with quote  #2

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

Posts: 1513094791

View Profile Personal Message (Offline)

Ignore
1513094791
Reply with quote  #2

1513094791
Report to moderator
1513094791
Hero Member
*
Offline Offline

Posts: 1513094791

View Profile Personal Message (Offline)

Ignore
1513094791
Reply with quote  #2

1513094791
Report to moderator
oxfardk
Member
**
Offline Offline

Activity: 70


View Profile
January 28, 2014, 03:21:03 PM
 #2

normally the wallet software does a sync already on start up

/dev/null
Sr. Member
****
Offline Offline

Activity: 308


View Profile
January 28, 2014, 03:52:13 PM
 #3

It's pretty simple

Make a excel file, click on "Data" -> From web -> Insert http://altexplorer.net/address/ (your wallet address here) and select block that shows transaction and balance (you need to click on small yellow arrow icon on left side.) and then click on import.


Do this with all your altcoin address and collect all data on same page, for eg:

Then right click on each block and click on "Data Rage Properties" and check "Refresh data when opening the file" option.

Once you add your all wallets data, open Sheet 2 and make a small summary.

For example:



To grab balance from previously created data click type =  and select first cell that shows balance. Eg: 14.2125 COYE
You can then add a total count if you want or you can also grab current prices from various exchange sites and calculate total value of your coins in USD/BTC


Ps: I didn't tested this but I think when any new transaction will come into any address, that last balance transaction will get replaced by new one.

Pwnography6
Newbie
*
Offline Offline

Activity: 9


View Profile
January 29, 2014, 07:21:55 AM
 #4

Perfect exactly what I needed. Thanks Smiley
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!