Hi, das Script habe ich, weiß nicht mehr genau woher :-) Es scheibt die Historie des Metatraders je nach Einstellung in der Kontohistorie. Ganz brauchbar, für Analysen gibt es ja gute Tools. Man muss Excel nicht unbedingt neu erfinden... Vielleicht kann Du was für Deinen Code verwenden.
//+------------------------------------------------------------------+
//| Copyright 2014, MetaQuotes Software Corp.
//|
http://www.mql5.com
//+------------------------------------------------------------------+
#property copyright "Copyright 2014, MetaQuotes Software Corp."
#property link "http://www.mql5.com"
#property version "1.00"
#property strict
//+------------------------------------------------------------------+
//| Script program start function |
//+------------------------------------------------------------------+
void OnStart()
{
int i;
//---
int Tickets[], _HistoryTotal = OrdersHistoryTotal(), _HistoryValidate = 0, _GetLastError;
ArrayResize( Tickets, _HistoryTotal );
for ( i = 0; i < _HistoryTotal; i++ )
{
if ( !OrderSelect( i, SELECT_BY_POS, MODE_HISTORY ) )
continue;
Tickets[_HistoryValidate] = OrderTicket();
_HistoryValidate ++;
}
if ( _HistoryValidate <= 0 )
{
Print( "ReportToCSV: nix gfunda!" );
return;
}
ArrayResize( Tickets, _HistoryValidate );
ArraySort( Tickets );
string file_name = "WriteHistory.txt"; // string file_name = "History2Csv.csv"; geändert Peter
int file_handle = FileOpen ( file_name, FILE_WRITE|FILE_CSV, '\t' );
if ( file_handle < 0 )
{
_GetLastError = GetLastError();
Print( "History2Csv ( FileOpen( \"", file_name, "\", FILE_WRITE ) - Error #", _GetLastError, " ( ", ErrorDescription( _GetLastError ), " )" );
return;
}
FileWrite( file_handle,
"Konto",
"Magic",
"Symbol",
"Ticket",
"OpenTime",
"Type",
"Volume",
"CloseTime",
"Commission",
"Swap",
"Profit",
"Comment"/*,
"DayOpen",
"MonthOpen",
"YearOpen",
"HourOpen",
"MinuteOpen",
"DayClose",
"MonthClose",
"YearClose",
"HourClose",
"MinuteClose"*/
);
for ( i = 0; i < _HistoryValidate; i++ )
{
if ( !OrderSelect( Tickets[i], SELECT_BY_TICKET ) )
continue;
double dLot = OrderLots();
double dSwap = OrderSwap();
double dCommission = OrderCommission();
double dProfit = OrderProfit();
// Print(dProfit);
string sLot = DoubleToStr( dLot, 2 );
string sSwap = DoubleToStr( dSwap, 2 );
string sCommission = DoubleToStr( dCommission, 2);
string sProfit = DoubleToStr( dProfit, 2 );
// Print(sProfit);
// Print(StringReplace(sProfit, ".", ","));
StringReplace(sLot, ".", ",");
StringReplace(sSwap, ".", ",");
StringReplace(sCommission, ".", ",");
StringReplace(sProfit, ".", ",");
if (OrderComment() != "cancelled")
{
FileWrite( file_handle,
AccountNumber(),
OrderMagicNumber(),
OrderSymbol(),
Tickets[i],
TimeToStr( OrderOpenTime() ),
strOrderType( OrderType() ),
sLot,
TimeToStr( OrderCloseTime() ),
sCommission,
sSwap,
sProfit,
OrderComment()/*,
TimeDay(OrderOpenTime()),
TimeMonth(OrderOpenTime()),
TimeYear(OrderOpenTime()),
TimeHour(OrderOpenTime()),
TimeMinute(OrderOpenTime()),
TimeDay(OrderCloseTime()),
TimeMonth(OrderCloseTime()),
TimeYear(OrderCloseTime()),
TimeHour(OrderCloseTime()),
TimeMinute(OrderCloseTime())*/
);
}
}
FileClose( file_handle );
Alert("fertig.");
}
//+------------------------------------------------------------------+
/////////////////////////////////////////////////////////////////////////////////
/**/ string strOrderType( int intOrderType )
/////////////////////////////////////////////////////////////////////////////////
// âîçâðÃ*ùÃ*åò OrderType â âèäå òåêñòÃ*
/////////////////////////////////////////////////////////////////////////////////
{
switch ( intOrderType )
{
case OP_BUY: return ("Buy");
case OP_SELL: return ("Sell");
case OP_BUYLIMIT: return ("BuyLimit");
case OP_BUYSTOP: return ("BuyStop");
case OP_SELLLIMIT: return ("SellLimit");
case OP_SELLSTOP: return ("SellStop");
default: return ("UnknownOrderType");
}
}
string ErrorDescription( int error_code )
{
string error_string;
//----
switch ( error_code )
{
//---- codes returned from trade server
case 0:
case 1: error_string = "no error";
break;
case 2: error_string = "common error";
break;
case 3: error_string = "invalid trade parameters";
break;
case 4: error_string = "trade server is busy";
break;
case 5: error_string = "old version of the client terminal";
break;
case 6: error_string = "no connection with trade server";
break;
case 7: error_string = "not enough rights";
break;
case 8: error_string = "too frequent requests";
break;
case 9: error_string = "malfunctional trade operation (never returned error)";
break;
case 64: error_string = "account disabled";
break;
case 65: error_string = "invalid account";
break;
case 128: error_string = "trade timeout";
break;
case 129: error_string = "invalid price";
break;
case 130: error_string = "invalid stops";
break;
case 131: error_string = "invalid trade volume";
break;
case 132: error_string = "market is closed";
break;
case 133: error_string = "trade is disabled";
break;
case 134: error_string = "not enough money";
break;
case 135: error_string = "price changed";
break;
case 136: error_string = "off quotes";
break;
case 137: error_string = "broker is busy (never returned error)";
break;
case 138: error_string = "requote";
break;
case 139: error_string = "order is locked";
break;
case 140: error_string = "long positions only allowed";
break;
case 141: error_string = "too many requests";
break;
case 145: error_string = "modification denied because order too close to market";
break;
case 146: error_string = "trade context is busy";
break;
case 147: error_string = "expirations are denied by broker";
break;
case 148: error_string = "amount of open and pending orders has reached the limit";
break;
//---- mql4 errors
case 4000: error_string = "no error (never generated code)";
break;
case 4001: error_string = "wrong function pointer";
break;
case 4002: error_string = "array index is out of range";
break;
case 4003: error_string = "no memory for function call stack";
break;
case 4004: error_string = "recursive stack overflow";
break;
case 4005: error_string = "not enough stack for parameter";
break;
case 4006: error_string = "no memory for parameter string";
break;
case 4007: error_string = "no memory for temp string";
break;
case 4008: error_string = "not initialized string";
break;
case 4009: error_string = "not initialized string in array";
break;
case 4010: error_string = "no memory for array\' string";
break;
case 4011: error_string = "too long string";
break;
case 4012: error_string = "remainder from zero divide";
break;
case 4013: error_string = "zero divide";
break;
case 4014: error_string = "unknown command";
break;
case 4015: error_string = "wrong jump (never generated error)";
break;
case 4016: error_string = "not initialized array";
break;
case 4017: error_string = "dll calls are not allowed";
break;
case 4018: error_string = "cannot load library";
break;
case 4019: error_string = "cannot call function";
break;
case 4020: error_string = "expert function calls are not allowed";
break;
case 4021: error_string = "not enough memory for temp string returned from function";
break;
case 4022: error_string = "system is busy (never generated error)";
break;
case 4050: error_string = "invalid function parameters count";
break;
case 4051: error_string = "invalid function parameter value";
break;
case 4052: error_string = "string function internal error";
break;
case 4053: error_string = "some array error";
break;
case 4054: error_string = "incorrect series array using";
break;
case 4055: error_string = "custom indicator error";
break;
case 4056: error_string = "arrays are incompatible";
break;
case 4057: error_string = "global variables processing error";
break;
case 4058: error_string = "global variable not found";
break;
case 4059: error_string = "function is not allowed in testing mode";
break;
case 4060: error_string = "function is not confirmed";
break;
case 4061: error_string = "send mail error";
break;
case 4062: error_string = "string parameter expected";
break;
case 4063: error_string = "integer parameter expected";
break;
case 4064: error_string = "double parameter expected";
break;
case 4065: error_string = "array as parameter expected";
break;
case 4066: error_string = "requested history data in update state";
break;
case 4099: error_string = "end of file";
break;
case 4100: error_string = "some file error";
break;
case 4101: error_string = "wrong file name";
break;
case 4102: error_string = "too many opened files";
break;
case 4103: error_string = "cannot open file";
break;
case 4104: error_string = "incompatible access to a file";
break;
case 4105: error_string = "no order selected";
break;
case 4106: error_string = "unknown symbol";
break;
case 4107: error_string = "invalid price parameter for trade function";
break;
case 4108: error_string = "invalid ticket";
break;
case 4109: error_string = "trade is not allowed in the expert properties";
break;
case 4110: error_string = "longs are not allowed in the expert properties";
break;
case 4111: error_string = "shorts are not allowed in the expert properties";
break;
case 4200: error_string = "object is already exist";
break;
case 4201: error_string = "unknown object property";
break;
case 4202: error_string = "object is not exist";
break;
case 4203: error_string = "unknown object type";
break;
case 4204: error_string = "no object name";
break;
case 4205: error_string = "object coordinates error";
break;
case 4206: error_string = "no specified subwindow";
break;
default: error_string = "unknown error";
}
//----
return (error_string);
}