Data Import Format

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

File: AUD.png

File: AUD2.png

Hello,

how did you get this data? What those time values represents?

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. 

Hello,

can you attach few lines of data in CSV? 

tomas262

pls find attached file for reference

thanks

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.