Posted By: EternallyCurious
Data from CSV not parsed correctly - 04/18/24 10:45
Hello everybody,
I am having trouble to convert a CSV file to a .t1 file. When I print the parsed values, none of the columns is being correctly parsed and I don't receive any warning or error message.
The CSV file has following format:
I use following lines to parse the file:
Can somebody help me to find the problem?
I attached a sample CSV file and the complete code.
Best regards,
EC
I am having trouble to convert a CSV file to a .t1 file. When I print the parsed values, none of the columns is being correctly parsed and I don't receive any warning or error message.
The CSV file has following format:
Code
Time,AskPrice,BidPrice 1704213005783,49.20,49.10 1704213006179,49.22,49.13 1704213006575,49.23,49.13 1704213007576,49.24,49.13
I use following lines to parse the file:
Code
string Format = "+%t,f,f"; int Year; for(Year = 2024; Year <= 2024; Year++) { dataNew(1,0,0); int records = dataParse(1,Format,strf(CSVFileName,Year), 0, 0); printf("\n%i - %d rows read",Year,records); dataNew(2,0,0); int i, N = 0; for(i = 0; i < records; i++) { var time = dataVar(1,i,0); var askPrice = dataVar(1,i,1); var bidPrice = dataVar(1,i,2); printf("%s: %.2f, %.2f\n", strdate("%Y.%m.%d %H:%M:%S.", time), bidPrice, askPrice); T1* Quote = dataAppendRow(2,2); Quote->time = time; Quote->fVal = -bidPrice; Quote = dataAppendRow(2,2); Quote->time = time; Quote->fVal = askPrice; N += 2; } dataSave(2,strf(OutName,Year), 0, N); // store year dataset printf("\n%s saved",strf(OutName,Year)); }
Can somebody help me to find the problem?
I attached a sample CSV file and the complete code.
Best regards,
EC