deleted - page 2. | Bitcointalksearch.org

jkminkov

hero member

Activity: 698

Merit: 500

Code:

Currency,Rate,Amount,Duration,Interest,Fee,Earned,Open,Close
BTC,0.00010000,0.07106024,2.00021990,0.00001421,-0.00000213,0.00001208,2017-08-14 11:33:14,2017-08-16 11:33:33
BTC,0.00009900,0.00938091,0.86952546,0.00000080,-0.00000012,0.00000068,2017-08-15 14:30:07,2017-08-16 11:22:14
XRP,0.00000200,34901.23867793,2.00075231,0.13965746,-0.02094861,0.11870885,2017-02-26 16:57:47,2017-02-28 16:58:52
XMR,0.00024700,0.60623248,2.00077546,0.00029958,-0.00004493,0.00025465,2017-02-26 11:52:07,2017-02-28 11:53:14
ETH,0.00006100,0.00100284,0.00013888,0.00000001,0.00000000,0.00000001,2017-01-02 10:04:51,2017-01-02 10:05:03
DOGE,0.00440000,5939.00995445,2.00047453,52.27568783,-7.84135317,44.43433466,2017-04-23 12:59:54,2017-04-25 13:00:35

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: jkminkov on August 16, 2017, 09:22:12 AM

can you expand to do list with prossessing lendingHistory.csv with some stats?

i will think about it Wink

if you can send me some sample data that would be nice since i dont do lending on poloniex.

greetings

jkminkov

hero member

Activity: 698

Merit: 500

can you expand to do list with prossessing lendingHistory.csv with some stats?

dobcrypto

full member

Activity: 263

Merit: 101

Authorized Gunbot reseller > gunbot.vip

Wery cool Spreadsheet, many thx!

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: utdrmac on August 03, 2017, 02:30:11 PM

Any chance of this ever working with Google Sheets? I don't have MSExcel.

i already tried that with no good outcome tho.

im sorry

greetings

p3ppymon

sr. member

Activity: 700

Merit: 254

Quote from: utdrmac on August 03, 2017, 02:30:11 PM

Any chance of this ever working with Google Sheets? I don't have MSExcel.

I do not think so as the online version is quite limited.

utdrmac

jr. member

Activity: 34

Merit: 1

Any chance of this ever working with Google Sheets? I don't have MSExcel.

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: CreativeHitez on July 23, 2017, 01:23:50 PM

I was able to upload my order history on Bittrex and upon pressing start I received an error:

Code:

Run-time error '9': Subscript out of range

Code:

While r_next
If Worksheets(sheetTHId).Cells(r, 1).Value <> "" Then
>If Split(Worksheets(sheetTHId).Cells(r, 3).Value, "-")(0) = basemarket Then

hmm hard to pin point what went wrong here.

if you dont mind me seeing your data you can send it do me and i will see what i can do for you.

otherwise i can offer skype / teamviewer.

just pmme Wink

Quote from: CreativeHitez on July 23, 2017, 01:23:50 PM

I admire your generosity, doing this for free... Thank you.

my pleasure! the more people profit from it the better!

greetings

CreativeHitez

newbie

Activity: 5

Merit: 0

I was able to upload my order history on Bittrex and upon pressing start I received an error:

Code:

Run-time error '9': Subscript out of range

Code:

While r_next
If Worksheets(sheetTHId).Cells(r, 1).Value <> "" Then
>If Split(Worksheets(sheetTHId).Cells(r, 3).Value, "-")(0) = basemarket Then

I admire your generosity, doing this for free... Thank you.

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: Yusufmet on July 15, 2017, 08:08:27 AM

Hi, Spreadsheet works except detail graph. When I click coin name it gives runtime error 13 in line 404:
Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value

I have win 7, excel pro 2013 plus.
Any comments?

i would go with p3ppymons response.

i cant really tell for sure since i dont use excel pro 2013 but i think you indeed need a more recent version.

i always recommend to use the most recent version if possible!

win 7 isnt the problem since i use that too.

Quote from: ofergul on July 15, 2017, 10:31:30 AM

Quote from: guesswho1234 on July 09, 2017, 09:56:19 AM

UPDATE: DOWNLOAD IN OP

possibility to switch data part to a light colortheme for printing
graph focus functionality
bittrex version (beta)

great man, keep up the good work.

thanks man. i appreciate that

greetings

p3ppymon

sr. member

Activity: 700

Merit: 254

Quote from: Yusufmet on July 15, 2017, 08:08:27 AM

Hi, Spreadsheet works except detail graph. When I click coin name it gives runtime error 13 in line 404:
Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value

I have win 7, excel pro 2013 plus.
Any comments?

you should upgrade the office package to a more recent version. Otherwise it won't work!

ofergul

full member

Activity: 209

Merit: 100

Quote from: guesswho1234 on July 09, 2017, 09:56:19 AM

UPDATE: DOWNLOAD IN OP

possibility to switch data part to a light colortheme for printing
graph focus functionality
bittrex version (beta)

great man, keep up the good work.

Yusufmet

newbie

Activity: 35

Merit: 0

Hi, Spreadsheet works except detail graph. When I click coin name it gives runtime error 13 in line 404:
Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value

I have win 7, excel pro 2013 plus.
Any comments?

guesswho1234

full member

Activity: 155

Merit: 100