Error message: Can not import

Sources of data to import to the program
Message
Author
Kenny
Posts: 4
Joined: Fri Oct 15, 2010 1:01 am

Error message: Can not import

#1 Postby Kenny » Fri Oct 15, 2010 1:16 am

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

User avatar
Terranin
Site Admin
Posts: 838
Joined: Sat Oct 21, 2006 4:39 pm

Re: Error message: Can not import

#2 Postby Terranin » Sat Oct 16, 2010 9:52 am

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.
Hasta la vista
Mike

Kenny
Posts: 4
Joined: Fri Oct 15, 2010 1:01 am

#3 Postby Kenny » Mon Oct 18, 2010 1:57 pm

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.

Kenny
Posts: 4
Joined: Fri Oct 15, 2010 1:01 am

#4 Postby Kenny » Mon Oct 18, 2010 3:42 pm

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

FT Support
Posts: 905
Joined: Sat Jul 11, 2009 10:54 am
Contact:

#5 Postby FT Support » Sat Oct 23, 2010 6:57 am

Please try to set LotSize=1000 and Minimal point = 0.01
Check our other products here:
www.fx-metropolis.com
www.forexcopier.com


Return to “Data sources”

Who is online

Users browsing this forum: No registered users and 0 guests