Change Date format on MT4 .csv files? | Page 3 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Implied volatility data for Forex options in .CSV format 3 replies

How do I include the date in my CSV output? 2 replies

Exporting & importing Global variables to CSV Files 3 replies

Attachments: Change Date format on MT4 .csv files?
Exit Attachments

Change Date format on MT4 .csv files?

  • #41
  • Sep 6, 2009 5:18am Sep 6, 2009 5:18am
The vbscript is run outside MT4 just from your Windows command prompt it interacts between the automatic history export files and your Excel spreadsheet. I'm writing some code at the moment that'll use the data from the MT4 automatic history file export. What I'm doing is using the 60 min for the high and low of the day (highest high / lowest low), the 1 min is used to display the latest closing price it's possible we can use the Tick chart to display tick data in Excel.

The script is still in progress as I'm currently writing the code for a trading system that automatically pulls out the data then apply formulas (this used to be entered manually e.g. high, low of end of day then the close price at 10.00pm). I'm just writing the code to monitor live prices then update when orders are triggered and closed displayed in Excel, at the end of the day exports the results of the trading day into another Excel spreadsheet. Useful to test live a system.

Once I've finished that project I'll post a VBS file that on here that'll be useful for using these auto generated history files to automatically view in Excel the daily High, Low, Close and the latest closing price from the 1 min chart. I think there are other ways to do this by the way because with these auto exported history files you can use VBA code directly from your spreadsheet. Trouble is I'm not that familiar with VBA but use VBscripts a lot as they interface with most applications. Please bear with me though as I'm quite busy at the moment.
  • #42
  • Dec 26, 2009 5:22am Dec 26, 2009 5:22am
Dear all
Any one here can help in building indicator to creat .txt EOD data in the formate ( yyyyMMdd HHmmss;open price;high price;low price;close price;volume )

Regards
  • #43
  • Dec 26, 2009 1:37pm Dec 26, 2009 1:37pm
Quoting ahmedalhosenyy
Dear all........
It's already been done - see post #36.

Set:
Separator = ;
DateTimeFmt = YMD HIS
  • #44
  • Jan 20, 2010 3:05am Jan 20, 2010 3:05am
Dear Hanover.

Thank you very much for this indicator, it's really what I was looking for!

Anyway, I would ask for one think: could it be possible to erase the limit of number of bars? What I need is to obtain a file including all possible data stored in History Centre (as alternative in the chart), and have it updated everytime a new bar appears. So if in history there are 1000 bars at 8:00, my history file of a M1 chart will have 1000 bars at 8:00, 1001 at 8:01, 1002 at 8:02, etc... Could it be possible???

Thank you and hear you soon...
  • #45
  • Jan 20, 2010 11:27am Jan 20, 2010 11:27am
Quoting Sonja
Anyway, I would ask for one think: could it be possible to erase the limit of number of bars?
For no limit, set NumBars = 9999999

If operating on M1 chart, and you want output every bar, set RefreshEveryXMins = 1
  • #46
  • Jan 24, 2010 6:00pm Jan 24, 2010 6:00pm
Hello

I have instaled the historic indicator on my mt4 plataform and i can chose the setting etc.

When i run the indicator appears the message in the left up coner.

Export historic compleat to file ...esperts/files. EURUSD.M1.csv something similar to this.

I go to expertsfiles folder and there is nothing there. Looks like it doesn´t creat the csv document.

Do you have any idea what is causing this?

Thanks

Alfredo
  • #47
  • Jan 24, 2010 10:07pm Jan 24, 2010 10:07pm
Quoting Alfredo
I go to expertsfiles folder and there is nothing there. Looks like it doesn´t creat the csv document.
Do you have any idea what is causing this?
The latest version of the indicator is attached; please download and try it. It's working fine for me. Below are screenshots of my parameters, and the output file that was generated.

How are your parameters different to mine?

What version of Windows are you running? Mine is Win-XP. I don't trust Vista.
Attached Image (click to enlarge)
Click to Enlarge Name: alfredo1.jpg Size: 184 KB
Attached File(s)
File Type: mq4 ExportHistory.mq4   33 KB | 788 downloads
  • #48
  • Jan 25, 2010 3:20am Jan 25, 2010 3:20am
Hello

Thanks for the fast reply.

Well the mistery is solved. Stupid Vista is the secreat.

I use Vista and with your new version of the indicator it doesn´t creat the csv file.

Does anyone had the same problem? Is there any way to solve this. With out desinstal Vista?

Thanks

Alfredo
  • #49
  • Jan 25, 2010 4:30am Jan 25, 2010 4:30am
Quoting Alfredo
Well the mistery is solved. Stupid Vista is the secreat.

I use Vista and with your new version of the indicator it doesn´t creat the csv file.

Does anyone had the same problem? Is there any way to solve this. With out desinstal Vista?
Since I don't use Vista, I can't attempt to troubleshoot the problem.

Hopefully somebody else has an answer?
  • #50
  • Jan 25, 2010 7:34am Jan 25, 2010 7:34am
I have spend some time trying to find a solution. And i have found in FF posts.

Simple instal MT4 on the C: and not in Crograms

Then the csv files will appear on Expertsfiles.


Thanks

Great indicator

Alfredo
  • #51
  • Jan 27, 2010 8:11am Jan 27, 2010 8:11am
The problem is down to the version of Windows, Windows 7 I believe uses virtual drives. I've written numerous vb scripts that use this indicator so I can read the txt files it creates and populate Excel spreadsheets automatically. I sent these scripts to a friend to test them out only to find he couldn't see the txt files that the script was looking for because of the virtual drive feature on other versions of Windows. The scripts work fine asis on XP machines but you need to tweak the parameters for it to work on Windows 7.

Hence why I didn't post up any of the vb scripts on this thread as a follow up to my previous post. It would have caused so much confusion that I'd be troubleshooting my own scripts to work on other operating systems I do nott use.
  • #52
  • Feb 17, 2010 4:49am Feb 17, 2010 4:49am
a very useful indicator, thanks to hanover for a great work.
could be wrong but possibly found incorrect code processing by MetaEditor4 in function DateToStr(), NumberToStr() and err_msg() (see attached file).
Attachment

P.S. some brokers, for example Tadawul FX, already announced beta testing of MetaTrader 5 platform, but ExportHistory.mq4 failed to compile by MetaEditor5 with more than hundred errors. shall a .mql5 version of this indicator be released in near future?
  • #53
  • Feb 17, 2010 5:32am Feb 17, 2010 5:32am
Quoting sergt
a very useful indicator, thanks to hanover for a great work.
could be wrong but possibly found incorrect code processing by MetaEditor4 in function DateToStr(), NumberToStr() and err_msg() (see attached file).
Attachment

P.S. some brokers, for example Tadawul FX, already announced beta testing of MetaTrader 5 platform, but ExportHistory.mq4 failed to compile by MetaEditor5 with more than hundred errors. shall a .mql5 version of this indicator be released in near future?
I wasn't able to open your attachment.

However, please see the previous post (#51). The indicator works fine with MT4 running on Win XP (the only reliable version of Windows, IMO). The DateToStr(), NumberToStr() and err_msg() functions are called by virtually all of the indicators and EAs that I've written. I'm not aware of any errors in the code.

If anybody wants to make the necessary modifications to have it run on MT5, that's fine with me. The source code can be downloaded from post #36.
  • #54
  • Feb 17, 2010 5:55am Feb 17, 2010 5:55am
in any case it works 100%, I used it already. here direct link to that attachment http://www.forexfactory.com/attachme...hmentid=420495.
or just compare 2 strings in MetaEditor4:
Inserted Code
if(StringSubstr(mask, k1, 1)=="'") break;
if(StringSubstr(mask, k1, 1)=="\'") break;
  • #55
  • Feb 17, 2010 11:04am Feb 17, 2010 11:04am
Quoting sergt
in any case it works 100%, I used it already. here direct link to that attachment http://www.forexfactory.com/attachme...hmentid=420495.
or just compare 2 strings in MetaEditor4:
Inserted Code
if(StringSubstr(mask, k1, 1)=="'") break;
if(StringSubstr(mask, k1, 1)=="'") break;
I am sorry. I don't understand what the problem is. Or are you saying that the indicator works 100% now?

When I click on the link to your attachment, I get the error shown in the screenshot below.
Attached Image (click to enlarge)
Click to Enlarge Name: sergt1.JPG Size: 89 KB
  • #56
  • Feb 18, 2010 1:53am Feb 18, 2010 1:53am
As for attachment, yep, seems it is deleted who know the reasons why.
I mean difference is that in first case instruction "break" displayed by MetaEditor4 in green color and in second case - in blue. I didn't say it works incorrect, I said "possibly found incorrect code processing by MetaEditor4". I tried MetaEditor5, and it has not such "bug". But MetaEditor5 refused to compile your indicator because of mismatch of system functions .
hanover, thanks again for a useful tool, but what do you think, is this version of ExportHistory final or you'll release MT5 version later?
  • #57
  • Feb 18, 2010 4:49am Feb 18, 2010 4:49am
Quoting sergt
As for attachment, yep, seems it is deleted who know the reasons why.
I mean difference is that in first case instruction "break" displayed by MetaEditor4 in green color and in second case - in blue. I didn't say it works incorrect, I said "possibly found incorrect code processing by MetaEditor4". I tried MetaEditor5, and it has not such "bug". But MetaEditor5 refused to compile your indicator because of mismatch of system functions .
hanover, thanks again for a useful tool, but what do you think, is this version of ExportHistory...
I answered these questions back in post #53. I have not had a chance to look at MT5 yet. Anybody is welcome to take the existing source code and create a MT5 version of the indicator.
  • #58
  • Sep 18, 2010 5:46am Sep 18, 2010 5:46am
Quoting efmelp
It seems the exported .csv is not sorted from old dated to new dates but rather fro new dates to old dates so there is a diffrent from the manual exported .csv and the exported files by this script can the script be modified to be similar to the normal exported .csv file
Thanks in advance



Hello here is the prefect one

Pleas change the

for(int i=0; i<Bars; i++)

to this

for(int i=Bars-1; i>=0; i--)
  • #59
  • Sep 18, 2010 1:57pm Sep 18, 2010 1:57pm
Quoting sureshhacker
Hello here is the prefect one

Pleas change the

for(int i=0; i<Bars; i++)

to this

for(int i=Bars-1; i>=0; i--)

The question was asked 3 years ago.

The correct answer was provided in the post immediately following, 3 years ago. Now, 3 years later, you provide an answer that fails to take into account the use of two of the parameters (ccy and tf), which allow the script to output history for any pair and any timeframe.

Meanwhile, during the 3 year period, improved versions of the script have been posted, effectively making the question obsolete, in any case.

The person who asked the question has not visited the forum for 5 months.
  • #60
  • Sep 18, 2010 3:23pm Sep 18, 2010 3:23pm
Quoting hanover
The question was asked 3 years ago.

The correct answer was provided in the post immediately following, 3 years ago. Now, 3 years later, you provide an answer that fails to take into account the use of two of the parameters (ccy and tf), which allow the script to output history for any pair and any timeframe.

Meanwhile, during the 3 year period, improved versions of the script have been posted, effectively making the question obsolete, in any case.

The person who asked the question has not visited the forum for 5 months.
Sorry David sir.
today i was searched a program for expert the data file in .csv format and finded that's in this site.. actually i didn't see even the post date of this question.
0 traders viewing now