Trying to parse a simple csv:
1371,EUR/USD,TRD,79701,-0.055
1371,EUR/USD,TRD,79703,-0.055
1371,EUR/USD,TRD,82601,-0.102
1371,EUR/USD,TRD,86602,1.117
1371,EUR/USD,TRD,86802,1.373
The format I use:
string sFormat = "0,i,sss,sss,i,f";
this is the testing code:
#define _storedRER "Data\storedRER.csv"
#define _storedTradeSize 50000 //1.000 trades (1.000 char [50])
#define _sTradeSize 50
void storeTrade(){
int iCounter = 0;
char sTrade[_sTradeSize];
string sDel=",", ls;
string sFormat = "%i%s%s%s%s%s%i%s%.3f";
for(closed_trades){
if (TradeIsPhantom && TradeIsClosed && TradeBarClose == Bar){
if(TradeIsShort) ls = "S"; else ls = "L";
sprintf(sTrade, sFormat, TradeBarClose, sDel, TradeAsset, sDel, TradeAlgo, sDel, TradeID, sDel, TradeProfit );
strcat (sTrade, "rn");
file_appendfront(_storedRER, sTrade, 0);
// printf("n");
// print(TO_WINDOW ,"n%s", sTrade);
}
}
}
void readTrade(){
// string sFormat = "%i%s%s%s%s%s%i%s%.3f";
string sFormat = "0,i,sss,sss,i,f";
int iHandle, iCounter;
iCounter = dataParse(iHandle, sFormat, _storedRER); //, sFilter
printf("n%i", iCounter);
dataNew(iHandle,0,0);
}
void main() {
set(LOGFILE);
Verbose = 7|DIAG;
readTrade();
}
No info is generated in the log file.
The output is always 0.
2 questions:
- Why no data are parsed?
- If I want to filter the data set only EUR/USD is the filter string ",EUR/USD,,," correct?
Thank you