Username: Password:

Author Topic: [FREE] Tracking Spreadsheet for BITTREX  (Read 23815 times)

Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #80 on: November 21, 2017, 02:26:39 AM »
Spreadsheets for idiots please....

Where exactly is my overall profit/loss since day one??

I have 2 sheets. One called "Hourly Log". The other called "Order Book".

Am I looking at the sum of the "total costs" column from the Order Book page??

I recommend you look at the "Hourly Log" and focus on the "Total Profit (%)" column.

Remember to enter your total Bittrex BTC amount (seen in your Bittrex account including all Alt Coin holdings, not only pure BTC holdings) in the C2 cell of the spreadsheet.

NOTE: This free spreadsheet is only going to track from when you turned it on (and started tracking).  If you want to do tracking from "day one" you will need to login to Bittrex and download the .csv file with all your orders.   That's beyond the scope of the current discussion.
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline cryptologist

  • Trust: (0)
  • Rookie
  • *
  • Posts: 28
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #81 on: November 21, 2017, 02:40:02 AM »
Are you saying to look at the SUM of that entire 'Total Profit BTC' column to get an overall loss/profit since day one?

The number I get is 0.15066 (about $950)

Is this correct? After only 12 days $950?

The amount seems a little high. I'm only trading a handful of pairs and my buy limit is only about $30.


Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #82 on: November 21, 2017, 03:30:37 AM »
Are you saying to look at the SUM of that entire 'Total Profit BTC' column to get an overall loss/profit since day one?

The number I get is 0.15066 (about $950)

Is this correct? After only 12 days $950?

The amount seems a little high. I'm only trading a handful of pairs and my buy limit is only about $30.

Definitely not.

You can NOT use this Google Sheet to track all trades since day one.  It tracks since you started using the sheet.  And you must enter the proper starting BTC value or it can not calculate properly.

Nobody said anything about the SUM of the entire "Total Profit (%)" column.   (Don't do that)
Each cel of "Total Profit (%)" as it was at that exact moment in time (when the script ran).

I also recommend AltPocket for FREE tracking via API.  And you can manually enter trades at AltPocket  if you want to.

If you want to track all Bittrex trades since day one you will need to login to Bittrex and download the .CSV of all trades.

APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline cryptologist

  • Trust: (0)
  • Rookie
  • *
  • Posts: 28
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #83 on: November 21, 2017, 05:49:08 AM »
Are you saying to look at the SUM of that entire 'Total Profit BTC' column to get an overall loss/profit since day one?

The number I get is 0.15066 (about $950)

Is this correct? After only 12 days $950?

The amount seems a little high. I'm only trading a handful of pairs and my buy limit is only about $30.

Definitely not.

You can NOT use this Google Sheet to track all trades since day one.  It tracks since you started using the sheet.  And you must enter the proper starting BTC value or it can not calculate properly.

Nobody said anything about the SUM of the entire "Total Profit (%)" column.   (Don't do that)
Each cel of "Total Profit (%)" as it was at that exact moment in time (when the script ran).

I also recommend AltPocket for FREE tracking via API.  And you can manually enter trades at AltPocket  if you want to.

If you want to track all Bittrex trades since day one you will need to login to Bittrex and download the .CSV of all trades.

Can I use the same API for airpocket that I am using for your sheet?
Also, unless I'm missing something, the Bittrex .CSV file is missing the most important columns for totals, etc..

Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #84 on: November 21, 2017, 06:23:57 AM »
Can I use the same API for airpocket that I am using for your sheet?
Also, unless I'm missing something, the Bittrex .CSV file is missing the most important columns for totals, etc..

You can re-use the same API but it's never a really good idea to re-use the API .  They're free to make.  I use a unique API key for each project and it keeps me from having rate limiting problems by the exchange.  Use that API key too often and you may potentially get rate limited by Bittrex.

As for the Bittrex .CSV file -- that's a whole different discussion.

PM me if you'd like.

Obviously it isn't as easy as slapping your API key into a free tracking sheet to accomplish what you want to do. 

I suggest you look at the CoinTracking trial.  It gave me a LOT of insight in the first few days of running GunBot v3.3.2
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline cryptologist

  • Trust: (0)
  • Rookie
  • *
  • Posts: 28
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #85 on: November 22, 2017, 05:35:08 PM »
Cool! Where do I change the code to reflect my local time? GMT-5? Is that possible? Thanks!

OK.  I've made comments to the code that should help.
Get into the Script Editor via Tools --> Script Editor

Look for the time variable near line 251 and change it to your time zone.  No spaces.
Remember to Save when you're done.

I'm assuming I need to change it in both places (line 247 and 249 in the pic). Does this photo of my settings look correct?
 



Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #86 on: November 22, 2017, 11:56:45 PM »
If you ran it and it works fine for you then it's good.

I'd recommend you change ONLY the "+2" portion to your timezone.  Leave "GMT". 

i.e. "GMT-8" in the winter and "GMT-7" in the summer.
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #87 on: November 24, 2017, 11:33:32 PM »
Three cheers for the return of br41nbug!   Missed ya, buddy!   Glad you're back in the GunBot life.  8)
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline majorlee

  • Trust: (0)
  • Rookie
  • *
  • Posts: 17
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #88 on: December 09, 2017, 10:40:35 PM »
is it still free? requested access

Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #89 on: December 10, 2017, 03:05:15 AM »
Don't request access to the Google Sheet.

Follow the instructions and make a copy to your own Google Drive.

You don't want to be entering in your API key details into a Google Sheet that is controlled by someone else.  :o

You need to make a copy of the Google Sheet.
« Last Edit: December 10, 2017, 03:25:26 AM by cryptosticks »
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline franckysable

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #90 on: December 31, 2017, 12:08:42 AM »
first, i'd like to thank you, i did something like that on my days but quite buggy and left it die, yours is really clean and i do am grteful that it is for free too.

If i may suggest for the later versions some ideas :
- a way to refresh the cointabs for all the tabs(the "get order details" on each tab) at once
- sort of a resume for each coin in the hourly tab
something like this for example

Coin - average percentage - actual holdings
btc  - 8.2% - 18,9btc
neo - 0.34% - 202 neo
Omg - -38% - 0 omg


and probably a chart based on that table showing you on x the value in btc hold by the coin and on the y the coin name, and why not the logo with it  ;)

those are just suggestion of course  thx again from france

Offline Daisy

  • Trust: (0)
  • Rookie
  • *
  • Posts: 12
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #91 on: January 04, 2018, 06:32:20 AM »
How should I deal with deposits into the active Bittrex account? It throws off all the profit calculations when the balance changes due to the deposit.

Offline Whipz

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #92 on: January 06, 2018, 12:43:22 AM »
Are you able to make the same thing for Binance ? 0.o

Offline cochise

  • Trust: (0)
  • Rookie
  • *
  • Posts: 4
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #93 on: January 18, 2018, 08:14:15 AM »
Hi,

I was using the v0.4.1 since new year and everything works great. But since the 14.01 it's stop updating the first page (hourly logs). Even if i press the manual update it's not working. The Order book update, no problem, but nothing on the hourly logs....
Something change on bittrex ? Is yours still works ?

Offline dangthanh

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #94 on: February 24, 2018, 09:54:34 AM »
I get the error in line 74

Offline cash gordon

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #95 on: April 11, 2018, 10:00:23 PM »
Hey Guys, thanx for sharing this awesome spreadsheet. Happily using it since January.

Unfortunately I ve got a bug since two days. The Sheet doesnt update (clicking manual update) and gives following error message:

Bad request: https://bittrex.com/api/v1.1/public/getticker?apikey=11111111111111111111&nonce=111111111111&market=BTC-ADA

error occours when clicking manual update on hourly log, order book and all other coin sheets.
ADA is still listed and working, so thats not the issue.

can someone please help me?

Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #96 on: April 12, 2018, 02:04:59 AM »
Maybe your coins havenít been traded for 30 days?  Bittrex stops handing trading data via their API after 30 days.

PM me.
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit

Offline jackfalcun

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #97 on: April 21, 2018, 03:09:00 AM »
is this still available?

Offline cryptosticks

  • Reseller
  • Trust: (+99)
  • Contributor
  • *****
  • Posts: 238
  • Authorized reseller, Escrow and API swap
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [FREE] Tracking Spreadsheet for BITTREX
« Reply #98 on: April 21, 2018, 03:19:16 AM »
This free sheet isnít currently not supported at the moment.  Iíve moved on to other things and donít have time for troubleshooting.

I recommend using a Telegram trading notification bot like CryptoSight (paid) or a free tracking website like AltPocket.io

I also recommend a great smartphone app (free) called Coin Stats.
APPROVED GunBot API swap @ 0.01 BTC ..:..  APPROVED Escrow for 2nd hand GunBot licenses @ 7.5%
UNOFFICIAL GunBot Help website: because officially I donít know shit