Intraday Data import

For questions and discussion related to reading in and working with data.
prashantj
Posts: 88
Joined: Sun Apr 11, 2010 2:56 am

Intraday Data import

Unread post by prashantj »

I have intraday data with time step every five minutes interval like 2/13/2020 6:40:00 AM, 2/13/2020 6:45:00 AM etc. Is it possible to import data with time stamp? When I improt the data with the time stamp in variable called "Date", it gives the message: " ## IO30. There is no series DATES on the file"
Prash
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: Intraday Data import

Unread post by TomDoan »

Are those text fields, or are they Excel-coded dates (which are real values with the time-of-day in the fractional part)?
prashantj
Posts: 88
Joined: Sun Apr 11, 2010 2:56 am

Re: Intraday Data import

Unread post by prashantj »

Here is what it looks like in excel. I think it is not coded. This is what I have got when I download from the source. it is every five minutes data.
intraday.jpg
intraday.jpg (30.42 KiB) Viewed 20180 times
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: Intraday Data import

Unread post by TomDoan »

Try changing the numeric format---I'm guessing that they are coded reals.
prashantj
Posts: 88
Joined: Sun Apr 11, 2010 2:56 am

Re: Intraday Data import

Unread post by prashantj »

I tried to change it to different formats but it is not working for me. any other way out to make it readable in RATS? please.
prashantj
Posts: 88
Joined: Sun Apr 11, 2010 2:56 am

Re: Intraday Data import

Unread post by prashantj »

I could not figure it out on my own. Help is appreciated.
Post Reply