Topic: "Could not determine price columns order" error CSV File
I have downloaded dukascopy candlestick data via dukascopier_v0.4,
It downloads the data and creates a CSV file for you for each time period you request and from what time period back you want.
As far as I can see to make the data compatible is,
1. Open the csv file in Notepad, Menu item - Edit, Replace. Top box press space bar for a space, bottom box add a comma, Find next, Replace all. This will separate the date from the time into two columns. (Tab delimited) Save, Exit
2. Open the file in Excel, Select the Time Column, format cell, special, in the box where "general" is type hh:mm and press enter, this will put the time into an acceptable format. Select the four price columns, format cells, currency, no symbol, decimal places 5(for EURUSD etc) to round off all data to 5 digits. Select the volumes column, format cells, number, decimal places 0, to round off volume data to whole number.
NOW to save your file properly close the file using the close file option, it will ask you if you want to save hit yes then it will ask you if you want to keep the data in the type of file format also click yes.
3. Rename the file to EURUSD5.csv or whatever TF you need.
I cant see any problems, it is just a data file after all, editing it as can be done in Notepad and Excel.
But I get the error "Could not determine price column order" error message when loading FSB. "Error in data file".
Can someone enlighten me please or point the error of my ways.
**PS just watch Excel, when you open the file up again the time column will show the data as unformated as done above in Number 2, if you check it by opening it in Notepad it will be correct.
I attach a downloaded data file from Dukascopier.