Export Datas to MT4 | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Metatrader Export: how to export objects and text in chart? 5 replies

multicurrency datas with OnChartEvent() and EventChartCustom() 24 replies

MT4 export to Excel? 8 replies

VSA broker history change datas 11 replies

Getting raw datas 0 replies

Export Datas to MT4

  • #1
  • First Post: Feb 7, 2010 2:47pm Feb 7, 2010 2:47pm
Hi everybody,

I would like to coding or finding a EA or a script which exports two types of datas into two separates CSV files:

 

  1. My account history, it should be export automaticly one time par day (it could be a parameter of this script/EA
  2. All my Open Trades every 5 minutes.


I have already coding a script which export all Open Trades but it's not automaticly, i have to drag and drop all the time for execute the script.

How can i automate that ? With an E/A or by a loop into the script ?

Thank you in advance for your helps.

Best Regards

Chris

  • #2
  • Feb 7, 2010 6:11pm Feb 7, 2010 6:11pm
IF you have a script that is fully functional then getting it to do the rest shouldn't be very difficult. You will have to convert it to an EA which won't be too hard if your script is structured properly.

You have to identify what goes into the Init function - once only code and what goes into the Start function - repetitive code. To control the execution of once every 5 minutes, I would put it on a 5M chart and add the following (barStart is static variable of type Datetime).

If (Time[0] > barStart)
{
barStart = Time[0];
....rest of logic
}

To get it to work once a day, I would have an input variable called HistoryTOD of type int. Then compare this to the current time like this (historyDone is a static bool variable )

If (Hour() == HistoryTOD && !historyDone)
{
historyDone = true;
...rest of logic
}

In order to reset historyDone, put this code somewhere near the end of the Start function.

If (Hour() < HistoryTOD && Minute == 1) historyDone = false;


There are other ways to do this, but this should work OK.
  • #3
  • Feb 14, 2010 6:41am Feb 14, 2010 6:41am
Thank you CodeMeister for you respond, but i don't all understand that you have write.

For example, if i give you my code script, how you convert it in an EA ? It's not simple with some pieces of codes.

My code script is :

Inserted Code
#property copyright "Copyright © 2010, MetaQuotes Software Corp."
#property link      "http://www.metaquotes.net"


int handle;
//+------------------------------------------------------------------+
//| expert initialization function                                   |
//+------------------------------------------------------------------+
int init()
  {
  
//----
   
   int p = Period();

   
   string filename = StringConcatenate("open_orders", ".csv");

   handle = FileOpen(filename, FILE_CSV|FILE_WRITE, ';');


//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert deinitialization function                                 |
//+------------------------------------------------------------------+
int deinit()
  {
//----
   
//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert start function                                            |
//+------------------------------------------------------------------+
int start()
  {
//----

  int total = OrdersTotal();
  FileWrite(handle, "Order Ticket", "Order Date", "Type", "Volume", "Order Symbol", "Price", "Stop Loss");
  for(int i=total-1;i>=0;i--)
  {
    OrderSelect(i, SELECT_BY_POS);
    int type   = OrderType();
    int OTicket = OrderTicket();
    datetime OTime = OrderOpenTime();
    double OLots = OrderLots();
    double OOpenPrice = OrderOpenPrice();
    double OStopLoss = OrderStopLoss();
    string OSymbol = OrderSymbol();
    string LineToWrite = "";
    
    
    bool result = false;
    
    switch(type)
    {
      //Close opened long positions
      case OP_BUY       : FileWrite(handle, DoubleToStr(OTicket, 1), TimeToStr(OTime), "BUY", DoubleToStr(OLots, 3), OSymbol, DoubleToStr(OOpenPrice, 5), DoubleToStr(OStopLoss, 5)) ;
                          break;
      
      //Close opened short positions
      case OP_SELL      : FileWrite(handle, DoubleToStr(OTicket, 1), TimeToStr(OTime), "SELL", DoubleToStr(OLots, 3), OSymbol, DoubleToStr(OOpenPrice, 5), DoubleToStr(OStopLoss, 5));
                          break;
     }
    
   if(handle<1)
    {
     Print("can't open file error-",GetLastError());
     return(0);
    }

  }
  
//----
   return(0);
  }
I will try to convert it myself, but I'm novice in mql langage... so it take time.

Have a nice Valentine day.

Regards,

Chris
  • #4
  • Feb 14, 2010 1:47pm Feb 14, 2010 1:47pm
It takes time for experienced coders to do this kind of work as well - despite ourselves we all make mistakes and code needs to be verified and tested to exhaustion. So I am not going to do the work for you.

I did a quick review of the script and it appears to be structured properly, so that is a good start. I would put the file writing logic into a function so that it can be called by both the daily and 5 minute update.

Start by adding an input called HistoryTOD of type int. Then compare this to the current time like this (historyDone is a static bool variable )

If (Hour() == HistoryTOD && !historyDone)
{
historyDone = true;
...rest of logic
}

In order to reset historyDone, put this code somewhere near the end of the Start function.

If (Hour() < HistoryTOD && Minute == 1) historyDone = false;


Once this part is working, try adding the 5 minute logic. Don't try to do everything at once - it much easier to work in increments.
  • #5
  • Feb 25, 2010 2:25pm Feb 25, 2010 2:25pm
Hi,

I've found a solution for my requirement with my own method, let's take a look . (It's possible to define the frequency of export with an extern variable "minutes")

If you want, you can comment it

Inserted Code
   //+------------------------------------------------------------------+
//|                                                         test.mq4 |
//|                      Copyright © 2010, MetaQuotes Software Corp. |
//|                                        http://www.metaquotes.net |
//+------------------------------------------------------------------+

#property copyright "Chris"
#property link      ""

#property indicator_chart_window

extern int  minutes=5;
int         NextTime ;
int         handle;
string      filename;


//+------------------------------------------------------------------+
//| expert initialization function                                   |
//+------------------------------------------------------------------+
int init()
  {
//----
   
   
   
   NextTime = (Minute() + 2) % 60;
     
   filename = StringConcatenate("open_orders", ".csv");
         
   WriteAllOpenOrdersIntoFile();
   


   
//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert deinitialization function                                 |
//+------------------------------------------------------------------+
int deinit()
  {
//----
   
//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert start function                                            |
//+------------------------------------------------------------------+
int start()
  {
//----


   
   if (NextTime <= Minute())
   {
      
      WriteAllOpenOrdersIntoFile();
      NextTime = (Minute() + minutes) % 60;
   }
//----
   return(0);
  }
//+------------------------------------------------------------------+



void  WriteAllOpenOrdersIntoFile() 
{

handle = FileOpen(filename, FILE_CSV|FILE_WRITE, ';');

FileWrite(handle, "Order Ticket", "Order Date", "Type", "Volume", "Order Symbol", "Price", "Stop Loss", "Commission", "Swap");

int total = OrdersTotal();
  
  for(int i=total-1;i>=0;i--)
  {
    OrderSelect(i, SELECT_BY_POS);
    int type   = OrderType();
    int OTicket = OrderTicket();
    datetime OTime = OrderOpenTime();
    double OLots = OrderLots();
    double OOpenPrice = OrderOpenPrice();
    double OStopLoss = OrderStopLoss();
    double OCommission = OrderCommission();
    double OSwap = OrderSwap();
    string OSymbol = OrderSymbol();
    string LineToWrite = "";
    
    
    bool result = false;
    
    switch(type)
    {
      //Close opened long positions
      case OP_BUY       : FileWrite(handle, DoubleToStr(OTicket, 1), TimeToStr(OTime), "BUY", DoubleToStr(OLots, 3), OSymbol, DoubleToStr(OOpenPrice, 5), DoubleToStr(OStopLoss, 5), DoubleToStr(OCommission, 5),DoubleToStr(OSwap, 5)) ;
                          break;
      
      //Close opened short positions
      case OP_SELL      : FileWrite(handle, DoubleToStr(OTicket, 1), TimeToStr(OTime), "SELL", DoubleToStr(OLots, 3), OSymbol, DoubleToStr(OOpenPrice, 5), DoubleToStr(OStopLoss, 5), DoubleToStr(OCommission, 5),DoubleToStr(OSwap, 5));
                          break;
     }
    
   if(handle<1)
    {
     Print("can't open file error-",GetLastError());
     return(0);
    }

  }
 
FileClose(handle); 
return(0);


}
  • #6
  • Last Post: Feb 25, 2010 3:41pm Feb 25, 2010 3:41pm
This looks pretty reasonable. Its not the way I would do it, but it should work. Of course the easy part was writing it. Now it has to be tested and fixed.

One thing I don't understand. Is the daily update to come in the next version or has that requirement gone away?
0 traders viewing now