logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
osolo  
#1 Posted : Friday, July 3, 2015 4:52:26 PM(UTC)
osolo

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 7/1/2015(UTC)
Posts: 12

Thanks: 1 times

Hi All

I would to know is some can help me to create a formula, to find securities that the last trading day is above moving average crossover, which happened at the previous day.

 

Thank you 

mstt  
#2 Posted : Sunday, July 5, 2015 4:42:56 AM(UTC)
mstt

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 osolo

Here's a quick formula that appears to meet your needs. You will probably need to change the parameters in the Mov() function. This code can be used as an indicator giving all signals on a chart, or as an exploration column giving only a result for the last data bar.

The M variable defines the Moving Average, and the second line has two statements that must both be TRUE for a signal to be given. These conditions are...
C must be greater than M on the current bar,
and C must have crossed above M on the previous bar.

M:=Mov(C,10,E);
C>M AND Ref(Cross(C,M),-1);

Roy (mstt)

Edited by user Sunday, July 5, 2015 4:44:21 AM(UTC)  | Reason: Not specified

osolo  
#3 Posted : Monday, July 6, 2015 11:01:25 AM(UTC)
osolo

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 7/1/2015(UTC)
Posts: 12

Thanks: 1 times
Thank you for putting the formula,
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.