Post
Topic
Board Development & Technical Discussion
Re: How to import account balance to an excel sheet
by
The best one
on 27/04/2018, 22:25:32 UTC
Yes there is.
It's pretty easy.

You need to download power shell for Excell  and use api data from coinmarketcap (you can track data from binance exchange from their api)
I learned from this post on reddit. All detailed there. You can use his sheet or create your own. It's easy you should try.

.https://www.reddit.com/r/CryptoCurrency/comments/7m3nvy/ive_created_an_excel_crypto_portfolio_tracker/

Get the API from https://api.coinmarketcap.com/v1/ticker/bitcoin

I think If we have some account balance that we can import balance to an excel and we know that Microsoft Excel offers a wealth of data manipulation tools that may be unavailable in your current program or online database. If you need access to such tools, you may need to transfer your account balance sheet into Excel. This is typically a two-step process where you first export your account balance into a supported format, then import it into Excel. Most programs and online databases, such as Paypal, QuickBooks and online banking accounts, include tools for exporting data to the widely compatible comma-delimited format or directly into Excel format. So there are some step to Import account balance to an excel sheet :
The first   : Open or log in to your account balance sheet program and choose to import your account balance 
The second :Open Microsoft Excel and press "Ctrl-O" to invoke the Open window.
The third :Click the "All Excel Files ..." drop-down menu and select "Text Files " Doing so will allow you to
                 see the CSV file in the appropriate folder. If you exported the balance sheet into Excel format, skip
                 this step.
The forth : Select the exported file and click "Open." Because the file is in a recognized CSV or XLS format,
                  it will open automatically. I hope it can help you to import your account balance to an excel sheet.