Title: Auto updating Wallet balance in Excel??? Post by: Pwnography6 on January 28, 2014, 02:41:39 PM 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 :) Title: Re: Auto updating Wallet balance in Excel??? Post by: oxfardk on January 28, 2014, 03:21:03 PM normally the wallet software does a sync already on start up
Title: Re: Auto updating Wallet balance in Excel??? Post by: /dev/null on January 28, 2014, 03:52:13 PM 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. https://i.imgur.com/GD3DZ8b.jpg Do this with all your altcoin address and collect all data on same page, for eg: https://i.imgur.com/YJZ0Aen.jpg 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: https://i.imgur.com/rL1o9DE.png 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. Title: Re: Auto updating Wallet balance in Excel??? Post by: Pwnography6 on January 29, 2014, 07:21:55 AM Perfect exactly what I needed. Thanks :)
|