Username: Password:

Author Topic: Free tracking spreadsheet for Binance  (Read 3464 times)

Offline chad.mercer

  • Trust: (0)
  • Rookie
  • *
  • Posts: 7
    • View Profile
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.

Offline myn

  • Trust: (0)
  • Rookie
  • *
  • Posts: 4
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #1 on: January 15, 2018, 09:37:39 PM »
Thank you!

Long overdue for us Binance users who can't easily calculate Profit/Loss

Offline myn

  • Trust: (0)
  • Rookie
  • *
  • Posts: 4
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #2 on: January 16, 2018, 03:08:18 AM »
Gave this a run tonight and was running great for awhile and then started running every few mins:  See below.  My settings are every 30 mins

2018-01-15   20:54
2018-01-15   20:57
2018-01-15   21:26
2018-01-15   21:37
2018-01-15   21:41
2018-01-15   21:43
2018-01-15   21:53
2018-01-15   21:57

Offline chad.mercer

  • Trust: (0)
  • Rookie
  • *
  • Posts: 7
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #3 on: January 18, 2018, 08:30:29 PM »
I had a similar issue today. I'll take a look at it.  Thanks.

Offline Culture

  • Trust: (+8)
  • Novice
  • *
  • Posts: 41
    • View Profile
  • Telegram: @CultureCrypto
Re: Free tracking spreadsheet for Binance
« Reply #4 on: January 19, 2018, 07:51:08 PM »
I had a similar issue today. I'll take a look at it.  Thanks.

Does this pull down Deposit and Withdrawal history?  Sorry - getting the sheet now, but thought I'd ask.
If you find my discussion useful, buy me a drink: 17vaWPJeDN7YXfRu6TRrwUDY8ETTPtJuCu

Offline chilly

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #5 on: January 24, 2018, 01:55:13 AM »
I've been using this great all day no issues. Thanks Mate!

Offline myn

  • Trust: (0)
  • Rookie
  • *
  • Posts: 4
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #6 on: January 24, 2018, 02:13:20 AM »
I had a similar issue today. I'll take a look at it.  Thanks.

Does this pull down Deposit and Withdrawal history?  Sorry - getting the sheet now, but thought I'd ask.

Just checking in.  Was curious if you fixed this?

Thanks

Offline Driesketeer

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #7 on: January 25, 2018, 11:34:27 AM »
Some advice for users: create a new API key at Binance and set it to "read-only"

Great sheet, thanks!


Offline miwi

  • Trust: (0)
  • Rookie
  • *
  • Posts: 8
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #8 on: February 16, 2018, 04:57:09 AM »
Thanks for that,

I am getting in the BTC equivalent tabel #NUM! error. Someone any idea?

Offline fboyer

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #9 on: February 17, 2018, 02:55:15 AM »
I feel like I shouldn't be asking this but where is the Manual update button?

:(

EDIT: Nevermind found the big Play button in the toolbar in Tools->Script Editor...
« Last Edit: February 17, 2018, 03:18:33 AM by fboyer »

Offline wheeeeee

  • Trust: (0)
  • Rookie
  • *
  • Posts: 3
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #10 on: February 27, 2018, 10:01:11 AM »
i do my trading on binance with eth as base pair. does if work for that as well?
thanks a lot!

Offline sergeymiks

  • Trust: (0)
  • Rookie
  • *
  • Posts: 8
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #11 on: March 01, 2018, 01:19:30 PM »
today I also stopped working (BTC #NUM!)

Offline tekkaattack111

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #12 on: March 02, 2018, 08:18:50 AM »
today I also stopped working (BTC #NUM!)

Same. (#NUM error). Binance key and secret are correct. Anyone figure this out?

Offline Lostdog

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #13 on: July 09, 2018, 10:26:04 PM »
today I also stopped working (BTC #NUM!)

Same. (#NUM error). Binance key and secret are correct. Anyone figure this out?
I tried to debug the script but this ends rather quickly with a Binance API ban because of too many requests.

Offline christye

  • Trust: (0)
  • Rookie
  • *
  • Posts: 25
    • View Profile
Re: Free tracking spreadsheet for Binance
« Reply #14 on: November 27, 2018, 05:01:52 PM »
Hey guys,

I made the original Polo version, which this is based on. I recently started using GB again, and noticed the #NUM error. I think I've fixed it - at least, it worked for me:

  • Click view, hidden sheets, values - hit OK through the warning message
  • Select the cell A1, the formula should read "=sum(E:E)", we need to change it to "=sum(iferror(E:E,""))"

That should fix it - the provided formula didn't have any error checking, now it will ignore any errors from Binance, and should calculate a bit better.

Hope this helps!

BTC: 14JMYDM15XkfyEJHaY7KmuU6yooxXrSWHJ
ETH: 0xf577a29C77223B619c7dA42B8F38c20113427CDC