exporting data into excel

[mohsen bahrami]

hi traders

i'm making an EA and I have some arrays derived from it and i want to export them to an excel file to analyse separately in excel.

is there any way to do it?

thank you.

[graziani]

   //int handle = FileOpen("test.csv", FILE_READ | FILE_WRITE | FILE_COMMON | FILE_CSV | FILE_ANSI,  (ushort)';');
   int handle = FileOpen("test.csv", FILE_READ | FILE_WRITE | FILE_CSV | FILE_ANSI, (ushort)';');
   if (handle == INVALID_HANDLE)
   {  Alert("OnTesterPass(): FileOpen returned invalid handle");
      Print("OnTesterPass(): FileOpen returned invalid handle");
      return;
   }

   FileSeek(handle, 0, SEEK_END);

   while(FrameNext(pass, name, id, val, data))
   {
      Print("pass=",pass,", name=",name,", id=",id,", val=",val);

      FileWrite(handle,
               DoubleToString(data[0], 1),
               DoubleToString(data[1], 1),
               DoubleToString(data[2], 2),
               DoubleToString(data[3], 2),
               data[4],
               DoubleToString(data[5], 1),
               data[6],
               DoubleToString(data[7],1)
               );
   }

   FileClose(handle);

this is how you create a csv file, in this case data[] is received from other population instances during backtest (FrameAdd()/FrameNext()) and added in csv file on each iteration.

[mohsen bahrami]

graziani:
this is how you create a csv file, in this case data[] is received from other population instances during backtest (FrameAdd()/FrameNext()) and added in csv file on each iteration.

thank you

[tush1822]

HI Mate,

is it possible to run this routine for OnTick ()?

I am trying but its not working.

for instance once the RSI cross the 70 , I want to export that value against the time.

Cheers

Tysae