Re: excel-sheet for the tradehistory.csv export from poloniex
It dosn't work for me to =(
The same error
may i ask what steps exactly you took?The same error
Code:
Run time error 9
Subscribt out of Range
Subscribt out of Range
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
greetings
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
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