deleted

[dobcrypto]

Wery cool Spreadsheet, many thx!

[jkminkov]

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

[guesswho1234]

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

i will think about it

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


greetings

[jkminkov]

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

[mycho]

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

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

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


greetings

Hi !
Have you been able to fix this issue ?
I have the same problem when I click start after selecting the BIttrex CSV file
Thanks

[guesswho1234]

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

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

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


greetings

Hi !
Have you been able to fix this issue ?
I have the same problem when I click start after selecting the BIttrex CSV file
Thanks

im not sure but i think they guy never responded to me again.

if you dont mind sending me the data with which you tried it i will try to debug it for you.

you can add me on skype (constraccta) or pmme here.


greetings

[mycho]

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

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

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


greetings

Hi !
Have you been able to fix this issue ?
I have the same problem when I click start after selecting the BIttrex CSV file
Thanks

im not sure but i think they guy never responded to me again.

if you dont mind sending me the data with which you tried it i will try to debug it for you.

you can add me on skype (constraccta) or pmme here.


greetings

Perfect, PM me an e-mail address where I can send my file

[toomeke]

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

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

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


greetings

Hi !
Have you been able to fix this issue ?
I have the same problem when I click start after selecting the BIttrex CSV file
Thanks

Hi, I also have the same issue 'Run-time error '9': Subscript out of range'

Looks really promising!

[toomeke]

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

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

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


greetings

Hi !
Have you been able to fix this issue ?
I have the same problem when I click start after selecting the BIttrex CSV file
Thanks

Hi, I also have the same issue 'Run-time error '9': Subscript out of range'

Looks really promising!

Anyupdate peeps?

[BryanC]

The source of the problem appears to be that the data exported from Bittrex does not match what the spreadsheet is expecting to see. There are definitely fewer fields coming from Bittrex than there are columns that expect data in the spreadsheet.

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

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

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


greetings

Hi !
Have you been able to fix this issue ?
I have the same problem when I click start after selecting the BIttrex CSV file
Thanks

Hi, I also have the same issue 'Run-time error '9': Subscript out of range'

Looks really promising!

[vit05]

How does the graphics work?

[atorrealba]

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.

I have noticed this same issue, it seems like the code's formulas are not matching with the spreadsheet's data. For instance it would reference D2 as the Limit Type but that value should reference C2 as D2 is actually the column for the Quantity.

There are cell referencing issues on the Bittrex .xlms file that need to be addressed/fixed because importing the data is not the issue at hand but rather the CSV file's format/layout is lost in translation from the Excel sheet's correct referencing , while the Poloniex .xlms file works properly on MS2013 and MS2016.


If there is any way you can debug the script which I have tried however it seems to give me another error for a value of some sort. But mainly the Bittrex file is not 100% up-to par and able to work correctly.

I'm unsure if it could be whether Bittrex changed the CSV layout or if the column numbers were simply readjusted and based on Poloniex's order history CSV file which I believe is the case.


If OP could please address this issue and re-script the Bittrex file to match with the Bittrex order CSV, that would be appreciated

[filtr0w]

excellent tool too bad i cannot upload it on onedrive for some reason maybe because i dont have a paid suscription to office365?

[filtr0w]

and +1 to adapt it better to bittrex, definitely will keep being the biggest altcoin platform for a long time...

[guesswho1234]

excellent tool too bad i cannot upload it on onedrive for some reason maybe because i dont have a paid suscription to office365?

never used onedrive so far so i cant help you there sorry

@all
i am currently pretty busy with university stuff and my other project (https://bitcointalk.org/index.php?topic=1958068) and therefore
am a little behind on support for this project. when i eventually have some more freetime again i will catch up with everything i planned to do.

happy trading

[majorlee]

NOD is blocking the D/L site

[guesswho1234]

NOD is blocking the D/L site

sorry to ask but what is NOD?

if you want you can just add me on skype and i send it to that way (skype: constraccta)


greetings

[guesswho1234]

UPDATE: DOWNLOAD IN OP

• bugfix for the bittrex version

[davemanet]

UPDATE: DOWNLOAD IN OP

• bugfix for the bittrex version

Cool Excel op.  I just tried it with Bittrex but it doesn't appear to work. 

- Some but not all coins appear on the left
- No graphs on the right appear

When I click Trade History it appears blank.  Are there supposed to be filled cells there?  Is there a manual method to copy and paste the data?  I'm guessing there's something going wrong with the import feature.

[guesswho1234]

- Some but not all coins appear on the left

if you hit start it only shows coins with which you have traded in the selected timeframe

so if you traded monero in 2016 but selected a timeframe starting at 2017 it wont display the coin on the right

the same applies for when you traded them in a different basemarket which you can select at the settings as well

if your missing coin fullfills all that criteria there might indeed be a mistake

otherwise try altering the settings

- No graphs on the right appear

by default no graphs appear right away

in order to display something in the graph you need to click on a coin on the left (most text that is written in blue is clickable with some kind of effect)

if you click on the coin and you get an error or nothing gets displayed there again might be a mistake

otherwise everything works as intended

When I click Trade History it appears blank.  Are there supposed to be filled cells there?  Is there a manual method to copy and paste the data?  I'm guessing there's something going wrong with the import feature.

dont get confused by the looks of the tradehistory sheet

i dont recommend to do any manual altering of that sheet since its easy to mess something up

the coded manages this sheet entirely on its own which may result in it looking empty even though it really is not


so far i would say that it works fine since you were able to import and hit start without any errors which was so far the only part where something went wrong

if you still have problems even after checking what i just explained feel free to contact me here or on skype!


greetings