Help Writing to csv file

New comment
 

HI, Can anyone help me add the following script code, so that data into a CSV was imported into columns and cells?

//+------------------------------------------------------------------+
int start()
  {
 
 
 
      {
      mPrev=m;
      handle=FileOpen("Data\\Statement.csv",FILE_WRITE|FILE_CSV,",");
      if(handle<0) return(0);
      FileWrite(handle,"Ticket #,Open Time,Type,");
      for(i=0;i<hstTotal;i++)
         {
         if(OrderSelect(i,SELECT_BY_POS,MODE_HISTORY)==true)
            {
            FileWrite(handle,OrderTicket(),TimeToStr(OrderOpenTime(),TIME_DATE|TIME_MINUTES),OrderType(),);
            }
         }
      FileClose(handle);
      }
   return(0);
  }
//+----------------------
 
Question not understood. Create a script. paste code into script. Compile. Drag script onto a chart. Import the file.
 

Hi. I believe that MT4 does not place data into columns or cells....at least not in a way that you can manually open the .csv and see the data listed by column or cell.


This thread might help you

https://forum.mql4.com/28909

 

Your code should work properly except for one minor problem - instead of:

FileWrite(handle,"Ticket #,Open Time,Type,Lots,Symbol,Open Price,Stop/Loss,Take Profit,Close Time,Close Price,Profit,Comment");

Should be:

FileWrite(handle,"Ticket #","Open Time","Type","Lots","Symbol","Open Price","Stop/Loss","Take Profit","Close Time","Close Price","Profit","Comment");

This way the header will be in columns as well.

 
Your code produces a delimited comma-separated cvs file. In my Mac MS Office 2008, I open new Excel file and then IMPORT the cvs file. Then select cvs file type, then select delimited, then select next, then select comma and then select Finish.
New comment
Reason: