Import Binance Data to Google Sheets
![](https://i.ibb.co/TPtMm1W/0LaoEcE.gif)
* O link do vídeo está no final desse post.
Saiba mais clicando em Robô IQ OPTION de AUTOMATIZAÇÃO de Lista de SINAIS
E conheça também sobre o Melhor Bot Para Opções Binárias 2022
Que tal um robo gratuito para IQ Option? Sistema Para IQ Option Grátis
In this tutorial, I will walk you though how to pull data from Binance into Google Sheets! No coding required 🙂 Feel free to also check out the KB article on our …
Vídeo
![](https://i.ibb.co/TPtMm1W/0LaoEcE.gif)
🤑🤑🤑For creating your own balance sheet based on your Binance account, you can check out a solution one of our users came up with here:(requires a custom Google App Script) https://mixedanalytics.com/knowledge-base/import-binance-data-to-google-sheets/#comment-23068
🚧🚧🚧If you are having 403 issues:
Try changing the domain from api1.binance.com to api2.binance.com or api3.binance.com.
If the 403 persists, you can try:
1) to decrease the size of your requests
2) create an account and use an API key
Read more on their website here:
https://www.binance.com/en/support/faq/360004492232
https://binance.zendesk.com/hc/en-us/articles/360004492232-API-Frequently-Asked-Questions-FAQ-#%E2%80%9Climits_waf%E2%80%9D
after thanks.. how can i import the order book and the order history or th market trades from binance
Awful teacher, sorry.
I'm having this error message after I hit the Run button. "We received an error from API server (403) You may have hit a rate limit…" Please help. Thanks in advance!
Thank you very much for this video. This is great info. Please make more instruction videos!
Extremely Helpful. Thank you sir!!!
But how can i do this in Mobile spreedsheets? (Android)
How get prices from Binance P2P ? please!!
Great video! Thanks. Do you have a similar video that involves the use of API keys?
error 403
Hello. Thank you for sharing. But I keep on getting this error " We received an error from the API server (403) – You may have hit a rate limit. "
I've already tried to limit the query to one symbol. Please advise.
Thank you, so do you think there could be a balance sheets for Binance Earnings? To track only the Earnings aspect of Binance?
I want to be able to work with each row using varying values. So is there a way to prevent the rows from rearranging every time I refresh the data ?
That way my calculations don’t get messed up.
What to do if I want to get specific symbols without consuming the internet for non useful symbols?
Hello, is there any way to do this continously? instead of creating a mobile app or desktop app, i'd like my google sheet to continously be updated with the prices
Thanks so much mixed analytics, but Im new to this and would if you could send a video on how to place in a spreadsheet symbols, how much i bought the token for and at what price is it now and your profit /loss, something that you could cull from your history of your portfolio. I would appreciate this very much thanks a lot.
Will this update be done automatically?
how can I get bitcoin price data from from started date to now pls reply
Thanks for the great video. Direct to the point, no time wasted.
what an awesome tutorial ! thanks dude
Does somebody know, how reload trade history from account binance to google sheets???
How import Trade History from Binance Futures to Google Sheets? Who's know ?
Thank you very much for the video, I see the prices horizontally separated by commas, how can I solve this problem?
thanks
HOw do I get connected to Binance and retrieve live market data like 1mn or tickers? 24/7
tell me how to import the current balance of binance into Google Sheets
Excellent work! A Question: I need to import the latest price of a coin pair from Binance to a single cell in Google Sheets and keep it refreshing at 1 minute intervals. Can you please tell me how I can do this? Many thanks.
nice, just what i needed
Hi! Thanks for the video! I've done all the steps but it returns an error 400… {"code":-1102,"msg":"Mandatory parameter 'symbol' was not sent, was empty/null, or malformed."}. Do you have idea how to solve that? Thanks again!
You are great, thank you!
Hi! Thanks for the tutorial! Worked great. How can I change the "open time" value to time format.
Thanks for the tips.. it's really helpful.. btw how to convert the time to regular date and time (hours & minutes) ?
This api connector is not for free…
i get continuously this error
Completed with errors
– Server responded with an error (403) – You may have hit a rate limit. Please try using one of Binance's other base domains, for example api3.binance.com
from where you open the api connector config? i ready installed but i cant see it
how do you import transaction history ? to generate a portfolio manager sheet? thks
how can i ask the api for my hole $ balance? i want to put how many $ i have on balance in my sheet, cheers !
Thank you so much!!!!
1. Can i get my trade history, order history, open orders in Google Sheet?
2. Can I put formulas to check if any scrip is in profit or loss as per current market price?
3. Can i import data from multiple exchanges for my executed orders and keep in 1 sheet? Sync after every interval