News
Summer 2023:   Completely stopped development and free available
Unfortunately, Google has discontinued the legacy Google Pages, resulting in the deletion of some of our older documentation.


December 2022:   Unable to connect from Google sheets to the binance.com api

In December 2022, Binance made a change to their services and blocks traffic from several locations, including the United States.


Binance legal terms:
https://www.binance.com/en/terms


"For the purposes hereof, “Restricted Location” shall include the United States, Malaysia, Ontario (Canada), and such other locations as designated by Binance Operators from time to time as a “Restricted Location” 



As you probably know, it's not your workstation that makes a connection, but the Google Cloud (Google Sheets/Script)

Many, many people are complaining because this does not only affect the Google Cloud but also many other cloud services and tools like trading bots.

I expect this needs to be resolved by Binance soon to keep their customers.


The Response when accessing the Binance API:

Exception: 

Request failed for https://api.binance.com returned code 451. Truncated server response: 

{ "code": 0, "msg": "Service unavailable from a restricted location according to 'b. Eligibility' in https://www.binance.com/en/terms. 

Please c... (use muteHttpExceptions option to examine full response)



See this Reddit post and this specific to Google Sheets:


If you Google on the error, you get a lot of complaints from many, many users:  (check)



Workaround

The workaround is to create a manual exchange in CtrXL

This at least allows you to track the value of your holdings without access to the Binance API.

See this section in the manual on howto setup a manual exchange in CtrXL.



Sorry, nothing I can do at the moment to fix the Binance issue,


wkr,

Eelco


PS   Please drop me an email if there is any news about the issue. (moosylog@gmail.com)