Hi all,

I'm trying to add some new functionality to my ExportData strategy. As it is, it will write the DateTime format to a file based on your systems settings. Current code is:

 

Code

string data = (Time[0] + dataSeparator + Open[0] + dataSeparator + High[0] + dataSeparator + Low[0] + dataSeparator + Close[0] + dataSeparator + Volume[0]); if (splitDateTime == true) { //Replace the space in DateTime with the DataSeparator data = data.Replace(@" ",dataSeparator); } sw.WriteLine(data);

So Time[0] outputs a DateTime struct based on your Windows settings. I would like to add an enum that allows the user to choose an output format of choice, using (for example)

 

Code

string data = (Time[0].ToString("yy-MM-dd HH:mm:ss") etc etc (pseudocode)

I know I can't use special characters in enums and I can work around that. My issue is that something as basic as this:

 

Code

bool x = true; if(x) { string data = (Time[0] + dataSeparator + Open[0] + dataSeparator + High[0] + dataSeparator + Low[0] + dataSeparator + Close[0] + dataSeparator + Volume[0]); }

... outputs a blank file (actually one that only has carriage returns).

So I can hard-code the output DateTime format but any time I try to give the user an option that is called either in OnStartUp() or OnBarUpdate() I get a blank output file.

Any thoughts I what I could be doing wrong?

Full code attached.

MXASJ 

So I can hard-code the output DateTime format but any time I try to give the user an option that is called either in OnStartUp() or OnBarUpdate() I get a blank output file. Any thoughts I what I could be doing wrong?

Wild guess - the file isn't being opened or closed in the right order, maybe check your Print() statements to make sure they contain data, and if so, then it's definitely an issue with how the file is opened or closed as data is being written to it. Assuming you checked the Log tab for errors? The path resides in the Users\Documents directory (write access)?

Mike

Thanks Mike. Making some positive progress with this in OnBarUpdate():

 

Code

switch(dateTimeFormat) { case MyDateTime.PCTimeFormat: { string data = (Time[0] + dataSeparator + Open[0] + dataSeparator + High[0] + dataSeparator + Low[0] + dataSeparator + Close[0] + dataSeparator + Volume[0]); if (splitDateTime == true) { //Replace the space in DateTime with the DataSeparator data = data.Replace(@" ",dataSeparator); } sw.WriteLine(data); break; } case MyDateTime.ISO8601Basic: { string data = (Time[0].ToString("yyyyMMdd HHmmss") + dataSeparator + Open[0] + dataSeparator + High[0] + dataSeparator + Low[0] + dataSeparator + Close[0] + dataSeparator + Volume[0]); if (splitDateTime == true) { //Replace the space in DateTime with the DataSeparator data = data.Replace(@" ",dataSeparator); } sw.WriteLine(data); break; } case MyDateTime.ISO8601Extended: { string data = (Time[0].ToString("yyyy-MM-dd HH:mm:ss") + dataSeparator + Open[0] + dataSeparator + High[0] + dataSeparator + Low[0] + dataSeparator + Close[0] + dataSeparator + Volume[0]); if (splitDateTime == true) { //Replace the space in DateTime with the DataSeparator data = data.Replace(@" ",dataSeparator); } sw.WriteLine(data); break; } }

Still needs a bit of testing and cleanup but if anyone wants to try my latest ExportData strategy and take a particular look at DateTime output formats that would be great. Open to suggestions on ways to make it better.

cs file attached.