With your desired Google Spreadsheet opened, go to Tools -> Script editor.
#BINANCE API KEY DOWNLOAD#
Just download the latest BINANCE.gs all-in-one file + appsscript.json and copy & paste its contents following these steps: Hit Save settings button and continue with the steps below!.Under the Calculation tab set the Recalculation combobox to On change and every minute.
I think and hope that many of you will find it as useful as it is for myself.Įnjoy, cheers! 🍻 How can I use it in my Google Spreadsheets?įirst of all, open your desired Google Spreadsheet and configure it properly:
It does NOT need write/trade access in ANY way to properly work with all its features, so don't give extra permissions if they aren't needed! In deed, I personally recommend to generate a READ-ONLY API key at Binance site here. It only requires a Binance API key for private endpoints like account info and open/done/table orders, but a READ-ONLY API key is enough for everything to work.
#BINANCE API KEY UPDATE#
Last data update time and current add-on version being usedĪt first glance, NO Binance API key is needed to call public endpoints like current prices, historic prices and 24h stats.Historical orders table (SPOT + CROSS + ISOLATED + FUTURES).Latest done/finished orders (SPOT + CROSS + ISOLATED + FUTURES).All current open orders (SPOT + CROSS + ISOLATED + FUTURES).
Total account assets from Binance wallets (SPOT + LENDING + CROSS + ISOLATED + FUTURES + SUB-ACCOUNTS).This add-on is basically an API client specially hand-crafted to work between Google Spreadsheets and Binance.īy using the BINANCE() formula in your spreadsheet, you can get data fetched from Binance API like: Since Binance decided to block API requests coming from restricted countries like USA (from which the Google servers in where our spreadsheets run are located), you'll probably need a proxy.Ĭheck Binance to Google Sheets Add-On Proxy for a basic proxy server implementation that I did for myself and is currently working fine. Be aware that your API Key may be disclosed by authorizing it to a third-party platform.A lightweight Google Spreadsheets Add-On to GET data directly from Binance API without any intermediaries! Please do not disclose your API Key to anyone to avoid asset losses. Binance recommends that you whitelist trusted IP address(es) for the API Key to improve your account security.After your confirmation, "Enable Spot & Margin Trading" will be enabled and will be valid for 30 days. However, when you edit the permissions, there will be a pop-up window if the above rules are met. The API Key created before the adjustment time will not trigger the new rules automatically.The new rules are valid for all accounts, including normal accounts, master accounts and sub-accounts.If your API Key has whitelisted IP address(es), the "Enable Spot & Margin Trading" permission will not expire.At that time, you are able to manually enable "Spot & Margin Trading" permission again, then you can view the corresponding expiration time prompt on the "Enable Spot & Margin Trading" permission. The system will automatically uncheck the permission after the expiration date. this API Key allows access to any IP address, your selected "Enable Spot & Margin Trading" permission will be valid for 30 days from the activation time. If your API Key does not have whitelisted IP address(es), i.e.To improve the security of user accounts, Binance will adjust the "Enable Spot & Margin Trading" permission rules of the API Key on (UTC), with details as follows:
0 kommentar(er)
