Username: Password:

Author Topic: [FREE] Tracking Spreadsheet for BITTREX  (Read 30965 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: 240
  • 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: 240
  • 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: 240
  • 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: 240
  • 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: 240
  • 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.