Change Date format on MT4 .csv files? | Page 4 | 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?

  • #61
  • Sep 18, 2010 6:23pm Sep 18, 2010 6:23pm
Can some one please tell me how to change the data path of saving file?..
  • #62
  • Sep 18, 2010 10:02pm Sep 18, 2010 10:02pm
Quoting sureshhacker
Can some one please tell me how to change the data path of saving file?..

MT4 will not allow you to do this for security reasons.
  • #63
  • Sep 18, 2010 11:22pm Sep 18, 2010 11:22pm
Quoting sureshhacker
Can some one please tell me how to change the data path of saving file?..
CodeMeister is correct.

This is not possible without rewriting the script to use the Windows API file I/O rather than MQL4 File commands. (See here and here for more info).

The simplest way is to copy the files manually to whatever folder you wish.
  • #64
  • Edited 6:02am Sep 19, 2010 5:46am | Edited 6:02am
if your disk was formatted with NTFS you can simply place a symlink (or a 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 convenient method to break this jail.
  • #65
  • Nov 22, 2010 2:16pm Nov 22, 2010 2:16pm
[IMG]file:///C:/Users/USER1%7E1/AppData/Local/Temp/moz-screenshot.png[/IMG]Hannover, I was looking at the indicator exportHistory, very good indicator, but I needed a change, I will give below a detailed explanation.

(CurrencyPair) remains the same, but may also use the symbols reversed, 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 = "";
Comments = true;

would be possible?
Attached Image (click to enlarge)
Click to Enlarge Name: CSV mt4.jpg Size: 166 KB
  • #66
  • Dec 3, 2010 11:47am Dec 3, 2010 11:47am
Hi Hanover,
I'm a newbie so please forgive any obvious questions! I have the indicator working and saving individual csv files for each currency with EOD daily high & Lows , but what I would like is to save this data for all currencies to one csv file. Is that possible? Basically I think I need to know what to write in the output file parameter box. Thanks for the time spent in writing the indicator and for your advice.

Steve
  • #67
  • Dec 4, 2010 2:12am Dec 4, 2010 2:12am
Quoting plugeventos
[IMG]file:///C:/Users/USER1%7E1/AppData/Local/Temp/moz-screenshot.png[/IMG]Hannover,...
Sorry, I'm not considering any more updates to this indicator, at least in the meantime. Too busy with other work.

The MQ4 source is available (post #47) if anybody else wants to tackle it.

David
  • #68
  • Dec 4, 2010 2:20am Dec 4, 2010 2:20am
Quoting stevefunky
Hi Hanover,
I'm a newbie so please forgive any obvious questions! I have the indicator working and saving individual csv files for each currency with EOD daily high & Lows , but what I would like is to save this data for all currencies to one csv file. Is that possible? Basically I think I need to know what to write in the output file parameter box. Thanks for the time spent in writing the indicator and for your advice.

Steve
Steve,

If you specify an output file (e.g. OutputFile = ALL.CSV), then all output will be directed to that file.

Specify multiple pairs like this:
CurrencyPairs = EU,GU,UJ
or this:
CurrencyPairs = EURUSD,GBPUSD,USDJPY

Hope that helps.

David
  • #69
  • Dec 26, 2010 12:14am Dec 26, 2010 12:14am
Hi hanover and thanks for the indicator
Is there anyway to saves csv files without title row?or we shoud cut it manually?
I mean row 1

Regards
  • #70
  • Feb 14, 2012 5:33am Feb 14, 2012 5:33am
Hanover,

thank you very much for this great indicator.

When I export currency history data everything works great, but on indexes and possibly also on different stocks, the indicator seemingly plots max. 3 digits on the left.

Although I am not a programmer, I found due to the well commented code the lines regarding this, if I am not mistaken. Nevertheless I wasn't able to change the lines so that I receive the correct prices for the index.

E.g. for the DAX_30 on a daily basis, I receive this history line from the history center:

2012.02.13,00:00,6740.0,6775.3,6709.8,6750.0,21105

,and this line from the indicator:

02-13-2012,00:00,740.00000,775.30000,709.80000,750.00000,21105

May I ask you for support?

Thank you very much in advance!

Kindest regards,
secondstone
  • #71
  • Feb 14, 2012 6:05am Feb 14, 2012 6:05am
Quoting secondstone
Hanover,

thank you very much for this great indicator.

When I export currency history data everything works great, but on indexes and possibly also on different stocks, the indicator seemingly plots max. 3 digits on the left.

Although I am not a programmer, I found due to the well commented code the lines regarding this, if I am not mistaken. Nevertheless I wasn't able to change the lines so that I receive the correct prices for the index.

E.g. for the DAX_30 on a daily basis, I receive this history line from the history center:

2012.02.13,00:00,6740.0,6775.3,6709.8,6750.0,21105

,and...
Inserted Code
extern   string     OHLCFmt             = "T3.5";

that line fucks it up. it's up to you to change it to something like T9.9 .

90% of the code should be binned as unnecessary bloatware.
Congratulations ScalaFX for coming out of the closet!
  • #72
  • Feb 14, 2012 8:06am Feb 14, 2012 8:06am
nubcake,

thank you very much for your fast and helpful reply.

Another thing is now the 7 digits after the decimal point. Is there also a place in the code to change that is it only due to the change in the prior mentioned parameter?

Thank you very much in advance!

Kindest regards,
secondstone
  • #73
  • Feb 14, 2012 8:17am Feb 14, 2012 8:17am
Quoting secondstone
nubcake,

thank you very much for your fast and helpful reply.

Another thing is now the 7 digits after the decimal point. Is there also a place in the code to change that is it only due to the change in the prior mentioned parameter?

Thank you very much in advance!

Kindest regards,
secondstone
...... change the number after the decimal point to whatever you want it to be. i said 9.9 only as an exaggerated example.

Inserted Code
//+------------------------------------------------------------------+
string NumberToStr(double n, string mask)
//+------------------------------------------------------------------+
// Formats a number using a mask, and returns the resulting string
// Usage:    string result = NumberToStr(number,mask)
// 
// Mask parameters:
// n = number of digits to output, to the left of the decimal point

///////// n.d = output n digits to left of decimal point; d digits to the right

// -n.d = floating minus sign at left of output
// n.d- = minus sign at right of output
// +n.d = floating plus/minus sign at left of output
//
// These characters may appear anywhere in the string:
//   ( or ) = enclose negative number in parentheses
//   $ or £ or ¥ or € = include floating currency symbol at left of output
//   % = include trailing % sign
//   , = use commas to separate thousands, millions, etc
//   Z or z = left fill with zeros instead of spaces
//   * = left fill with asterisks instead of spaces
//   R or r = round result in rightmost displayed digit
//   B or b = blank entire field if number is 0
//   ~ = show tilde in leftmost position if overflow occurs
//   ; = switch use of comma and period (European format)
//   L or l = left align final string 

////////   T ot t = trim (remove all spaces from) end result
Congratulations ScalaFX for coming out of the closet!
  • #74
  • Feb 14, 2012 8:27am Feb 14, 2012 8:27am
nubcake,

now I understand.

The 9.9 is seperated and means: 9 digits prior to the decimal point and the 9 after the . is meant for 9 digits after the decimal point.

Thank You!

Kindest regards,
secondstone
  • #75
  • Feb 15, 2012 1:30am Feb 15, 2012 1:30am
Quoting nubcake
Inserted Code
extern   string     OHLCFmt             = "T3.5";
that line fucks it up. it's up to you to change it to something like T9.9 .

90% of the code should be binned as unnecessary bloatware.
Who me? Guilty of bloatware?
Guilty for the umpteenth time, no doubt; it's all too easy to let the compiler strip out the uncalled modules.

@secondstone: sorry, I only just saw this now. Looks like your question has meantime been answered. Please post again if you have more questions.
  • #76
  • Feb 15, 2012 1:53am Feb 15, 2012 1:53am
Quoting hanover
Who me? Guilty of bloatware?
Guilty for the umpteenth time, no doubt; it's all too easy to let the compiler strip out the uncalled modules.

@secondstone: sorry, I only just saw this now. Looks like your question has meantime been answered. Please post again if you have more questions.
include files are a coders best friend, second only to caffeine.
Congratulations ScalaFX for coming out of the closet!
  • #77
  • Feb 15, 2012 3:50am Feb 15, 2012 3:50am
@secondstone: sorry, I only just saw this now. Looks like your question has meantime been answered. Please post again if you have more questions.[/quote]

hanover,

thank you for your reply. For now everything works good. We'll see how I manage to get indicator values too. Then maybe additional help could be neccesary.

Kindest regards,
secondstone
  • #78
  • Feb 15, 2012 12:16pm Feb 15, 2012 12:16pm
Quoting nubcake
include files are a coders best friend, second only to caffeine.
Been there, done that. Users install them in the wrong folders, creating more Q&A, more wasted time.......
  • #79
  • Feb 21, 2012 10:46am Feb 21, 2012 10:46am
Hello,

I would like to ask if it's possible to export EOD data with a time shift?

For example, instead of having the EOD data on a close to close basis at 0:00, I would like to have it shifted prior to this time, e.g. from 20:00 to 20:00 or so.

Is that possible at all and could it be implemented in the ExportHistory indicator?

Many thanks in advance.

Kind regards,
secondstone
  • #80
  • Feb 21, 2012 11:34am Feb 21, 2012 11:34am
Quoting secondstone
Hello,

I would like to ask if it's possible to export EOD data with a time shift?

For example, instead of having the EOD data on a close to close basis at 0:00, I would like to have it shifted prior to this time, e.g. from 20:00 to 20:00 or so.

Is that possible at all and could it be implemented in the ExportHistory indicator?

Many thanks in advance.

Kind regards,
secondstone
Just to make sure I understand correctly: you mean that you want the OHLC prices just as if the day begins/ends at 20:00 (or some other time) instead of 00:00 (midnight)?

If so, then it would be possible to modify the ExportHistory indicator to read intraday (e.g. hourly) candles and output OHLC values based on the open, high, low and close across each group of 24 consecutive candles. However, you would need to define how you wanted gaps (i.e. weekends) to be handled. In other words, some intervals from 20:00 hours to 20:00 hours would consist of less than 24 candles.

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

Depending on the answers to the above questions, it might not necessarily be a trivial job, and I'm very busy with other programming work at the moment. The source code is available is any other programmer wishes to attempt it.

Just a thought: A simpler way might be to find a br0ker MT4 whose daily candles begin/end on the hour that meets your requirement.

If you are exporting the data to Excel, you could export hourly candles, and use Excel's functions and facilities to group/summarize every 24 rows of data.
0 traders viewing now