Quote from: guesswho1234 on April 24, 2017, 01:36:41 PM

Quote from: dobcrypto on April 24, 2017, 12:32:20 PM

Quote from: guesswho1234 on April 24, 2017, 09:35:55 AM

Quote from: dobcrypto on April 24, 2017, 09:32:55 AM

It dosn't work for me to =(
The same error

Code:

Run time error 9
Subscribt out of Range

may i ask what steps exactly you took?
which excel version did you use?
did you import data?
if yes did you fill it into the tradehistory sheet so that only the first row are headers and the rest is data?

im really confused that it works on my computer Undecided

greetings

excel/Microsoft Office 2016 VL x64
1. Open last CALC.XLSM, get it permission to run all scripts.
2. Open tradeHistory.csv and copy all of strings.
https://i.imgsafe.org/defb2233a5.png

3. Go to CALC.XLSM "tradeHistory" tab and past all of strings from tradeHistory.csv
(did try delete 1st string with "Date,Market,Category,Type,Price,Amount,Total,Fee,Order Number,Base Total Less Fee,Quote Total Less Fee", exact same error)
https://i.imgsafe.org/deff5deff8.png

4. Go to CALC.XLSM "calc" > GO! >
https://i.imgsafe.org/df02e85f0b.png

Oh damn i know whats happening.
the file you get from poloniex is a *.csv-file which probably gets openend by a different program on everyones computer.
the thing is that you need to open it with excel so when you copy & paste the data each entry is in its own cell
Never thought about this since i have set excel as my standard program to open *.csv files.
so all you need to do is right-click on the tradehistory.csv and open it with excel, then copy & paste the date into my workbook.

also you do not need to alter the data from the *.csv-file. you can leave the headers if they are in the first row.

it should look like this in the end:

big sorry for not giving that info!
greetings

Of course I open *.csv-file with excel too =)
But I see that it only detaches it in column A, and does not distribute the values in columns.
And then i past it to your sheets, its not distribute the values in columns...
Well see...