EViews.com

Hi, I am trying to create a series say "VC", where the first observation of this series "VC" is 100 and from the second observation onwards use the formula series VC=(1+HP)*(VC(-1)), where HP is a series of growth rates. Please, if someone could help me would be very appreciate.

Thanks

Hi, I am trying to create a series say "VC", where the first observation of this series "VC" is 100 and from the second observation onwards use the formula series VC=(1+HP)*(VC(-1)), where HP is a series of growth rates. Please, if someone could help me would be very appreciate.

Thanks

Thanks, but it didnt work, actually I had tried something similar with the same result, just NAs. No problem creating the VC=100 series, but then when defining the smpl and running the formula, just get NAs.

What's in the HP series?

What's in the HP series?

just growth rates like
na
0.03
0.05
0.07
0.08
0.001
0.025

so I need to end up with
series VC
100
103---------->100*(1+0.03)
108.15---------->103*(1+0.05)

Perhaps post your EViews workfile.

'fondo A
import "D:\Usuario\eorellana\Desktop\Box Sync\Eduardoraran\AFPs\RENTABILIDADES FONDOS.xlsx" range="HISTORICOS A"!$AS$3:$AU$20000 colhead=1 na="#N/A" @freq D7 9/26/2002 @smpl @all



'UF
import "D:\Usuario\eorellana\Desktop\Box Sync\Eduardoraran\AFPs\UF Actual.xlsx" range="UF Diaria"!$A$1:$C$20000 colhead=1 na="#N/A" @freq D7 9/26/2002 @smpl @all


series vc_areal=100

smpl 2 @last

vc_areal=(1+(((1+rent_diaria_a)/(1+rent_diaria_uf))-1))*(vc_areal(-1))


What I gave you was a simplification but (((1+rent_diaria_a)/(1+rent_diaria_uf))-1)) is just a rate. Also I am importing data from an Excel from an specific range, dont know if that is doing something.

Save your workfile to something like foo.wf1 and post that. That's the only way for anyone else to see what EViews thinks it has.

The formula:

series vc_areal=100

smpl 2 @last

vc_areal=(1+(((1+rent_diaria_a)/(1+rent_diaria_uf))-1))*(vc_areal(-1))

Use: rather than Your workfile is dated, so "2" corresponds to the date "2" rather than the 2nd observation.

Thank you, it worked!!! thank you very much, you are the best.

Thank you again