How to write contents of variables to a CSV file?

Hello All,

I would like to run an EA in strategy Tester and at the end of the testing (date range) period , write the contents of a number of different variable which I have created into a CSV file. Can this be done?

If this is possible, can anyone advise as to:

1) How would the EA know that the testing period has been completed in Strategy Tester? As I would only need the final variable values once the testing period had been fully completed

2) What code would I need to write to write these variables to a CSV file?


Any advice would be most welcome.

Thanks,

CCH

1: http://docs.mql4.com/basis/function/events#ontester | alternatively isTesting() in the OnDeinit might also work.
2:
You first need to open the fileFileOpen()
Write them to your file FileWrite()
Maybe flush it and FileClose() an example can be found here http://docs.mql4.com/files/filewrite

For 2.
looking, you have create CSV content manually and write to file.
F.e. I dont know the standard function to export data to CSV file.

Hi Killian & Hanzov,

Thanks for your replies. I'll take a look at those functions

Happy Trading 😀

I think, it is possible to find mql code or DLL to create xml content.

to get the data at the end of the test run call DebugFile from OnDeinit() and pass your variables (once converted to strings) using the code below



//+----------------------------------------------------------------------------+
// Outputs up to 8 values to the DEBUG.TXT file (after creating the file, if it doesn't already exist)
//+----------------------------------------------------------------------------+
string DebugFile(string s1, string s2="", string s3="", string s4="", string s5="",
string s6="", string s7="", string s8="")
{
string out = StringTrimRight(StringConcatenate(s1, " ", s2, " ", s3, " ", s4, " ", s5, " ", s6, " ", s7, " ", s8));
int h = FileOpen("debug.txt",FILE_READ|FILE_WRITE|FILE_CSV|FILE_COMMON );
FileSeek(h,0,SEEK_END);
FileWrite(h,out);
FileClose(h);
return(0);
}