EViews.com

I am a new user of EViews, now doing a project which need to calculate the day of the week & monthly return and standard deviation base on index.

Up on now, I have calculated the daily return by:
drl=log(y/y(-1))

For the monthly return, I don't know how can I change the equation so that I can get result.

Would you please advise what should I do?

Thank you in advance.

How are you defining monthly return?

the monthly return is:

Log (closing of current/closing of last month)

In other words, only compare the closing of each month, then get the return in % by log.

I really don't know how to take the last obs of each month in calculation.

Please kindly help.

I'd probably do it by making a new monthly page in the workfile, then coping the data over using "last" as the frequency conversion method.

If you want it in the same page, something like: will get you the last observation of the month.

Dear Gareth

Thank you for your quick respond.

I am thinking if I can get the monthly return simply by counting the total of the daily return in "drl", I therefore created a group "mrl" which included "month" and 'drl"

Would you please advise for calculating the standard deviation? If I want to do it by the formula:

Standard Deviation of daily return of the month X Square roof of No. of trade day of the month

Would you please advise how should I write the formula in EViews?

Thank you very much!
Ricky

Hello, Gareth, thank you for your help