Hi mates,
I’m just a beginner in the API world and I looking for manage my wallet and TP. As first step I wanna have my wallet and trades values on a sheet (Google Sheets) in order to calculating my average buy price for each coin in my wallet. I installed the API connector and try some URL like “https://api1.binance.com/api/v3/ticket/24hr” for informations of public market but I don’t know how take the informations and value of my wallet and historic trades.
Any ideas ?
Below endpoints should be useful for the mentioned “value of my wallet and historic trades.”:
Spot Account Balances:
https://binance-docs.github.io/apidocs/spot/en/#account-information-user_data
Spot Account’s Trades.
https://binance-docs.github.io/apidocs/spot/en/#account-trade-list-user_data
In addition, as you’re just starting, this post might be of interest: Where to start if I'm new to Binance API
Thks you for all of this informations and tips. I learned many things on this but I already have this problem to access at my wallet and account data, with the same Error: “1) myTrades: Completed with errors
- We received an error from the API server (401) show response{“code”:-2014,“msg”:“API-key format invalid.”}”
And this in both cases “Spot Account Balances” and “Spot Account’s Trades”, maybe need to allow the acces with my API Key or something else ?
Thks
I’m also having this problem, did you manage to solve it? The public query requests work, but in the trade collection the requests give an error:
{
“code”: -2014,
“msg”: “API-key format invalid.”
}
The Signature, test api and secret keys are correct.
https://testnet.binance.vision
Following the tutorial and step by step, gave this error.
Look:
I’m using Postman to test the api.
![spot-testenet-api-binance|690x372]
(upload://wa7P2gON5W1N5gK80fg8Zf66uRC.jpeg)
Can anyone help us? Thank you very much.
