Topic: Auto updating Wallet balance in Excel??? (Read 1366 times)
Perfect exactly what I needed. Thanks
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.
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.
normally the wallet software does a sync already on start up
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
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
Jump to: