HPFILTER(Sequence,λ)
Sequence: the data sequence to be transformed
λ: filter parameter λ, defaults to 1600
This array function returns the trend and cyclical components obtained by applying the Hodrick Prescott Filter with parameter λ to the given data sequence.
The output consists of two columns of numbers, the first containing the trend component, the second the cyclical component.
If Sequence is neither an n by 1 nor 1 by n array, this function returns #VALUE! If Sequence contians less than 6 numerical values, this function returns #VALUE!