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
Matching dates in importing data
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13586
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Matching dates in importing data
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.
-
d.decrombrugghe
- Posts: 2
- Joined: Thu May 07, 2009 11:39 am
Re: Matching dates in importing data
Thank you very much QMS Gareth for the tip. That did it!
(:oops: I had been searching obsolete documentation.)
Denis
(:oops: I had been searching obsolete documentation.)
Denis
-
guero303030
- Posts: 14
- Joined: Sun May 24, 2009 4:28 pm
- Location: Laredo, Texas
- Contact:
Re: Matching dates in importing data (Garch 1,1)
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 :)
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 :)
-
guero303030
- Posts: 14
- Joined: Sun May 24, 2009 4:28 pm
- Location: Laredo, Texas
- Contact:
Re: Matching dates in importing data
P.S. I a using Eviews 7. Thanks. guero303030
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13586
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Matching dates in importing data
Leave it irregular.
-
guero303030
- Posts: 14
- Joined: Sun May 24, 2009 4:28 pm
- Location: Laredo, Texas
- Contact:
Re: Matching dates in importing data
Thanks a bunch. Much appreciated.
Re: Matching dates in importing data
How would i do this if using EVIEWS 6?
Thanks!!
Thanks!!
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13586
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Matching dates in importing data
do what?
Re: Matching dates in importing data
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! :)
Thank-you so much in advance! :)
-
guero303030
- Posts: 14
- Joined: Sun May 24, 2009 4:28 pm
- Location: Laredo, Texas
- Contact:
Re: Matching dates in importing data
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
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
Who is online
Users browsing this forum: No registered users and 1 guest
