Post
Topic
Board Services
Re: excel-sheet for the tradehistory.csv export from poloniex
by
guesswho1234
on 01/05/2017, 21:53:07 UTC
Hello guys,

I have the same problem with your Excel-sheet, but have also found a way to make it work. It seems to have to do with the fact that in my country, the decimal symbol is a comma.
The export from poloniex uses a dot as the decimal symbol and the comma as a separator. So I do the following:

In notepad, I replace all commas (the separators) with a semicolon. For example:

This:

Date,Market,Category,Type,Price,Amount,Total,Fee,Order Number,Base Total Less Fee,Quote Total Less Fee
2017-05-01 20:08:48,BTS/BTC,Exchange,Buy,0.00001085,1843.31747235,0.01999999,0.25%,23264916809,-0.01999999,1838.70917867

Becomes:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0.00001085;1843.31747235;0.01999999;0.25%;23264916809;-0.01999999;1838.70917867

Now, again in notepad, I replace all dots with a comma.

This:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0.00001085;1843.31747235;0.01999999;0.25%;23264916809;-0.01999999;1838.70917867

Becomes:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0,00001085;1843,31747235;0,01999999;0,25%;23264916809;-0,01999999;1838,70917867

Now, i open up calc.xlsm. I do not simply copy the contents of the export file to the 2nd sheet, but use the import function -> Data, from text.

After this I am able to click the go button and everything works as expected, including the graph.

Let me know if this helps anyone else.
its also possible to tell excel to convert this by going to file->options->advanced
and then tell excel which characters should seperate decimals and thousands

also if excel is properly set up you shouldnt really need to do any of that since excel is able to handle *.csv files quite well and normally puts every values in its own cell where it is supposed to be if you view the file as a table


greetings