Loading High Frequency data

[jenny]

I am trying to load this HFT 1 min data into eviews. I am loading it as an unstructured dataset and trying to create date_time variable which then I could use the pagestruct command to make the workfile a timeseries. So far I have been able to load the data but havent been able to make it time series. What do I do?

Thank you!

[EViews Gareth]

Hard to tell without seeing the data set.

[jenny]

Sorry, I had to shrink it to meet the 2KB limit. Should be attach now. Thank you again. The file extends to the end of the year, so 12/31/2011.

[EViews Chris]

I think this should do the trick

wfload data_del.csv @id @date(dateid) @genr dateid=@dateval(series01, "YYYY.MM.DD")+series02

Note that I'm using addition to combine the day and time-of-day series.

I'm not sure exactly why we're not reading this in automatically. It might be that we're not expecting "." to be used as a Year/Month/Day delimiter. (If you change the incoming data to use '-' we read the file automatically).