Rank: Newbie
Groups: Registered, Registered Users
Joined: 5/12/2005(UTC)
Posts: 3
|
Does anybody know what the formula would be to incorporate a horizontal shift into the moving average formula.
thanks,
nbbo
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
You need to use the ref function. Check your help file for the syntax ...
For example the following would give me a 5 period adjusted average:
Ref(Mov(C,10,S),-5)
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey nbbo.... not knowing what your after , left or right horizontal shift, the shift to the left would be, Ref(Mov(C,10,S),+5) ...... patrick has talked specifically about pro's and con's of "+5" in one of the formula training lessons.....h
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
