Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 7/10/2019(UTC)
Posts: 4
Location: HISAR
|
Sir, can u help in the formula in which price closed above 50 EMA for the first time in 50 days but result should be only those stock which are first time only
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,934
Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
|
Originally Posted by: SAINI9466637986  Sir, can u help in the formula in which price closed above 50 EMA for the first time in 50 days but result should be only those stock which are first time only
Hello, You could look for the cross condition in addition to using the SUM function to check that the total sum of cross conditions over 50 days is equal to 1. Code:Cross(C,MOV(C,50,E)) AND Sum(Cross(C,MOV(C,50,E)),50)=1
|
|
|
|
|
|
| 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.
