Page 1 of 1

Creating Indexes by changes

Posted: Wed Jun 03, 2009 11:39 am
by fmramos
Hi all!

I'd like to know if someone has any idea about this issue:

Without programming (eg. only one command line or using auto update function), convert monthly % changes into indexes numbers referenced in any (or, at least, the first) period of time. For instance:

t1=10%
t2=5%
t3=15%

So

t0=100
t1=110
t2=115 (suppose log)
t3=130...

Usually I update series in Excel and put then in EV or EV DB. I'd like to avoid more and more to use XLS files to this kind of thing (I don't think its reliable). Tks in advance. Fabio

Re: Creating Indexes by changes

Posted: Wed Jun 03, 2009 11:49 am
by EViews Gareth
Assuming you have the monthly changes, as decimals (i.e. 0.1, 0.05, 0.15) in a series called "t", and you want to save them into a series called "x", then something like this would work:

Code: Select all

series x=@recode(@trend=0,100,x(-1)*(1+t))

Re: Creating Indexes by changes

Posted: Wed Jun 03, 2009 1:57 pm
by fmramos
Tks Gareth!

I need to keep in mind this good combination (@trend and @recode).

Fabio.