Rank: Newbie
Groups: Registered, Registered Users
Joined: 7/20/2007(UTC)
Posts: 5
|
Hi everybody,
I'm looking for someone who can help me with this problem: how to plot values of a centered moving average into the "null zone" using the projection of the last aviable close of a security. For example: consider this sequence of closes - 2 -3 - 4 - 5 - 3 - 4 - 2 (this is the very last close). A 5-data CMA can't calculate and obviously plot its values for the next to last close (4) and the last close (2). To overcome the problem I'd like to project the last close into the future: so for the next to last close (4) the CMA should be (5+3+4+2+2)/5 and for the last close (2): (3+4+2+2+2)/5.
Of course, this "indicator" should work also in the explorer.
Thanks in advance
Marco
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 4/18/2007(UTC)
Posts: 99
Location: sydney australia
|
my understanding is that you can't project a formula into the day ahead. so why not just a simple formula & imagine that the last item (or the direction it is taking) is actually a projection?
just to start the ball rolling, you could try (Ref(C,-3)+Ref(C,-2)+Ref(C,-1)+(2*C))/5 for one of them & similar for the other one.
creating an exploration should be easy. one could be looking for where the formula on the last day comes up higher than on the day before, etc.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 4/18/2007(UTC)
Posts: 99
Location: sydney australia
|
don't think you'll find it of much usefulness. I've tried it on various stocks & it's almost identical to the 3-day MA. maybe too easy, that's why.
|
|
|
|
|
|
| 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.
