Re: How to import account balance to an excel sheet

Quote from: bitmover on April 18, 2018, 03:03:18 AM

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

Thank you for trying but I dont think you read my post completely. I know there are already ways to import public data like that. I`ve looked it up everywhere and saw many examples. But what I need is importing the private data.

Like my account balance in Binance to a specific cell.
When there is a private api there is also a secret. Plus the api is not a link but 50 digit code. So this is where I`m confused.

Do you know how to import private data from an exchange to excel?

Quote from: HCP on April 18, 2018, 03:06:59 AM

You should look into "Power Query" (aka "Get & Transform" in Excel 2016): https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

It allows you to get data from a number of sources including Web API's and pass in authentication information etc... You can extract as much or as little info from the returned data and do all sorts of transformations/extractions etc...

I have that already but couldnt figure out how and where to enter the details there. Because the API I get from my account is not a link. It`s a 50 digit code and there is a secret also.
If you know how to do it, could you please explain me?