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
Intraday Data import
Re: Intraday Data import
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
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 20186 times
Re: Intraday Data import
Try changing the numeric format---I'm guessing that they are coded reals.
Re: Intraday Data import
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
I could not figure it out on my own. Help is appreciated.