Seasonal adjustment as a formula for auto updating
Posted: Thu Sep 08, 2016 4:03 pm
Hi Everybody,
I have a number of series that are linked to a data base that I update on a monthly basis. I often need to seasonally adjust the series in order to obtain the '_sa" and "_tc" (if you are using x12) components of the series. It would be nice if I could just specify these series as a formula of the original series, rather then creating and running code each month.
It is easy enough to have a calculation (e.g. summation of several existing series) in order to have the new series auto update, as the contributing series become updated. I am just wondering if anyone has had any luck doing a similar thing but with a seasonal adjustment process? I tried using the normal coding syntax that you would normally use but it doesnt seem to work.
Thanks a bunch!
I have a number of series that are linked to a data base that I update on a monthly basis. I often need to seasonally adjust the series in order to obtain the '_sa" and "_tc" (if you are using x12) components of the series. It would be nice if I could just specify these series as a formula of the original series, rather then creating and running code each month.
It is easy enough to have a calculation (e.g. summation of several existing series) in order to have the new series auto update, as the contributing series become updated. I am just wondering if anyone has had any luck doing a similar thing but with a seasonal adjustment process? I tried using the normal coding syntax that you would normally use but it doesnt seem to work.
Thanks a bunch!