Username: Password:

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

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