Esportare Dati MT5 in Excel — 3 Metodi con Codice MQL5 Reale

//+------------------------------------------------------------------+
// ExportTrades.mq5 — Export storia trade in CSV per Excel           |
// Manuel Trotta — MTInvestments — P.IVA 14349331000                 |
//+------------------------------------------------------------------+
#property script_show_inputs

input datetime InpFrom = D'2024.01.01';  // Data inizio
input datetime InpTo   = D'2026.12.31';  // Data fine
input string   InpFile = "oracle_trades.csv";

void OnStart()
{
   // Carica storia nell'intervallo
   if(!HistorySelect(InpFrom, InpTo))
   {
      Print("HistorySelect fallito");
      return;
   }

   // Apri file CSV in scrittura
   int fh = FileOpen(InpFile,
                    FILE_WRITE | FILE_CSV | FILE_ANSI,
                    ";");   // separatore ; per Excel IT

   if(fh == INVALID_HANDLE)
   {
      Print("FileOpen fallito: ", GetLastError());
      return;
   }

   // ── Header CSV ──────────────────────────────────────
   FileWrite(fh,
      "Ticket", "Data", "Simbolo", "Tipo",
      "Volume", "Prezzo_Entry", "Prezzo_Exit",
      "SL", "TP", "Profitto_USD",
      "Durata_Minuti", "R_Multiplo");

   // ── Ciclo sui deal ──────────────────────────────────
   int total = (int)HistoryDealsTotal();
   int count = 0;

   for(int i = 0; i < total; i++)
   {
      ulong ticket = HistoryDealGetTicket(i);
      if(ticket == 0) continue;

      // Solo deal di uscita (DEAL_ENTRY_OUT)
      long entry = HistoryDealGetInteger(ticket, DEAL_ENTRY);
      if(entry != DEAL_ENTRY_OUT) continue;

      string sym    = HistoryDealGetString(ticket,  DEAL_SYMBOL);
      double profit = HistoryDealGetDouble(ticket,  DEAL_PROFIT);
      double vol    = HistoryDealGetDouble(ticket,  DEAL_VOLUME);
      double price  = HistoryDealGetDouble(ticket,  DEAL_PRICE);
      datetime t   = (datetime)HistoryDealGetInteger(ticket, DEAL_TIME);
      long  dtype  = HistoryDealGetInteger(ticket,  DEAL_TYPE);

      // Calcolo R-multiplo: profit / (SL_pips * pip_value * volume)
      // (semplificato — usa SL dell'ordine corrispondente)
      double rMultiple = profit / (400.0 * vol); // SL fisso 400 punti demo

      FileWrite(fh,
         ticket,
         TimeToString(t, TIME_DATE|TIME_MINUTES),
         sym,
         (dtype == DEAL_TYPE_BUY) ? "BUY" : "SELL",
         vol,
         price,
         price,     // exit price (deal di uscita)
         0,         // SL storico — recupera da HistoryOrders
         0,         // TP storico
         profit,
         0,         // durata minuti da calcolare
         rMultiple);
      count++;
   }

   FileClose(fh);
   PrintFormat("Esportati %d trade in %s", count, InpFile);
   PrintFormat("File in: %s\\MQL5\\Files\\%s",
               TerminalInfoString(TERMINAL_DATA_PATH), InpFile);
}