Hi, Does it exist any docs, tutorials or YT Videos about how to pull data from Binance to Google Sheets ?
Need to get historical data, few by day and free if possible
I ve tested APIPHENY, GECKO or CRYTOCOMPARE with no success (histo, few and free !)
Hey,
I don’t know about any tutorials. You can run a script in Google Sheets to retrieve data from either the Binance API or the data.binance.vision website. Check the Binance and Google Script documentation to learn how to call the API or have a look at this to pull data from data.binance.vision.
However, it is recommended to retrieve data from data.binance.vision to avoid hitting rate limits with the Binance API. This issue is explained in the following post: Connecting to Binance API via Google Sheets
Hi,
Thx for these infos a little bit too technical for me… I’m not a developper and also try to set up some API as coinmarket, gecko, … and falling always on this error :
Api failed with http code:451:{
“code”: 0,
“msg”: "Service unavailable from a restricted location according to ‘b. Eligibility’ in https://www.binance.com/en/terms. Please contact customer service…
Has anyone managed to get around this issue ?
Thx
As Google Apps Scripts may be located in the US, I suggest you to use Binance.us. Otherwise, you could create a standalone app outside of Google Apps Script to fetch data from the Binance API, and then call this app within Google Apps Script to retrieve the desired results.