Converting Errors

[Bourne]

I recently purchased a library of historic data from http://disktrading.is99.com/disktrading/

I downloaded all the data in .csv format. When I try and import into FT I get a message saying that there are 11 import errors. If I continue to try and import the material it takes an extremely long time. I stopped trying to import at about 5% which took around 20 minutes.

Please let me know if you would like me to email you a copy of the data.

[FT Support]

Please post a part of data here. Just a few lines, it will be enough.

[Bourne]

Here is the first several lines of data I have for the eurgbp


1/4/1999 644 0.7123 0.7123 0.7123 0.7123 0 0
1/4/1999 644 0.7122 0.7122 0.7122 0.7122 0 0
1/4/1999 644 0.7117 0.7117 0.7117 0.7117 0 0
1/4/1999 645 0.712 0.712 0.712 0.712 0 0
1/4/1999 645 0.7123 0.7123 0.7123 0.7123 0 0
1/4/1999 645 0.712 0.712 0.712 0.712 0 0
1/4/1999 645 0.7119 0.7119 0.7119 0.7119 0 0
1/4/1999 646 0.7122 0.7122 0.7122 0.7122 0 0
1/4/1999 646 0.7122 0.7122 0.7122 0.7122 0 0
1/4/1999 646 0.712 0.712 0.712 0.712 0 0
1/4/1999 646 0.7123 0.7123 0.7123 0.7123 0 0
1/4/1999 647 0.7119 0.7119 0.7119 0.7119 0 0
1/4/1999 647 0.7121 0.7121 0.7121 0.7121 0 0
1/4/1999 648 0.712 0.712 0.712 0.712 0 0
1/4/1999 648 0.7118 0.7118 0.7118 0.7118 0 0
1/4/1999 648 0.7118 0.7118 0.7118 0.7118 0 0
1/4/1999 648 0.712 0.712 0.712 0.712 0 0
1/4/1999 648 0.7119 0.7119 0.7119 0.7119 0 0
1/4/1999 649 0.7121 0.7121 0.7121 0.7121 0 0

[Bourne]

Any help or advice on this?

[FT Support]

Hello, i've tried to import this data into Forex Tester and it seems that data format is invalid for FT.
Probably you need some converter to transform data into FT format.

[Bourne]

The data is a .csv file which is suppose to be compatible with FF. What is invalid about the format and what kind of converter am I going to be able to find to transform this data?

[FT Support]

Please see incompatibilities of these data below:

1) Date format should be one of the followng: YYYYMMDD, DDMMYYYY, MMDDYYYY. YYMMDD, DDMMYY, MMDDYY

2) Time format should be HHMMSS

3) There is superfluous 0 at the end of data

[Bourne]

Thanks for your help. I got in touch with the company and they were able to get me the correct format.