Username: Password:

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

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...