Creating Indexes by changes

[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

[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))

[fmramos]

Tks Gareth!

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

Fabio.