Page 1 of 1

Error message: Can not import

Posted: Fri Oct 15, 2010 1:16 am
by Kenny
Hello, I am trying to import FTSE data (daily). The file is in CSV format (though I have tried txt as well).
I have created the new FTSE symbol.
Forex Tester shows no errors on import screen but when I click on the 'Import' button, I get an error message: 'Can not import' and no other explanation. I have looked at the log files folder but nothing about this.
Could you let me know what is wrong?
I cannot seem to attach files so here is a sample of the file (there are no column names).
Many thanks

=========================================

12102010,5672.4,5677,5597.5,5661.6,637397300,5661.6
11102010,5657.6,5686,5655.7,5672.4,475637800,5672.4
08102010,5662.1,5663.7,5606.6,5657.6,1047049600,5657.6
07102010,5681.4,5707.3,5650.8,5662.1,947272500,5662.1
06102010,5635.8,5695.5,5635.8,5681.4,756640300,5681.4
05102010,5556,5646.1,5550.6,5635.8,830151700,5635.8
04102010,5592.9,5601.2,5550.8,5556,604252000,5556
01102010,5548.6,5615.1,5547.5,5592.9,823630600,5592.9
30092010,5569.3,5650.3,5539.1,5548.6,1012633500,5548.6
29092010,5578.4,5624.5,5544.7,5569.3,799992300,5569.3
28092010,5573.4,5582,5506.1,5578.4,854163100,5578.4
27092010,5598.5,5615.8,5569.9,5573.4,600635500,5573.4
24092010,5547.1,5612.5,5516.5,5598.5,818644600,5598.5
23092010,5551.9,5588.8,5471.7,5547.1,795945400,5547.1
22092010,5576.2,5597.5,5516.9,5551.9,783222500,5551.9
21092010,5602.5,5635.7,5576.2,5576.2,731451500,5576.2
20092010,5508.5,5607.3,5508.5,5602.5,677945600,5602.5
17092010,5540.1,5612.9,5508.5,5508.5,1391565400,5508.5
16092010,5555.6,5564.5,5534,5540.1,700780000,5540.1

Re: Error message: Can not import

Posted: Sat Oct 16, 2010 9:52 am
by Terranin
Kenny wrote:Hello, I am trying to import FTSE data (daily). The file is in CSV format (though I have tried txt as well).
I have created the new FTSE symbol.
Forex Tester shows no errors on import screen but when I click on the 'Import' button, I get an error message: 'Can not import' and no other explanation. I have looked at the log files folder but nothing about this.
Could you let me know what is wrong?
I cannot seem to attach files so here is a sample of the file (there are no column names).
Many thanks

=========================================

12102010,5672.4,5677,5597.5,5661.6,637397300,5661.6
11102010,5657.6,5686,5655.7,5672.4,475637800,5672.4
08102010,5662.1,5663.7,5606.6,5657.6,1047049600,5657.6
07102010,5681.4,5707.3,5650.8,5662.1,947272500,5662.1
06102010,5635.8,5695.5,5635.8,5681.4,756640300,5681.4
05102010,5556,5646.1,5550.6,5635.8,830151700,5635.8
04102010,5592.9,5601.2,5550.8,5556,604252000,5556
01102010,5548.6,5615.1,5547.5,5592.9,823630600,5592.9
30092010,5569.3,5650.3,5539.1,5548.6,1012633500,5548.6
29092010,5578.4,5624.5,5544.7,5569.3,799992300,5569.3
28092010,5573.4,5582,5506.1,5578.4,854163100,5578.4
27092010,5598.5,5615.8,5569.9,5573.4,600635500,5573.4
24092010,5547.1,5612.5,5516.5,5598.5,818644600,5598.5
23092010,5551.9,5588.8,5471.7,5547.1,795945400,5547.1
22092010,5576.2,5597.5,5516.9,5551.9,783222500,5551.9
21092010,5602.5,5635.7,5576.2,5576.2,731451500,5576.2
20092010,5508.5,5607.3,5508.5,5602.5,677945600,5602.5
17092010,5540.1,5612.9,5508.5,5508.5,1391565400,5508.5
16092010,5555.6,5564.5,5534,5540.1,700780000,5540.1


I do not see any time information here, and date column is going in opposite direction from last date to previous.

Posted: Mon Oct 18, 2010 1:57 pm
by Kenny
Does there have to be a time? I am trying to build a daily chart. Also, I didn't know what the date order needed to be.
I will try reversing the date order.

Posted: Mon Oct 18, 2010 3:42 pm
by Kenny
I have finally managed to import it (Had to reverse the date order, make sure all columns are the same width (otherwise it just locks up with no error message), saved it as tab delimited text (csv doesn't seem to work)).

Now I can see my daily chart! However, I need some help in defining the symbol properties. I cannot set it so that each 0.1 point movement costs 1 unit of account currency.
Many thanks for your help

Data looks like this now:
01042010 5679.60 5744.90 5679.50 5744.90
06042010 5744.90 5790.40 5744.60 5780.40
07042010 5780.40 5782.30 5753.40 5762.10
08042010 5762.10 5762.10 5684.50 5712.70
09042010 5712.70 5773.60 5712.70 5771.00
12042010 5771.00 5803.70 5755.80 5777.60
13042010 5777.60 5778.90 5741.90 5761.70
14042010 5761.70 5812.80 5761.70 5796.30
15042010 5796.30 5832.30 5778.40 5825.00
16042010 5825.00 5833.70 5726.40 5744.00

Posted: Sat Oct 23, 2010 6:57 am
by FT Support
Please try to set LotSize=1000 and Minimal point = 0.01