How to link a series and a formula through frml
Posted: Mon Oct 28, 2019 11:06 am
Hi, I want to build a series linking two series, one back in time (which is fixed) and the second one, which is take from an external database and is continuously updated (and the same operation for 69 more series).
if I run the following code, I end up only with the second part of the series
***************************************
copy(link) external_DB::xxxxx pr_2015_1 ' Copy the series from external DB
smpl 2015m1 2015m12
scalar m1 = @mean(pr_2015_1) ' This to compute the scaling factor (the scalar should not change over time)
smpl 2011m1 2015m12
series pr_tot_1 = (1/m1)*pr_2010_1 ' pr_2010_1 is the old series
smpl 2016m2 @now
frml pr_tot_1 = pr_2015_1
*******************************************
any suggestions?
thx
if I run the following code, I end up only with the second part of the series
***************************************
copy(link) external_DB::xxxxx pr_2015_1 ' Copy the series from external DB
smpl 2015m1 2015m12
scalar m1 = @mean(pr_2015_1) ' This to compute the scaling factor (the scalar should not change over time)
smpl 2011m1 2015m12
series pr_tot_1 = (1/m1)*pr_2010_1 ' pr_2010_1 is the old series
smpl 2016m2 @now
frml pr_tot_1 = pr_2015_1
*******************************************
any suggestions?
thx