1 (edited by kukreknecmi 2013-01-30 01:51:31)

Topic: Import Dukascopy data thru web

Is it working well now? I tried to download yesterday and SFB cant use it, keep saying "cannot determine the time field format"

It is in this type of format

Time,Open,High,Low,Close,Volume
29.01.2013 17:15:00.000,1.34765,1.34822,1.34751,1.34808,1858370000.00
29.01.2013 17:30:00.000,1.34808,1.34812,1.34764,1.34770,1242630000.00
29.01.2013 17:45:00.000,1.34770,1.34821,1.34767,1.34802,956000000.00
29.01.2013 18:00:00.000,1.34802,1.34865,1.34800,1.34838,1504180000.00
29.01.2013 18:15:00.000,1.34836,1.34856,1.34804,1.34838,1067930000.00
29.01.2013 18:30:00.000,1.34836,1.34854,1.34807,1.34811,878400000.00
29.01.2013 18:45:00.000,1.34811,1.34834,1.34791,1.34826,1161900000.00
29.01.2013 19:00:00.000,1.34825,1.34881,1.34820,1.34867,1658430000.00
29.01.2013 19:15:00.000,1.34867,1.34968,1.34855,1.34887,2113030000.00
29.01.2013 19:30:00.000,1.34886,1.34931,1.34862,1.34918,1573130000.00
29.01.2013 19:45:00.000,1.34918,1.34927,1.34858,1.34868,1386920000.00

I guess  time code is not in hh:mm format and causing error right? If i convert it to

29.01.2013 23:45,1.34929,1.34930,1.34916,1.34924,294830000.00
29.01.2013 23:50,1.34924,1.34925,1.34891,1.34921,319850000.00
29.01.2013 23:55,1.34923,1.34933,1.34901,1.34913,286290000.00

then it says it "cant count the bars"

so i guess   the time  doesnt start with 00:00  and causing the problem right? Is it possible to import this via SFB?

http://www.dukascopy.com/swiss/english/marketwatch/historical/

Re: Import Dukascopy data thru web

You are converting time correctly, but remains a problem with volume.
Volume must be int number.

29.01.2013 23:45,1.34929,1.34930,1.34916,1.34924,294830000.00
29.01.2013 23:50,1.34924,1.34925,1.34891,1.34921,319850000.00
29.01.2013 23:55,1.34923,1.34933,1.34901,1.34913,286290000.00

must be 

29.01.2013 23:45,1.34929,1.34930,1.34916,1.34924,29483
29.01.2013 23:50,1.34924,1.34925,1.34891,1.34921,31985
29.01.2013 23:55,1.34923,1.34933,1.34901,1.34913,28629

Re: Import Dukascopy data thru web

Ok, i see, if i delete last 7 chars from 1st and 7th column it is recognized well, thx. I realised it when it said number is too big for int32 hmm/ then saw your post, thx again.