Holiday effects and Day of the week effects

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

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

edwardyiu
Posts: 2
Joined: Tue Dec 24, 2013 5:41 am

Holiday effects and Day of the week effects

Postby edwardyiu » Wed Jan 01, 2014 7:33 am

Hi, all EView experts,

I am a new user of the EView8 and I need to do the holiday effects and day of the weeks effect of HSI of Hong Kong for the ten years from 2003 to 2012. I have transformed my working file from excel file to a wf1 file as attached. I am not sure whether this is done correctly. Anyway, the daily stock returns is computed as ln(Rt/Rt-1)*100 and Monday is denoted as 2, Tuesday is denoted as 3 and so on in the file "weekday". The pre-holidays are denoted as -1, -2, ... and post-holidays are denoted as 1,2,.. and so on in the file "CNY" and "Christmas"

For the day of week effects, I would like to do a linear regression to prove whether there exists a day of week effect and assuming
Rw = C + x1(Rmonday) + x2(Rtuesday) +x3(Rwednesday) + x4(Rthursday) + x5(Rfriday) + e
So, how can I perform and add the commands in the EView and generate the analyses as required?

Similarly, I need to do the same analyses for the holidays effect and I assume that this will be done in the same way as day of the weeks effect as requested above. Please correct me if I am wrong.

Please advise me the way to handle the above and thank you for your help.

Best Regards,
Edward Yiu
Attachments
Stock Returns of HSI (Week of the day and holiday effects).xlsx
(211.8 KiB) Downloaded 268 times
stock returns of hsi (week of the day and holiday effects).wf1
(151.37 KiB) Downloaded 234 times

EViews Glenn
EViews Developer
Posts: 2682
Joined: Wed Oct 15, 2008 9:17 am

Re: Holiday effects and Day of the week effects

Postby EViews Glenn » Mon Jan 06, 2014 12:42 pm

Code: Select all

equation eq1.ls dailyreturns @expand(@weekday)
to use the built-in variable, or

Code: Select all

equation eq1.ls dailyreturns @expand(weekday)
to use your coded variable (didn't see it when I wrote the first line).

Note that I left-out the overall constant to avoid dummy-variable induced singularity.

edwardyiu
Posts: 2
Joined: Tue Dec 24, 2013 5:41 am

Re: Holiday effects and Day of the week effects

Postby edwardyiu » Wed Jan 08, 2014 6:34 am

Thanks a lot for your help.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests