Thread: Change Date format on MT4 .csv files?

It seems the exported .csv Isn't sorted out of Older Outdated to new dates but Instead fro new dates to Outdated Customs so there is a diffrent from the Guide exported .csv along with the exported Documents by this script can the script be modified to be similar to the Standard exported .csv file
Thanks in advance

Originally Posted by ;

It seems the exported .csv is not sorted out of older dated to new dates but rather fro new dates to old dates so there's a diffrent in the manual exported .csv and the exported files through this script will the script be altered to be like the standard exported .csv file
Thanks in advance

Efmelp, to undo the date arrangement, change the line of code that reads:

for(int I=0; ilt;iBars(ccy,tf); I )
into
for(int I=iBars(ccy,tf)-1; igt;=0; I--)

Then press F5 to recompile the script.

__________________________________________________ __________

Originally Posted by ;

Hello Hanover and many thnx for that script but that will collect all time frames information in one folder So is that possible to make the price info downloaded in various folders I mean a folder for daily information and other folder for 4hr information and so on is that possible ?

Regards

Ahmed, change the line of code that reads:

series fname = ccy , tf .csv;
into
series fname = TF- tf \\ ccy , tf .csv;

Then press F5 to recompile the script.

This will automatically create subfolders below ...\specialists\files\ called TF-1 for 1 min charts, TF-5 for 5 minutes charts, TF-60 for hourly charts, TF-1440 for daily charts, respectively and create the most relevant charts inside each subfolder.

David

Hello and Several thnx for your help David I changed the Code and it allready give me separate Connections but I am facing a new problem the CSV files didnot uppdate even when I Shut the station an open again it on the old data

how Do I Fix this problem

Thnx again on your Functions
Regards

hello David
I have another idea :
I have an indior which is Agetdata indior it uppdates the information once the MT4 is online but it hase some limits
1/ it publish prices in PRN not CSV
2/its adjusted only to publish dates although not time so its okay when studying daily and weekly charts but when use it using intraday information it uppdate let the very last bars however the time studying on the other appliions is 2004 not 2007 ( for final bars)

3/ publish limitation No. Of bars not all of the information shown on MT4
4/ publish all information in 1 folder ( not Multiple folders since you made with your expirt)
So may you operate on that indior tosolve these problems

Regards
https://www.nigeriaforextrading.com/...1071086095.mq4

Originally Posted by ;

Hello and many thnx for your help David I changed the Code also it allready give me separate folders but I am facing a new issue the CSV files didnot uppdate even when I close the channel an open again it still on the old data

how can I solve this dilemma

Thnx again for your functions
Regards

Ahmed, this is a script, not a indior. Hence each single time you open MT4 (or wish to refresh the CSV files with the latest data) you have to open the Navigator (press Ctrl-N) and drag the script straight back onto the chart. This will re-run the script and therefore completely re-build the CSV files with whatever data is in MT4's history records at that moment.

David

Hello David and excuse me since I am still new with MQL iam still study my 1st course relating to this speech,
and I think the script won't be handy to use as a tool to export data

something else concerning the Agetdata indior is there is any chance to modify it !!!

Regards

This is excellent , only learned about the script now. Many thanks.

Hanover your knowledge is greatly appreciated.
I am focusing on similar tasks to create a 3D chart in Excel. I have read the tutorial: http://articles.mql4.com/493
I am unable to identify how to import volume data as my arraySizeZ. The tutorial is only partial apparently and definitely not enough for a non-coder such as myself. In case you have enough opportunity to change the code to show time compression and volume I would appreciate it.

TRADE WELL!
https://www.nigeriaforextrading.com/...1057055345.zip

Hello,

I know there are several program that save ascii information file, e.g. .csv .txt .prn.

How can I change year format, for instance, year 2009 to 1999?

Year is only thing I concern. I want date and time never changed at all.

THANK YOU.

secondstone,

Please try the attached script. This is my greatest and final effort, after spending over 4 hours attempting several different methods of managing the weekend breaks in the data. The script generates Saturday candles in some specific scenarios. If you export the hourly data to a XLS and then try using formulae to group/summarize the data logically yourself, you will observe first-hand the ambiguities which are included.

The worth 20 in the ShiftHours parameter implies that the daily breaks in the data will occur at a time 20 hours sooner than the MT4 period of this candle has been processed. Hence the breaks will occur in the 20:00 candles, since 20 hours sooner than 20:00 is 00:00. The 'daily' open will be at 20:00 H1 open; the near will be close of this 19:00 H1 close. The daily high and low will be the highest H1 high and lowest H1 low across this interval, and the quantity will be the sum of all the H1 candle volumes across the interval.

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

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