Thread: Change Date format on MT4 .csv files?

Hanover,

thank you for your quick response.

Originally Posted by ;

Just to make sure I understand correctly: you mean that you are interested in getting the OHLC prices just as though the day begins/ends at 20:00 (or some other time) rather than 00:00 (midnight)?

That's correct.

Originally Posted by ;

In other words, some intervals from 20:00 hours to 20:00 hours would include less than 24 candles.

I don't care about openings, just the quickest/easiest programming adequate.

Originally Posted by ;

You also need to decide how you want the output date-stamped, e.g. will Monday 20:00 to Tuesday 20:00 represent Monday or Tuesday?

Monday.

Originally Posted by ;

Depending on the answers to the above questions, it might not necessarily be a trivial endeavor, and I am very busy with additional programming work right now. The source code can be obtained is any other developer.

If you could find then a little spare time, it would be absolutely excellent. Only the quickest/easiest approach, as I wrote.

Otherwise, if it is still more work than I thought, send me a quote through PM if you like.

Thank you a lot!

Kind regards,

secondstone,

Please try the attached script. This is my best and last effort, after spending over 4 hours trying several different methods of dealing with the weekend breaks in the information. The script generates Saturday candles in certain scenarios. If you export the prepaid data into a XLS and then attempt using formulae to group/summarize the information logically yourself, you may observe firsthand the ambiguities which are included.

The worth 20 in the ShiftHours parameter implies that the daily breaks at the information will happen at a time 20 hours earlier than the MT4 period of this candle being processed. Thus the fractures will happen at the 20:00 candles, since 20 hours earlier than 20:00 is 00:00. The 'daily' open will be at 20:00 H1 open; the near will be the close of this 19:00 H1 close. The daily high and low are the highest H1 high and cheapest H1 low across this interval, and the volume will be the amount of all of the H1 candle volumes across the interval.

This is my final article in this thread. After almost 5 decades of contributing freeware to FF, I owe it to use whatever spare time I've writing EAs for my personal use and profit.

David
https://www.nigeriaforextrading.com/...7325782508.mq4

David,

I'll try the script Afterwards. I have sent you a PM.

THANK YOU!

Kind regards,

Originally Posted by ;

Hi Creztor Sorry, I don't know of any way to acquire MT4 to get this done. Here's a workaround: 1. Download FREEWARE text editor EmEditor out of http://shareme.com/download/emeditor-free.html and then run the .MSI file to set up (into \Program Files\EmEditor) Then run EmEditor 2. Open the file (press Ctrl-O) whose dates you wish to change. 3. Press Ctrl-H for search/replace, and assess Use Regular Expressions ON. Type exactly ^(...)\. (. .) \. (. .) Into the Find field, and \2-\3-\1 into the Replace with field [NOTE: this assumes you want...

Thank you so much, it is very usefull

[IMG]file:///C:/Users/USER1 percent7E1/AppData/Local/Temp/moz-screenshot. Png[/IMG]Hannover, I had been looking at the indior exportHistory, very good indior, but I had a change, I'll give below a detailed explanation.

(CurrencyPair) stays the same, but may also use the symbols flipped, eg AUDGBP

another parameters will remain the same, the big change will be the outcome. see below.

CurrencyPair = AUDUSD, AUDJPY, GBPAUD, EURAUD, AUDNZD, AUDCHF, AUDCAD
Timeframe = M1
= D'2010 .11.19 FromDateTime 01:21 ';
= D'2010 .11.19 ThruDateTime 02:40 ';
NumBars = 9999;
AscDesc = D;
Separator = ;
DateTimeFmt = M-D-Y, H: I;
OHLCFmt = T3.5;
VolFmt = T9;
OutputFile = ;
Comments = true;

would be possible?

Can someone please tell me how to change the data path of conserving document? . .

Originally Posted by ;

Can someone please tell me how to alter the data path of conserving file? . .

MT4 will not let you do this for safety reasons.

Originally Posted by ;

Can someone please tell me the way to change the data path of saving document? . .

CodeMeister is accurate.

This is not possible without rewriting the script to use the Windows API document I/O rather than MQL4 Document controls. (See http://docs.mql4.com/files/FileOpen and http://articles.mql4.com/720 for more info).

The simplest way is to copy the files manually to whatever folder you wish.

If your disk was formatted using NTFS you can just set a http://en.wikipedia.org/wiki/NTFS_symbolic_link (or a http://en.wikipedia.org/wiki/NTFS_junction_point in versions older than vista) inside the files folder that points to somewhere else or even make the entire files folder a symlink. This is a method.

[IMG]file:///C:/Users/USER1~1/AppData/Local/Temp/moz-screenshot. Png[/IMG]Hannover I was looking at the indior exportHistory, quite good indior, but I needed a change, I'll give below a comprehensive explanation.

(CurrencyPair) stays the same, but may also use the symbols flipped, eg AUDGBP

the other parameters will remain the same, the big change will be the result. see below.

CurrencyPair = AUDUSD, AUDJPY, GBPAUD, EURAUD, AUDNZD, AUDCHF, AUDCAD
Timeframe = M1
= D'2010 .11.19 FromDateTime 01:21 ';
= D'2010 .11.19 ThruDateTime 02:40 ';
NumBars = 9999;
AscDesc = D;
Separator = ;
DateTimeFmt = M-D-Y, H: I;
OHLCFmt = T3.5;
VolFmt = T9;
OutputFile = ;
Remarks = true;

are possible?