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

Notification

Icon
Error

Options
Go to last post Go to first unread
faissaluae  
#1 Posted : Wednesday, March 8, 2006 11:58:35 AM(UTC)
faissaluae

Rank: Newbie

Groups: Registered, Registered Users
Joined: 2/26/2006(UTC)
Posts: 6

i want to make formula to find witch securities closed above there 20 days moving average in The Explorer can any body help me in that explain every things plz
StorkBite  
#2 Posted : Wednesday, March 8, 2006 2:43:20 PM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Try this: C> mov(C, 20, S) Also, there are many good examples in the formula primer. You can d/l it here on the forum for free. :D
henry1224  
#3 Posted : Wednesday, March 8, 2006 10:16:32 PM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
C> Mov(C,20,S) will show only stocks that are greater than the MA Cross(C,Mov(C,20,S)) will show only the stocks that have crossed today If(Cross(C,Mov(C,20,S)),2,If(Cross(Mov(C,20,S),C)),-2,If(C>Mov(C,20,S),1,If(C<Mov(C,20,S),-1,0)))); will show +2 for todays crossing above the ma,+1 for c> Ma,-2 for todays cross below the Ma, and -1 if the stock is below the ma
StorkBite  
#4 Posted : Wednesday, March 8, 2006 10:20:08 PM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Nice addendum... teamwork is wonderful. Thanks, Henry.
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.