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.