Page 1 of 1

Matching dates in importing data

Posted: Thu May 07, 2009 12:21 pm
by d.decrombrugghe
Hello,
Is there a way to import a data set with dates included such that EViews will match these dates and generate the necessary NAs for omitted dates?
(I am thinking of long series of daily weekday data that come with dates but with bank holidays omitted. It is very inconvenient to manipulate this data to create the 5-day weeks that EViews expects.)
Many thanks for any hints.
Denis

Re: Matching dates in importing data

Posted: Thu May 07, 2009 1:03 pm
by EViews Gareth
Structuring your page a "dated with ID series", and then using the date series you have as that ID series, pretty much does what you want.

Re: Matching dates in importing data

Posted: Thu May 14, 2009 10:17 am
by d.decrombrugghe
Thank you very much QMS Gareth for the tip. That did it!
(:oops: I had been searching obsolete documentation.)
Denis

Re: Matching dates in importing data (Garch 1,1)

Posted: Thu Mar 18, 2010 8:45 am
by guero303030
Dear Eviews,
To follow up on the last response and question, "Structuring your page a "dated with ID series", and then using the date series you have as that ID series, pretty much does what you want." This helped me as well. It has been a while since I used eviews so I am rusty. It is great and the support is even better.
Question:
I am using daily stock market index data and going on to measure volatility among other things. When I am inputting my daily data, Is it best to use "Insert empty obs to remove gaps" due to holidays, weekends, etc. and have a structured file or is it ok to use the daily data as is, structured as irregular, only trading days, especially if I am going to go on to measure and analyze volatility using Garch(1,1). thanks so much, and I would really appreciate any insight. Guero303030 :)

Re: Matching dates in importing data

Posted: Thu Mar 18, 2010 8:48 am
by guero303030
P.S. I a using Eviews 7. Thanks. guero303030

Re: Matching dates in importing data

Posted: Thu Mar 18, 2010 8:52 am
by EViews Gareth
Leave it irregular.

Re: Matching dates in importing data

Posted: Thu Mar 18, 2010 9:25 am
by guero303030
Thanks a bunch. Much appreciated.

Re: Matching dates in importing data

Posted: Fri May 21, 2010 10:22 pm
by phil_jp
How would i do this if using EVIEWS 6?

Thanks!!

Re: Matching dates in importing data

Posted: Fri May 21, 2010 11:34 pm
by EViews Gareth
do what?

Re: Matching dates in importing data

Posted: Sat May 22, 2010 1:31 am
by phil_jp
i am importing daily stock volume traded and daily stock value traded into eviews. this dataset has observations omitted for days where the share was suspended or not traded. however it is my understanding that i need to convert this to 5-day trading data, i.e., to insert 0 value observations for the days omitted. i'm not sure how to do this though!! can someone please help me?

Thank-you so much in advance! :)

Re: Matching dates in importing data

Posted: Sat May 22, 2010 7:24 am
by guero303030
to: phil_jp
I am not an expert on eviews but I use it frequently. you might do what MS_Gareth is suggesting and when you set up your workfile, use irregular frequency, and then import your data. For the trading days, where there is no data, use n/a or just leave blank in your spreadsheat before importing it into eviews 6.0. I have had both versions. Good Luck. Guero303030 :D