Gaps in time series with N/a values-Macro Announcements/

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

Jakem
Posts: 3
Joined: Wed May 23, 2018 4:26 am

Gaps in time series with N/a values-Macro Announcements/

Postby Jakem » Wed May 23, 2018 8:29 am

Dear Eviews forum,

I want to research the effect of Chinese macro announcements (using the surprise effect) on the volatility of commodity prices (using an index).
These macro announcements are published quarterly/monthly. Furthermore, I have calculated the daily volatility of the index price.

Vol Price index: (12 announcements)
(dependent variable: independent variable)

There are gaps in the data series (days where there are no announcements). I have removed 'no activity' days and still get the error 'insufficient number of observations'.The number of observations per announcement is on average 80 (largest 99, smallest 33).

Is there an explanation for this error? How do gaps in data series get solved without estimating values?
I have attached a screenshot of my excel values to demonstrate it!

Thank you for your help in advance! :)

Greetings,
Jake
Attachments
Capture Excel Eviews Forum.PNG
Capture Excel Eviews Forum.PNG (19.93 KiB) Viewed 2881 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Gaps in time series with N/a values-Macro Announcements/

Postby EViews Gareth » Wed May 23, 2018 9:07 am

When running a regression you need data for every variable in the regression for an observation to be included. i.e. only rows with zero NAs will be used.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 8 guests