Username: Password:

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - chad.mercer

Pages: [1]
1
Services & Third Party Plugins / Free tracking spreadsheet for Binance
« on: January 15, 2018, 04:19:13 PM »
TL;DR
  • Click here: https://docs.google.com/spreadsheets/d/1Ixm6T-pDT2s4V9PBfsLqfk7pDI0QWWgF61fHVA-5v6I/edit?usp=sharing
  • Save a copy to your Google Drive. (File, Make a copy...)
  • Click on the Configuration tab.
  • Fill in your API & Secret.
  • Optional: Change Interval and/or GMT/UTC offset.
  • Click on the Balance tab.
  • Fill in your starting information: date, time, initial BTC balance.
  • Click the Manual update button. (This will download your account info from Binance and set up the automated schedule based on your interval.)
  • You will be prompted about security. If you want this spreadsheet to do anything, you will need to accept the warnings.  (See Authorization below.)
  • Profit.

Slightly More Verbose Description:
First of all, the code is directly visible under Tools, Script Editor.  There's nothing nefarious there.  I promise.  In order for the updates to run automatically on a schedule, Google needs permission to run the Apps Script engine and update your spreadsheet remotely without you manually doing it.

Incidentally, I was able to write the code so that it sets up the schedule and adjusts the times based on your local timezone, provided you put the correct format in the Configuration tab.  I wanted more granular updates, so I go more frequently than hourly, and then clean up the spreadsheet by deleting rows I no longer need to keep weekly/daily/hourly historical data.

Authorization:
You will be asked to authorize the script.  When you do so, you will need to choose the Google account that you copied the spreadsheet to.  It will then say that the app isn't verified.  There should be an Advanced link in the bottom left of the window.  Click that, and then the link that says Go to Auto Update - Binance (unsafe).  Once you're there, you can see what the script will be allowed to do.  Click the Allow button here, and you should be good to go.

Thanks & Attributions:
First of all, I want to thank christye for the inspiration and the template that I used to create a tracking spreadsheet for Binance.  You can find that thread with the Poloniex version here: https://gunthy.org/forum/index.php/topic,1124.0.html 

Full disclosure: I sent a donation to christye--as should you if you're using the spreadsheet!--and all of these code changes can be integrated into the Poloniex version if christye is interested in my doing so.

Donations:
BTC: 175TBxNBETFfrcSSGTAiaCL2xzTifCsZP8
LTC: LiFeCyk6CUE1u6i9686qZdv9xmFroxpN6S
ETH: 0x1663aea118e82cf79e85fb7d89e9b00d90ef7dd1
Zcash: t1aruXaavX51gX3dgcWnBHeLKCSY5eJynxj
TRON: 0x1663aea118e82cf79e85fb7d89e9b00d90ef7dd1
Dash: Xh7yeZM7wyHbD6iqkd4D1V1eMupnCeEvgm

Feel free to unload bags or dust on me (PM me for wallet addresses of your garbage coins).  I'll take pretty much anything if I can find a wallet for it.

Pages: [1]