Page 1 of 1

Ungrouping Group Series data after conversion to log diff

Posted: Tue Dec 04, 2012 2:01 am
by 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

Re: Ungrouping Group Series data after conversion to log dif

Posted: Tue Dec 04, 2012 8:35 am
by 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

Re: Ungrouping Group Series data after conversion to log dif

Posted: Tue Dec 04, 2012 1:47 pm
by 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.

Re: Ungrouping Group Series data after conversion to log dif

Posted: Tue Dec 04, 2012 6:59 pm
by EViews Gareth
You need to write an EViews program (File->New Program).

Re: Ungrouping Group Series data after conversion to log dif

Posted: Wed Dec 05, 2012 1:45 am
by 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.

Re: Ungrouping Group Series data after conversion to log dif

Posted: Wed Dec 05, 2012 8:22 am
by EViews Gareth
You need to have your workfile open.

Re: Ungrouping Group Series data after conversion to log dif

Posted: Wed Dec 05, 2012 11:03 am
by 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?

Re: Ungrouping Group Series data after conversion to log dif

Posted: Wed Dec 05, 2012 11:05 am
by 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.

Re: Ungrouping Group Series data after conversion to log dif

Posted: Thu Dec 06, 2012 11:25 am
by 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