Wallet and trades values

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.”:

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.

click the Headers tab, and see if you have these settings as in the screenshot.