Linear Trendline based off existing series

[bpuffer]

Hi,

I am trying to create a series that contains the trendline values associated with another series. For example:

I have a quarterly series "z"; sample 1980 through 2015Q1. I would like to create series "z_trend" that contains the data that when graphed would display a linear trendline for series "z".

I want to program this so that each time I update "z" with new data and rerun the program it re-calculates the "z_trend".

How do I go about programming the calculation of the trendline?

Thanks in advance!

[EViews Gareth]

Code: Select all

equation eqztrend.ls z c @trend eqztrend.fit z_trend