Ungrouping Group Series data after conversion to log diff

[naz_08]

Hi,

I am a new user of Eviews. I grouped several spreadsheets (raw data) on eviews, and took the log difference. Now I want to display and save the individual log difference series in the group onto my workfile as individual returns data, as separate files. Please advise how I can accomplish this.

Attached pic shows the working file for hong kong sectoral indices in a group file named hk_ret which is the log difference of raw data. I need help to create individual files for every column in the group file which I changed from raw data to log diff. Please help as I dont want to do it manually every time. I am analyzing 10 countries with multiple sectoral indices so it will be very time-consuming.

I am using EViews 5
Thanks in advance!

-Naz

[EViews Gareth]

Code: Select all

for !i=1 to HK_RET.@count %sername = hk_reg.@seriesname(!i) %newname = "ld_" + %sername series {%newname} = @dlog({%sername}) next

[naz_08]

Code: Select all

for !i=1 to HK_RET.@count %sername = hk_reg.@seriesname(!i) %newname = "ld_" + %sername series {%newname} = @dlog({%sername}) next

Hi Gareth,

Thanks for your reply. I am still having trouble incorporating it into eviews. Please view the screen shot and advise. Thank you so much.

[EViews Gareth]

You need to write an EViews program (File->New Program).

[naz_08]

You need to write an EViews program (File->New Program).

Hi Gareth,

Sorry I am very slow in this.
I opened new program as you mentioned, then saved it , and then run it but I still get a error message as indicated by photo. Kindly
provide me with a solution and possible step by step action I can do. Thanks so much, you are a great help. Have a great day.

[EViews Gareth]

You need to have your workfile open.

[naz_08]

You need to have your workfile open.

Hi,

I have tried that but it doesnt work. I closed the group (hk wf) and its still the same error message?

[naz_08]

You need to have your workfile open.

Hi Gareth,

Ok i figured it out. It should be written HK_RET....

thanks a lot :) have a good one.

[naz_08]

You need to have your workfile open.

Hi,

I have tried that but it doesnt work. I closed the group (hk wf) and its still the same error message?

Hi Gareth,

Is there any program I could take the group file and find the individual c-garch for each series automatically? Thanks