Data Import Format
5 replies
mc74
9 years ago #116474
Hi
May I ask whether SQ accepts the following “Time” column when importing data?
The website says “Any program supporting the DBC Signal or the DDE protocols can receive quotes ” including Tradestation 9.1
Date Time Open High Low Close
0
Tomas Matejka
9 years ago #142045
Hello,
how did you get this data? What those time values represents?
0
mc74
9 years ago #142051
I got the data from quoteroom, i checked the column details, it appears to be the counts by minutes. it goes from 0001 to 2359 and starts on the next Day with 0001 again.
0
Tomas Matejka
9 years ago #142067
Hello,
can you attach few lines of data in CSV?
0
mc74
9 years ago #142084
tomas262
pls find attached file for reference
thanks
0
Mark Fric
9 years ago #142110
the file can be imported, but you have to specify the correct date format in the Import dialog.
The format that matches the data in your CSV file is: MM/dd/yyyy HHmm
Or alternatively it could be dd/MM/yyyy HHmm – I’m not sure if day or month is first in your date.
Mark
StrategyQuant architect
0
Viewing 5 replies - 1 through 5 (of 5 total)