Page 1 of 1
Intraday Data import
Posted: Mon Nov 23, 2020 9:29 pm
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
Re: Intraday Data import
Posted: Tue Nov 24, 2020 10:44 am
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)?
Re: Intraday Data import
Posted: Tue Nov 24, 2020 12:40 pm
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 (30.42 KiB) Viewed 20182 times
Re: Intraday Data import
Posted: Tue Nov 24, 2020 1:43 pm
by TomDoan
Try changing the numeric format---I'm guessing that they are coded reals.
Re: Intraday Data import
Posted: Tue Nov 24, 2020 2:06 pm
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.
Re: Intraday Data import
Posted: Fri Dec 18, 2020 12:18 pm
by prashantj
I could not figure it out on my own. Help is appreciated.