Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/30/2010(UTC)
Posts: 5
|
Hi Team,
Please let me know the formula to filter stock prices closed above the cross over 20 ema and 50 ema. As I am having formula for cross over 20 ema and 50 ema it gives result only when the crossover happens on date of exploration, but I want to know all the stocks after the cross over happened.
Thanks in advance.
Regards,
Balasubramanian MS Edited by user Sunday, August 2, 2015 4:56:07 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi B
Try this, and set the Explorer to load at least 250 bars. Loading 250 or more bars will ensure that the 50 period EMA is accurate.
{ColA}
C>Mov(C,20,E ) AND C>Mov(C,50,E );
{Filter}
ColA;
Roy
Edited by user Sunday, August 2, 2015 8:56:15 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/30/2010(UTC)
Posts: 5
|
Hi Roy,
Thanks for your immediate response, but I want formula to find the stock already cross-over happened i.e. closed above cross over 20 EMA and 50 EMA
regards.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi B
That's exactly what my exploration is supposed to do. It reports a TRUE as soon as the CLOSE is above both EMAs. And it will keep reporting that TRUE until the CLOSE drops below one of the EMAs. It would be easy to delay the TRUE until a bar later than the second crossover but as far as I can see the code as it stands should do exactly what you asked for.
Did you run the exploration?
Roy
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/30/2010(UTC)
Posts: 5
|
Hi Roy,
Thanks Mr.Roy, when I run exploration it gives results stocks closed above 20 ema and 50 ema,but I want to know the list of stocks after crossover happened.
Regards.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi B
Try printing out the report, or coping it to Excel and manipulating the data as required before printing.
Roy
|
|
|
|
|
|
| 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.
