Import Excel file with multiple observations per day (time series)
Posted: Thu Jan 17, 2019 4:46 am
Hi!
Im new at using eviews 10. I trying to start a time series analysis about self collected data.
Im trying to import an Excel file with multiple datapoints per day about a time series of like 30-60 days. On some days there are 2 observations and on other days there are 6 observations per day on different times.
My first problem is, that eviews 10 doesnt even recognize that there are more than one observation per day. It recognizes every observation as one day. so i have not 30-60 days but 150 days. I used the Format "Data - regular frequency". Does another format fit better?
My second question is:
In the first column "Date" in excel i used the date format MM/DD/YYYY . I didnt notice the time. Do i need to notice the time in this collumn like "MM/DD/YYYY 00:00:00" or something? Or does the date and the observations in correct order reach out to start a correct time series analysis?
kind regards,
conge
Im new at using eviews 10. I trying to start a time series analysis about self collected data.
Im trying to import an Excel file with multiple datapoints per day about a time series of like 30-60 days. On some days there are 2 observations and on other days there are 6 observations per day on different times.
My first problem is, that eviews 10 doesnt even recognize that there are more than one observation per day. It recognizes every observation as one day. so i have not 30-60 days but 150 days. I used the Format "Data - regular frequency". Does another format fit better?
My second question is:
In the first column "Date" in excel i used the date format MM/DD/YYYY . I didnt notice the time. Do i need to notice the time in this collumn like "MM/DD/YYYY 00:00:00" or something? Or does the date and the observations in correct order reach out to start a correct time series analysis?
kind regards,
conge