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
-
TomDoan
- Posts: 7825
- Joined: Wed Nov 01, 2006 4:36 pm
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)?
-
prashantj
- Posts: 88
- Joined: Sun Apr 11, 2010 2:56 am
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 21518 times
-
TomDoan
- Posts: 7825
- Joined: Wed Nov 01, 2006 4:36 pm
Re: Intraday Data import
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
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
I could not figure it out on my own. Help is appreciated.