Bitcoin Forum
November 05, 2024, 04:28:17 PM *
News: Latest Bitcoin Core release: 28.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 2 3 4 5 6 [7]  All
  Print  
Author Topic: deleted  (Read 14686 times)
mgkha
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
December 14, 2017, 12:37:41 PM
 #121

Hey,

first.. Thank you very much for this awesome sheet!
I've been looking quite a while for something like this to track my trades easily.

I'm using the Bittrex version and there seems to be an error.
I can import the data file but when I click on the blue USDT-BTC at the left to show the graph an error appaears with "Runtime error 13. Type mismatch"
When clicking on debug it sends me to this line of code:

Quote
Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value

How can I solve this problem?
The "tradeHistory" sheet is empty aswell.
guesswho1234 (OP)
Full Member
***
Offline Offline

Activity: 155
Merit: 100


View Profile
December 14, 2017, 05:18:47 PM
 #122

Hey,

first.. Thank you very much for this awesome sheet!
I've been looking quite a while for something like this to track my trades easily.

I'm using the Bittrex version and there seems to be an error.
I can import the data file but when I click on the blue USDT-BTC at the left to show the graph an error appaears with "Runtime error 13. Type mismatch"
When clicking on debug it sends me to this line of code:

Quote
Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value

How can I solve this problem?
The "tradeHistory" sheet is empty aswell.
its always really hard to tell. maybe add me on skype and i see what i can do for you Wink
guesswho1234 (OP)
Full Member
***
Offline Offline

Activity: 155
Merit: 100


View Profile
December 19, 2017, 08:28:14 PM
 #123

UPDATE: DOWNLOAD IN OP

  • bugfix for the bittrex version (its important that you use the fullOrders.csv export from bittrex for the new version of the spreadsheet!)
Pages: « 1 2 3 4 5 6 [7]  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!