Username: Password:

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

Offline br41nbug

  • Trust: (+2)
  • Rookie
  • *
  • Posts: 7
    • View Profile
[FREE] Tracking Spreadsheet for BITTREX
« on: September 08, 2017, 03:24:07 PM »
 :o
« Last Edit: March 05, 2018, 09:14:30 AM by br41nbug »

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #1 on: September 08, 2017, 04:01:25 PM »
Thanks for your work on this!

And thanks for sharing.  I'll check it out.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline martybit

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #2 on: September 08, 2017, 09:18:22 PM »
Im probably dense but Im getting an error that says Cannot call method foreach of null. Most likely i am doing something wrong so just to clarify o believe i need to fill in the first 3 columns like this :


09/08/2017   16:00   0.01294335

sorry a tad confused - ill check the code as well and see if i can figure out what its looking for.

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #3 on: September 09, 2017, 12:01:43 AM »
WORKING FOR ME
Thank you for sharing, br41nbug.

Im probably dense but Im getting an error that says Cannot call method foreach of null. Most likely i am doing something wrong so just to clarify o believe i need to fill in the first 3 columns like this :


09/08/2017   16:00   0.01294335

sorry a tad confused - ill check the code as well and see if i can figure out what its looking for.

Did you click the "KEYS" tab on the bottom and add your API key?  There are two tabs on the bottom of the Google Sheet: "HOURLY LOG" and "KEYS".


NOTE: before I could get the script to execute the first time I received a warning from Google --
Code: [Select]
Hourly update wants to
View and manage your spreadsheets in Google DriveMore info
Connect to an external serviceMore info

Allow Hourly update to do this?
By clicking Allow, you allow this app to use your information in accordance to their terms of service and privacy policies. You can remove this or any other app connected to your account in My Account
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline daihashi

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #4 on: September 09, 2017, 04:35:23 PM »
Excellent, you saved me the hassle of re-writing this for bittrex. This is a nice simple tracker for those who are only interested in their overall profits, and not profit/loss for individual trades.

Great job.

Offline fzsombor

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #5 on: September 09, 2017, 05:18:34 PM »
Bug here:

If you trade in USDT markets, it cannot properly get the data from api, because market called USDT-BTC instead of BTC-USDT.




Offline marko.kodelja

  • Trust: (0)
  • Rookie
  • *
  • Posts: 3
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #6 on: September 11, 2017, 09:16:29 AM »
hello.
I can only view the spreadsheet. How to edit?
Thanks.

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #7 on: September 11, 2017, 09:25:06 AM »
hello.
I can only view the spreadsheet. How to edit?
Thanks.

To edit you need to make a copy. Once a copy is on your Google Drive then you can make changes.
« Last Edit: September 12, 2017, 06:36:27 AM by cryptosticks »
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline dyvosvit

  • Trust: (+1)
  • Novice
  • *
  • Posts: 31
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #8 on: September 11, 2017, 10:29:41 AM »
TypeError: Cannot read property "Last" from null. (line 19, file "Code")
....  ?

Offline falconCoin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 20
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #9 on: September 12, 2017, 05:21:38 AM »
TypeError: Cannot read property "Last" from null. (line 19, file "Code")
....  ?

im getting same error as above

Offline Tom12coin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 13
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #10 on: September 12, 2017, 08:25:05 AM »
Which review u want? :D

Put your keys inside, click on update and then you will see your balance and the profit is calculated with your starting balance.
As simple as that :)

Offline Jstaples2

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #11 on: September 12, 2017, 07:41:38 PM »
Anyone figure out how to get around the TypeError: Cannot read property "Last" from null error?

I'm wondering if the new API key I setup from Bittrex is the issue, but I tried both a fresh API key and an existing one with no luck.

Offline dyvosvit

  • Trust: (+1)
  • Novice
  • *
  • Posts: 31
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #12 on: September 12, 2017, 09:31:54 PM »
TypeError: Cannot read property "Last" from null. (line 19, file "Code")
....  ?

im getting same error as above

Still getting the error ...
Polo runs fine ... but Bittrex .... just don't

Offline Jonesy

  • Trust: (0)
  • Rookie
  • *
  • Posts: 3
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #13 on: September 13, 2017, 07:25:16 AM »
TypeError: Cannot read property "Last" from null. (line 19, file "Code")
....  ?
If you go to Tools - Script Editor
change line 19 to 
Code: [Select]
    var results = bittrexPublicRequest("getticker",payload);It should work
I can't get mine to work as I converted BTC-USDT but there isnt a market for it in the api.

Offline dyvosvit

  • Trust: (+1)
  • Novice
  • *
  • Posts: 31
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #14 on: September 13, 2017, 08:40:12 AM »
TypeError: Cannot read property "Last" from null. (line 19, file "Code")
....  ?
If you go to Tools - Script Editor
change line 19 to 
Code: [Select]
    var results = bittrexPublicRequest("getticker",payload);It should work
I can't get mine to work as I converted BTC-USDT but there isnt a market for it in the api.

thx for feedback ...



still the same

Offline falconCoin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 20
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #15 on: September 13, 2017, 08:18:05 PM »
yep still getting the same error  too

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #16 on: September 13, 2017, 10:45:52 PM »
Also the same error here.

The same copy is running perfectly with my other bittrex account.

See attached screenshot of the error...
« Last Edit: September 13, 2017, 10:57:43 PM by nAffie »

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #17 on: September 14, 2017, 04:32:55 AM »
Maybe br41nbug made a change to the Google Sheet since it was originally shared?

My two instances of the Bittrex tracking spreadsheet are working fine.  Every hour on the hour.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #18 on: September 14, 2017, 07:56:46 AM »
Thanks!  I wasn't having any problems with your original v0.1 but I decided get your newer version.

I replaced the original two (2) FreeBittrexTrackingCharts with the newer v0.2.  Both of my FreeBittrexTrackingCharts_v0.2 Google Sheets are running fine: one for BTC pairs, and one for ETH pairs. Great work.

APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #19 on: September 14, 2017, 10:35:33 PM »
Now I'm having the same error in the spreadsheet for my 2nd Bittrex account. This was working perfectly since last saturday.

I tried V2, but after the Google authorization and pressing Manual update, it gives out the same error: TypeError: Cannot read property "Last" from null.

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #20 on: September 14, 2017, 11:24:23 PM »
unfortunately I get the same error.

I don't get it, it ran perfectly for a couple of days, and it suddenly stopped working on 2 accounts, and not even at the same time.

Also I checked the value in the hidden sheet and it contained =SUM(E:E)

« Last Edit: September 14, 2017, 11:29:52 PM by nAffie »

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #21 on: September 15, 2017, 01:36:48 AM »
do you have usdt in your account? it seems, that it runs into an error getting the price of a currency pair bittrex doesnt know.
the sheet constructs the pair with "BTC+'altcoin'". by now it can only be used to monitor pairs with BTC as base.

Now that you mentioned that, I did create USDT wallets this week on Bittrex... Is there any way to delete or discard those wallets?

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #22 on: September 15, 2017, 10:16:47 AM »
I updated the v0.2 sheet!!!


+ total profit % is copied down with each new entrty
+ total profit % was fixed!



Please note, that the older sheets will make invalid total % calculations.

NOTE: the new v0.2 version is not working for me.  It pulls in all zeros (0).  The first version of the v0.1 and v0.2 worked (if you updated/changed v0.2 that's when the problem happened for me).
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline olli84

  • Trust: (0)
  • Rookie
  • *
  • Posts: 5
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #23 on: September 15, 2017, 03:32:48 PM »
Hey there,

your sheet is excellent - thanks for your hard work!

Is it possible to integrate the order book?

Thanks,
Olli

Offline falconCoin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 20
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #24 on: September 16, 2017, 12:24:11 AM »
i continue to get the this error

Service invoked too many times for one day: urlfetch. (line 69, file "Code")

Offline dyvosvit

  • Trust: (+1)
  • Novice
  • *
  • Posts: 31
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #25 on: September 16, 2017, 12:35:32 AM »
TypeError: Cannot read property "Last" from null. (line 19, file "Code")
....  ?
If you go to Tools - Script Editor
change line 19 to 
Code: [Select]
    var results = bittrexPublicRequest("getticker",payload);It should work
I can't get mine to work as I converted BTC-USDT but there isnt a market for it in the api.

thx for feedback ...



still the same


So ... debugging the sript found some solution/patch for those having the same error as me:
change this piece of code
  function bittrexGetlastprice(market) {
    var payload = { "market" : market };
    var results = bittrexPublicRequest("getticker",payload);
    if (results != null) {
    return results.Last;
    }
    else{
      return 0;
    }
  };

for some reason Trex returns null for me here on random coins (like GUP) so patched it a little bit,
and it started working for me ....
UPD: but returning wrong balance .....
UPD UPD: because this balance is on orders and does not go into total BTC balance ...
need fix for that ^^^^
upd upd upd: cancelling open orders didn't help ... =(
« Last Edit: September 16, 2017, 12:54:23 AM by dyvosvit »

Offline olli84

  • Trust: (0)
  • Rookie
  • *
  • Posts: 5
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #26 on: September 16, 2017, 04:28:53 PM »
Thanks a lot! :)

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #27 on: September 17, 2017, 05:21:48 AM »
Wonderful!  The order book functionality is sweet!

Thanks!
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline falconCoin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 20
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #28 on: September 18, 2017, 06:19:14 AM »
what is strange is the order book works  but i  am still getting that weird error

TypeError: Cannot read property "Last" from null.

Offline Tom12coin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 13
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #29 on: September 18, 2017, 07:02:17 AM »
Script is also not working for me anymore.

The only "change" from my side:

now pairs in ETH-x and
USDT dust (i am not able to get rid of it)

I am pretty sure, one of this is the reason, why it stop working.

Code: [Select]
TypeError: Cannot read property "Last" from null. (Zeile 19, Datei "Code")
« Last Edit: September 18, 2017, 05:07:45 PM by Tom12coin »

Offline davidasaur

  • Trust: (0)
  • Rookie
  • *
  • Posts: 17
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #30 on: September 18, 2017, 04:57:36 PM »
Greet document.  Thanks for putting this together!

Offline AI

  • Trust: (0)
  • Rookie
  • *
  • Posts: 21
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #31 on: September 18, 2017, 06:36:06 PM »
Do you have to have the spreadsheet open to make it work or will it also run this when the spreadsheet is closed?

Offline christye

  • Trust: (0)
  • Rookie
  • *
  • Posts: 25
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #32 on: September 18, 2017, 10:38:32 PM »
Do you have to have the spreadsheet open to make it work or will it also run this when the spreadsheet is closed?

It'll run when closed.
BTC: 14JMYDM15XkfyEJHaY7KmuU6yooxXrSWHJ
ETH: 0xf577a29C77223B619c7dA42B8F38c20113427CDC

Offline falconCoin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 20
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #33 on: September 19, 2017, 12:43:14 AM »
no matter how many times i try i can NOT get rid of the USDT Dust either

is that why we are getting that error?

Offline AI

  • Trust: (0)
  • Rookie
  • *
  • Posts: 21
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #34 on: September 19, 2017, 05:56:15 AM »
Is there a way to stop the script and can I delete the lines to start fresh?

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #35 on: September 19, 2017, 06:05:29 AM »
If you want to clear everything just delete all ROWS except 1 and 2.

i.e. delete rows 3-?? and then you can run the script again.

Remember to put your starting BTC amount in cell "C2" before you click MANUAL UPDATE.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline Xaos

  • Trust: (0)
  • Rookie
  • *
  • Posts: 14
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #36 on: September 19, 2017, 09:48:01 AM »


Bittrex

Offline AI

  • Trust: (0)
  • Rookie
  • *
  • Posts: 21
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #37 on: September 19, 2017, 01:46:14 PM »
If you want to clear everything just delete all ROWS except 1 and 2.

i.e. delete rows 3-?? and then you can run the script again.

Remember to put your starting BTC amount in cell "C2" before you click MANUAL UPDATE.

Do I need to stop the script first or can I just go ahead and
Delete te rows?

Thanks for the awesome file btw. Works like a charm!


Offline Xaos

  • Trust: (0)
  • Rookie
  • *
  • Posts: 14
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #38 on: September 19, 2017, 02:24:41 PM »
anyone got it working on bittrex?

Offline toomeke

  • Trust: (0)
  • Rookie
  • *
  • Posts: 7
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #39 on: September 19, 2017, 02:52:12 PM »
Ok so I input my total BTC wallet value or actual BTC value of BTC only?
How much moola you makin? Get 10% off Cointracker NOW...it totally makes sense of your trading portfolio!
https://cointracking.info?ref=T684304

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #40 on: September 19, 2017, 04:29:05 PM »
AI: No, you don't have to stop the script.  Just delete the rows 3-?? and the script will populate everything again.

Xaos:  Yes.  I'm only using it on Bittrex myself.  Two different accounts.

toomeke: You put in the total amount estimated BTC that Bittrex shows you.  Not only your BTC wallet holdings.


Note: I didn't write the script, br41nbug did.  I'm just trying to help out.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline Tom12coin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 13
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #41 on: September 19, 2017, 08:08:39 PM »
The order book part is a great feature (ok, i wouldnt use it and would stay with the V2), but if its not working with USDT its sadly not helping.

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #42 on: September 20, 2017, 09:20:41 PM »
thx for helping out answering the questions. i got very little time these days, so im glad you doin it!

and to all, yes if you have a USDT balance, no matter if its much or just dust, the script will fail due to some hardcoded logic i put in. could be made another way.. maybe ill do so in future version. focus was to get the order book import working, so you can do tracking of bot/pair performance for the last day(s). by now limited to the last 200 trades.

Please try to fix this in a future release! I still use the sheet, but now I have to copy/paste the estimated value and the formula by hand for each row.

I'll be glad to donate some beer money if you get this bug squashed... ;)

Offline toomeke

  • Trust: (0)
  • Rookie
  • *
  • Posts: 7
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #43 on: September 21, 2017, 01:29:45 PM »
Awesome stuff! how to I change the timestamp to match my local?
How much moola you makin? Get 10% off Cointracker NOW...it totally makes sense of your trading portfolio!
https://cointracking.info?ref=T684304

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #44 on: September 21, 2017, 10:21:03 PM »
Awesome stuff! how to I change the timestamp to match my local?

Go to the script editor, find GMT and change both values to your timezone. Save the script, done!



Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #45 on: September 22, 2017, 05:17:15 AM »
Go to the script editor, find GMT and change both values to your timezone. Save the script, done!

Thanks nAffie.  It works great.  Nice.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline AI

  • Trust: (0)
  • Rookie
  • *
  • Posts: 21
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #46 on: September 22, 2017, 08:42:54 AM »
Hey there.
The hourly page is working perfectly for me but the orders sheet doesn't do anything.

Any idea how this could be fixed? 

Offline Fozzzy

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #47 on: September 22, 2017, 11:34:04 AM »
 :-[

I have a Bug ( Invalid argument key )

Created new keys.
Still does not work.

Help me please.

Offline arttus

  • Trust: (0)
  • Rookie
  • *
  • Posts: 6
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #48 on: September 22, 2017, 05:01:37 PM »
Awesome FREE tool!

You think it could be adapted to work for Polo, or is their API to rate limited?

I suppose instead of pulling the last 200 items every hour, you could just pull the new items every 5 or 15 minutes.

Offline tekspirit

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #49 on: September 22, 2017, 06:29:02 PM »
I just made a copy and ran it today, entering my key and secret and running it manually, and the error I see is
TypeError: Cannot read property "Last" from null.DetailsDismiss
This is with version title:
FREE BITTREX Import & Track v0.3

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #50 on: September 22, 2017, 07:56:48 PM »
Awesome FREE tool!

You think it could be adapted to work for Polo, or is their API to rate limited?

I suppose instead of pulling the last 200 items every hour, you could just pull the new items every 5 or 15 minutes.

For Polo see: https://gunthy.org/index.php/topic,1124.0.html

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #51 on: September 23, 2017, 12:20:38 AM »
I just made a copy and ran it today, entering my key and secret and running it manually, and the error I see is
TypeError: Cannot read property "Last" from null.DetailsDismiss
This is with version title:
FREE BITTREX Import & Track v0.3

I made a little change to the balances logic. if anyone that has USDT in his trex wallet wants to try if this is already the solution, here is the link:

https://docs.google.com/spreadsheets/d/1vvey81TlWDL7Ivc6ZUaSzpL4r4MmO0kiVwySNMFKh6w/edit?usp=sharing

this is just a quick idea, feedback is highly appreciated.


I don't get the error anymore, but calculations are way off....
And it takes couple of minutes to update the sheet.

Edit: after some back and forth messaging on telegram, br41nbug fixed the issues, my sheet is updating again!
« Last Edit: September 23, 2017, 01:21:58 PM by nAffie »

Offline Tom12coin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 13
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #52 on: September 23, 2017, 11:22:19 AM »
Quote
I made a little change to the balances logic. if anyone that has USDT in his trex wallet wants to try if this is already the solution, here is the link:

this is just a quick idea, feedback is highly appreciated.

Works perfect, thanks a lot.

If its only few lines change, could you tell me them please (or update the v2), i would like to use the version without the orderbook (dont need/want)

Offline Tom12coin

  • Trust: (0)
  • Rookie
  • *
  • Posts: 13
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #53 on: September 23, 2017, 12:41:41 PM »
Makes no difference...comment out / delete the line, order books is still updating...

Doenst matter, I was just trying to use lesser Bittrex ressources :)

Offline SelevanM

  • Trust: (0)
  • Rookie
  • *
  • Posts: 6
    • View Profile
  • Telegram: @SelevanM
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #54 on: September 26, 2017, 06:14:32 AM »
I had some USDT dust in my account that was causing '...cannot read property "Last" from null'.  I just put a catch in to eat the USDT-BTC pair.  If you actually have USDT in your account (higher than a dusting) this will cause your balances to be off.  But at least if you have dust the sheet will work again without that error.

My mission is to help 10 people become financially free and improve their life in the next year. And 10 more people every year for the next 10 years.

Offline koltregaskes

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #55 on: October 01, 2017, 05:36:23 PM »
I'm trying to set this sheet up but I'm getting a "We're sorry, a server error occurred.  Please wait a bit and try again." when setting up the time-drive hourly timer trigger  I've been waiting hours.

Any ideas?

Offline eMadman

  • Trust: (0)
  • Rookie
  • *
  • Posts: 4
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #56 on: October 03, 2017, 04:38:54 PM »
I'm trying to set this sheet up but I'm getting a "We're sorry, a server error occurred.  Please wait a bit and try again." when setting up the time-drive hourly timer trigger  I've been waiting hours.

Any ideas?
I had the same problem earlier this week and I've finally figured it out.  The script needs permission to run and Google Docs isn't notifying us of that.  Do this:

Click the Run button on the toolbar and wait a minute or two.  Follow the prompts and give the script approval to run on your account.  Once you've given it permission, it will run.  Now you can set up the hourly schedule and it should behave as expected.

I didn't take screenshots, but be aware that google will hide one of the approval options below a bunch of clicks for security reasons.  If you have any coding knowledge, I strongly advise you to read/review the script yourself before granting permission (this should go for any script that has access to your docs!)

Offline koltregaskes

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #57 on: October 04, 2017, 01:56:48 PM »
I had the same problem earlier this week and I've finally figured it out.  The script needs permission to run and Google Docs isn't notifying us of that.  Do this:

Click the Run button on the toolbar and wait a minute or two.  Follow the prompts and give the script approval to run on your account.  Once you've given it permission, it will run.  Now you can set up the hourly schedule and it should behave as expected.

I didn't take screenshots, but be aware that google will hide one of the approval options below a bunch of clicks for security reasons.  If you have any coding knowledge, I strongly advise you to read/review the script yourself before granting permission (this should go for any script that has access to your docs!)

That worked, thank you very much.

Offline thenerd22

  • Trust: (0)
  • Rookie
  • *
  • Posts: 1
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #58 on: October 06, 2017, 04:53:42 PM »
I keep getting "Invalid Argument: Key". Created new api key and secret key and still nada :(
I'm not sure what i'm doing wrong

Offline n30n_p3ngu1n

  • Trust: (0)
  • Rookie
  • *
  • Posts: 3
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #59 on: October 18, 2017, 12:40:26 AM »
Still getting the error: "TypeError: Cannot read property "Last" from null."

I've ignored USDT pairs in the code...

Offline nAffie

  • Trust: (0)
  • Rookie
  • *
  • Posts: 9
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #60 on: October 19, 2017, 08:50:15 AM »
Maybe something changed in the Bittrex API, because I'm getting the error also again on both my sheets... :(

Was working fine till 14-oct-2017.

Offline miwi

  • Trust: (0)
  • Rookie
  • *
  • Posts: 8
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #61 on: October 19, 2017, 04:24:29 PM »
confirmed stop working for me too.

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #62 on: October 23, 2017, 12:09:38 AM »
Yes.  It definitely has stopped working.  It appears to be a Bittrex API issue.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
[FIXED] Free Import & Track Spreadsheet for BITTREX v0.3.3 - PART 1
« Reply #63 on: October 23, 2017, 11:40:04 AM »
[FIXED] FREE BITTREX Import & Track v0.3.3



Hello true believers.  I present to you:  the new and improved FREE BITTREX Import & Track v0.3.3

Not only does it work.... (yay!) it also has a new function called "doNotUseOrderBook".
When you click the button "Without Order Book" or run it as a project trigger (an hourly or whatever) the Order Book won't update.
The Order Book was slowing down the Google Sheet... and I didn't always find I wanted or needed the Order Book.  So it's now an optional feature.

FULL DISCLOSURE --
  This was started and maintained by others.
  Thank you, br41nbug!
  This is my contribution.  I give it to the community.

http://free-bittrex-sheet.Gunbot-Escrow.com
The above link re-directs to the shared Google Sheet.   

Enjoy this FREE Google Sheet.  This is not a paid Google Sheet.
Please don't Telegram message me about the sheet.

If you start gettings errors because you're trading stuff I don't (like USDT) please do some troubleshooting yourself.
::)

Steps 1-4 below (in annotated screenshot format)

IF YOU CAN NOT SEE THE SCREENSHOTS (ATTACHMENTS) BELOW PLEASE LOGIN!!

« Last Edit: December 01, 2017, 06:49:32 AM by cryptosticks »
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
[FIXED] Free Import & Track Spreadsheet for BITTREX v0.3.3 - PART 2
« Reply #64 on: October 24, 2017, 04:59:26 AM »
Steps 5-7 (in annotated screenshot format)

IF YOU CAN NOT SEE THE SCREENSHOTS (ATTACHMENTS) BELOW PLEASE LOGIN!!
« Last Edit: December 01, 2017, 06:54:40 AM by cryptosticks »
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline AI

  • Trust: (0)
  • Rookie
  • *
  • Posts: 21
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #65 on: October 24, 2017, 08:58:07 PM »
Hey man, is it possible the trades tab is deleting lines?

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #66 on: October 25, 2017, 12:55:15 AM »
Hey man, is it possible the trades tab is deleting lines?

I'm not sure I understand the question.

You mean the Order Book?   Deleting lines?  Well, anything is possible so I won't say "no".  But it's pulling the order book from Bittrex API direct... which means that it should be showing whatever Bittrex will send via API.  There may be a limit to what Bittrex will hand out over their API?

***

Or were you asking if it is possible for you to manually delete the rows in the Google Sheet for the Order Book (you called trade tabs)?
You can delete the lines manually from your Order Book if you want.
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline robert1robert

  • Trust: (0)
  • Rookie
  • *
  • Posts: 4
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #67 on: October 25, 2017, 01:54:19 AM »
I don't see any Steps 1-5 "in annotated screenshot format" in this post after the Oct 23rd update.

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #68 on: October 25, 2017, 03:11:02 AM »
IF YOU CAN NOT SEE THE SCREENSHOTS (ATTACHMENTS) PLEASE LOGIN!!
The Gunthy forum requires users to be logged in to have access to attachments.

Part 1  Steps 1-4
https://gunthy.org/forum/index.php/topic,1248.msg8751.html#msg8751

Part 2  Steps 5-7
https://gunthy.org/forum/index.php/topic,1248.msg8773.html#msg8773

There is a Gunthy Forum limit of attaching four (4) items per post.  I had to make two posts to attach the annotated screenshots.
« Last Edit: December 09, 2017, 03:51:54 AM by cryptosticks »
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline vertygo

  • Trust: (0)
  • Rookie
  • *
  • Posts: 8
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #69 on: October 27, 2017, 04:51:17 PM »
I'm getting "TypeError: Cannot call method "forEach" of null. Details Dismiss" error. Anyone else ? I don't have usdt or eth dust.

Offline suparub

  • Trust: (+1)
  • Rookie
  • *
  • Posts: 5
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #70 on: October 27, 2017, 05:43:21 PM »
Same here, I realized there must be something wrong with the Bittrex api function as the URL gives :

{"success":false,"message":"APISIGN_NOT_PROVIDED","result":null}

Offline vertygo

  • Trust: (0)
  • Rookie
  • *
  • Posts: 8
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #71 on: October 29, 2017, 11:34:58 PM »
Has anyone been in touch with brainbug ?

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #72 on: November 03, 2017, 02:55:09 AM »
I sent him a message or two.  Maybe we'll see him again someday.  :)

I'm not seeing errors myself.  Someone want to share their API key & secret?  (Read only permissions)
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline KingMeUp

  • Trust: (0)
  • Rookie
  • *
  • Posts: 3
    • View Profile
Re: [FIXED] Free Import & Track Spreadsheet for BITTREX v0.3.3 - PART 1
« Reply #73 on: November 08, 2017, 05:51:40 AM »
[FIXED] FREE BITTREX Import & Track v0.3.3



Hello true believers.  I present to you:  the new and improved FREE BITTREX Import & Track v0.3.3

Not only does it work.... (yay!) it also has a new function called "doNotUseOrderBook".
When you click the button "Without Order Book" or run it as a project trigger (an hourly or whatever) the Order Book won't update.
The Order Book was slowing down the Google Sheet... and I didn't always find I wanted or needed the Order Book.  So it's now an optional feature.

FULL DISCLOSURE --
  This was started and maintained by others.
  Thank you, br41nbug!
  This is my contribution.  I give it to the community.

http://free-bittrex-sheet.Gunbot-Escrow.com
The above link re-directs to the shared Google Sheet.   

Enjoy this FREE Google Sheet.  This is not a paid Google Sheet.
Please don't Telegram message me about the sheet.

If you start gettings errors because you're trading stuff I don't (like USDT) please do some troubleshooting yourself.
::)

Steps 1-4 below (in annotated screenshot format)

I get error on line 90

Offline cryptologist

  • Trust: (0)
  • Rookie
  • *
  • Posts: 28
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #74 on: November 17, 2017, 10:08:12 PM »
Hello,
I followed the directions exactly and it works when I run the log.

My question is:
Is it supposed to be updating every hour by itself if I leave the browser window open? Or do I need to run the log every time I want an update?

Please and thank you.

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #75 on: November 18, 2017, 05:23:43 AM »
IF YOU CAN NOT SEE THE SCREENSHOTS (ATTACHMENTS) BELOW PLEASE LOGIN!!

Google will run the script depending how you set the Current Project's Triggers

From
Step 4 - Tools -> Script Editor

click on Current Projects Triggers icon <-- looks  like a timer/clock
« Last Edit: December 01, 2017, 06:56:21 AM by cryptosticks »
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline rrauscher

  • Trust: (0)
  • Rookie
  • *
  • Posts: 2
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #76 on: November 20, 2017, 02:33:33 AM »
Cool! Where do I change the code to reflect my local time? GMT-5? Is that possible? Thanks!

Offline cryptologist

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

Yes. This please.

Offline cryptologist

  • Trust: (0)
  • Rookie
  • *
  • Posts: 28
    • View Profile
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #78 on: November 21, 2017, 01:53:47 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??


Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • View Profile
    • GunBot-Escrow.com
  • Telegram: cryptosticks
Re: [Free] Tracking Spreadsheet for BITTREX
« Reply #79 on: November 21, 2017, 02:21:49 AM »
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.

IF YOU CAN NOT SEE THE SCREENSHOT (ATTACHMENT) BELOW PLEASE LOGIN!!
« Last Edit: December 01, 2017, 06:57:37 AM by cryptosticks »
APPROVED Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

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: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

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: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

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: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

Offline cryptosticks

  • Reseller
  • Trust: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

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: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

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: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca

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: (+113)
  • Contributor
  • *****
  • Posts: 239
  • Authorized reseller + Gunbot-Escrow.com
    • 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 Escrow for 2nd hand GunBot licenses
..:.. GunBot-Escrow.com BTC wallet ** Protect Yourself From Scammers ..:..
3Gdhma4dPXMQxAvxVqWXGhb7V3TG2NrYca