1m Data CSV Missing Comma

Sources of data to import to the program
Message
Author
Dud45
Posts: 1
Joined: Fri May 24, 2013 11:44 pm

1m Data CSV Missing Comma

#1 Postby Dud45 » Fri May 24, 2013 11:47 pm

Hi Guys,

I've just spent all morning DL'ing Dukascopy 1M data to find that their CSV doesn't have a comma between data and time. Obviously FX Tester needs this. Does anyone know a trick for this or will I have to download .hst data?

KelvinHand
Posts: 103
Joined: Sun Jan 02, 2011 6:05 pm

Re: 1m Data CSV Missing Comma

#2 Postby KelvinHand » Sat May 25, 2013 7:18 am

Dud45 wrote:Hi Guys,

I've just spent all morning DL'ing Dukascopy 1M data to find that their CSV doesn't have a comma between data and time. Obviously FX Tester needs this. Does anyone know a trick for this or will I have to download .hst data?


pls show the data format or attached the data

Downloaded from the website
http://www.dukascopy.com/swiss/english/ ... istorical/

Should be this format

Code: Select all

25.05.2013 23:17:00.000,1.29218,1.29218,1.29218,1.29218,0.00
25.05.2013 23:18:00.000,1.29218,1.29218,1.29218,1.29218,0.00
25.05.2013 23:19:00.000,1.29218,1.29218,1.29218,1.29218,0.00


EITHER

New Feature Suggestions to FT2 to handle this duka format

OR

User need to write a conversion program to:
- replace the space to coma between the date and time AND
- remove the millisec (.000) in the time


Return to “Data sources”

Who is online

Users browsing this forum: No registered users and 3 guests