Import CSV file

New comment
 

Hello,

Id like to import comma separated CSV files to MT4. I downloadad CSV files from yahoo and compared it with the format what I can export from MT4. I modified the original CSV and MT4 can recognize it now but I don't know where can I find it in MT4 after that. How can I open it as a chart and work with the imported datas?


Thanks,

David

 

what kind of data is this csv data? is it currency prices, or what?

maybe you could post five or ten lines of it here?

 

US share prices:

Date, Open, High, Low, Close, Volume...same as MT4 export files.

MT4 can read it in tools/history prices/import just after I click import nothing happens I dont know where can I find the datas or how to work with them.

2012.08.10 0:00 36.76 37 36.4 36.97 15440100
2012.08.09 0:00 36.72 37.26 36.59 36.92 23406700
2012.08.08 0:00 36.85 37.48 36.75 37.16 18672400
2012.08.07 0:00 36.57 37.87 36.57 37.01 37225800
2012.08.06 0:00 36.24 36.8 36.11 36.3 18979200
2012.08.03 0:00 35.82 36.29 35.5 36.09 24516300
 
My main problem is that I'm trading US stock options usually. I'm using MT4 just to backtest some strategies where optin prices not important just the share price changes and tendencies. I dont want a robot just to backtest my strategies. With programming I proceed well but I arrived to a point where I'd like to backtest my strategies on stocks not currency pairs. So if anyone can suggest me a way to reach it I would be very thankful.
 

Find Good example of how it's done Here. The .hst/.fxt files will be within the /History/Folder (Sometimes .fxt is within tester folder). You can open history files during testing by using a function similar to below.

int fileOpenEx(string name, int mode){
   if (IsTesting()){
      if (__chart_file == 0){
         __chart_file = FileOpenHistory(name, mode);
      }
      return(__chart_file);
   }else{
      return(FileOpenHistory(name, mode));
   }
}
You can open history-charts by hitting File>Open_Offline or File>New_Chart. Reading this Article may help your understanding of chart data and locations.
 
Gotthenut122:
My main problem is that I'm trading US stock options usually. I'm using MT4 just to backtest some strategies where optin prices not important just the share price changes and tendencies. I dont want a robot just to backtest my strategies. With programming I proceed well but I arrived to a point where I'd like to backtest my strategies on stocks not currency pairs. So if anyone can suggest me a way to reach it I would be very thankful.

Well lets see here, 1st) You get some data.... 2nd) Convert to format mt4 can understand... 3rd) Change the Symbol-Name to something within your Symbol-Set (Something your account broker supports) ex>EURUSD.

If you're lucky, it'll just be as easy as that. I've never tried to strategy test stock options and just brain-storming. If the options data/strategy is tick-sensitive then I'll recommend converting it to .fxt instead of .hst files. Review the 99% modeling quality process for better understanding... Here.

 

not that the original issue has been resolved, but lets sorta move on to the next level of this issue for a moment...

tell me a bit about your strategies that you want to run against/backtest on this downloaded data...

do you perhaps just have one or two pieces of software that you want to backtest?

if so, perhaps we should just start thinking about writing a custom backtester?

just thinking out loud.

maybe take a look around at http://wilmott.com/, maybe they might have a solution for you.

best wishes.

me/.

Video: The Broken Stick Experiment

New comment
Reason: