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

Notification

Icon
Error

Options
Go to last post Go to first unread
moggie  
#1 Posted : Thursday, March 26, 2009 5:35:14 PM(UTC)
moggie

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/26/2009(UTC)
Posts: 1

I need help creating the following: I want to do an exploration using a moving average cross over- showing the following: 50 ma of close 5 days ago, current 100 ma, and current 50 ma. The stocks listed in the results should be those whose prior 50 ma was below the 100 ma and whose current 50 ma is now above the 100 ma. Any help or ideas would be greatly appreciated.
erko  
#2 Posted : Thursday, March 26, 2009 6:42:23 PM(UTC)
erko

Rank: Newbie

Groups: Registered, Registered Users
Joined: 4/27/2006(UTC)
Posts: 6

Hi moggie,

I'm pretty new to this, but i think this is what you're after;

colA:
Ref(mov(c,50,s),-5)

ColB:
mov(c,100,s)

ColC:
mov(c,50,s)

Filter
cross(colC,ColB)

erko
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.