Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/7/2013(UTC)
Posts: 17
Thanks: 5 times
|
hi all,
good day.
can anyone help to check if the following formula for MS explorer is right/other suggestions?
MOV(c,50,E) > MOV(C,200,E)
Ref ((mov(c,50,e) > mov(c,20,E),-2)
Ref ((mov(c,20,e) > mov (c,50,e), -1)
essentially i m looking for
(1) EMA 50 >EMA 200
(2) EMA 50 >EMA 20 2 days ago
(3) EMA 20 > EMA 50 1 day ago
thanks. J
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
What you wrote was:
EMA 50 > EMA 200
EMA 50 (2 days ago) > EMA 20 (2 days ago)
EMA 20 (1 day ago) > EMA 50 (1 day ago)
If you are wanting to compare a current EMA value to a value X bars ago then you only want to wrap the REF function around the 2nd moving average, such as:
MOV(C,50,E) > REF(MOV(C,20,E),-2)
Hard for me to say for sure which of the two is what you're intending.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/7/2013(UTC)
Posts: 17
Thanks: 5 times
|
hi there,
thanks for the quick reply and comment!
that's what I wanted but i'll also play around with the formula you suggested.
thanks again and have a good day :)
cheers. J
|
|
|
|
|
|
| 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.
