History Center - Import CSV tick data | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Formatting CSV tick data for MT4 0 replies

Tick Size, Tick Rate, Tick Spread, and Tick Logger indicators 36 replies

How do I stream MT4 tick data into a spreadsheet using .CSV (no DDE)? 6 replies

History Center : Import csv file 6 replies

History Center - Import CSV tick data

  • #1
  • First Post: Aug 10, 2010 5:39pm Aug 10, 2010 5:39pm
I know that this is a stupid question, but i can't get it. My CSV file looks like this

Inserted Code
 
2003.08.29;12:29:01;1.0932;1.0932;1.093;1.0934;43
2003.08.29;12:30:01;1.0934;1.0932;1.093;1.0935;37
2003.08.29;12:31:01;1.0932;1.0932;1.0929;1.0934;35
2003.08.29;12:32:01;1.0933;1.0931;1.0929;1.0935;43
2003.08.29;12:33:01;1.093;1.0926;1.0924;1.0933;51
2003.08.29;12:34:01;1.0926;1.0929;1.0923;1.0932;48
2003.08.29;12:35:01;1.093;1.0932;1.0926;1.0933;46
2003.08.29;12:36:01;1.0933;1.0934;1.0931;1.0936;43
2003.08.29;12:37:01;1.0934;1.0938;1.0931;1.094;45
2003.08.29;12:38:01;1.0938;1.0935;1.0933;1.0943;42

I select the pair, timeframe then click on import, select the file and nothing comes up. Searched the forum, searched the internet, but I couldnt find any answer to be useful.

I am doing something wrong or MT4 is screwed?
Today I BUY, tomorrow I SELL!
  • #2
  • Aug 10, 2010 8:49pm Aug 10, 2010 8:49pm
Try removing the minute :01
To be sure export some data from your history and see what the format is.
  • #3
  • Aug 10, 2010 9:41pm Aug 10, 2010 9:41pm
Tried that. I also exported the data and added my data in the same format on the same file and MT4 import features has a lot of bugs...worked 1-2 times then again stoped working...anyone has better ideas or how can I convert the data to HST ? A program or something (no mql script).
Today I BUY, tomorrow I SELL!
  • #4
  • Aug 11, 2010 2:56am Aug 11, 2010 2:56am
I've got it working. If someone is interested let me know.
Today I BUY, tomorrow I SELL!
  • #5
  • Aug 18, 2010 7:46pm Aug 18, 2010 7:46pm
I did you manage to do it ? HST file ?
  • #6
  • Aug 19, 2010 2:22am Aug 19, 2010 2:22am
I imported the CSV only.
Today I BUY, tomorrow I SELL!
  • #7
  • Aug 19, 2010 5:01am Aug 19, 2010 5:01am
The correct format is:

Inserted Code
<TICKER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
EURUSD,20010103,000100,0.9507,0.9507,0.9507,0.9507,4
EURUSD,20010103,000200,0.9506,0.9506,0.9505,0.9505,4
EURUSD,20010103,000300,0.9505,0.9507,0.9505,0.9506,4
EURUSD,20010103,000400,0.9506,0.9506,0.9506,0.9506,4
EURUSD,20010103,000500,0.9506,0.9506,0.9506,0.9506,4
EURUSD,20010103,000600,0.9506,0.9506,0.9506,0.9506,4
EURUSD,20010103,000700,0.9505,0.9507,0.9505,0.9507,4
EURUSD,20010103,000800,0.9507,0.9507,0.9507,0.9507,4
EURUSD,20010103,000900,0.9507,0.9507,0.9507,0.9507,4
EURUSD,20010103,001000,0.9507,0.9507,0.9507,0.9507,4
EURUSD,20010103,001100,0.9507,0.9507,0.9506,0.9507,4
EURUSD,20010103,001200,0.9507,0.9507,0.9507,0.9507,4
EURUSD,20010103,001300,0.9507,0.9507,0.9507,0.9507,4
  • #8
  • Aug 19, 2010 5:30am Aug 19, 2010 5:30am
What asasa said. The format he showed is the same as the data from the site Ronald Raygun suggested using for historical data.

I'm not sure how to get MetaTrader to import other formats, short of writing a custom program to covert an odd format to the one asasa showed.
You are in a maze of twisty little passages, all alike.
  • #9
  • Last Post: Aug 19, 2010 6:15am Aug 19, 2010 6:15am
Quoting stevegee58
I'm not sure how to get MetaTrader to import other formats, short of writing a custom program to covert an odd format to the one asasa showed.
You are right, this is the way to go.
0 traders viewing now