I was able to upload my order history on Bittrex and upon pressing start I received an error:
Run-time error '9': Subscript out of range
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