Hi Kai, sorry for ignoring your second question, I missed it.

I hope I got it right (I have done some quick hand computation)...

In a more general case, where one has H consecutive equispaced time

occasions

y(1)...y(m)...y(H), the slope should be:

[ sum for m = 1 to H of (m - (H+1)/2) * y(m) ] / D

where: D = H * (H ^ 2 - 1) / 12

or, if you prefer: D = H * (H + 1) * (H - 1) / 12

-tommaso

PS

let me know if it works fine

Kux ha scritto:

Hello Tom,

thanks a lot for that formula. It works great with the data i checked.

but how do you get to 143?

I need to do similar calculations with other time frames as well (24,

36 and 48 months). I could always try it out but I would rahter enter a

formula in case someone changes the lenght of the period later...

THanks

Kai