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

Notification

Icon
Error

Options
Go to last post Go to first unread
VSAP  
#1 Posted : Wednesday, April 7, 2010 6:05:36 AM(UTC)
VSAP

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 7/8/2009(UTC)
Posts: 7

Hi Guys Could someone point in in the direction of any (similar) example code which allows me to search for equities where the previous days close was above the 50 day moving average, but the current days close is now above the 50 day moving average. Thanks and regards, Baz
wabbit  
#2 Posted : Wednesday, April 7, 2010 7:17:03 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
The best direction in which to be pointed is the MS Users Manual and the free Equis Formula Primer, both of which can be utilised to teach yourself how to write these sorts of simple queries.


wabbit [:D]

mstt  
#3 Posted : Wednesday, April 7, 2010 4:45:39 PM(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 Baz

Your question appears to be worded wrongly as it is somewhat ambiguous and seems to be asking for code to find securities where the last two days closing prices were above the 50 day MA. However I suspect that what you really want is to know when the price has crossed above (or below) the 50 day MA. Perhaps you can clarify your request? Knowing the type of MA would probably be helpful too.

Roy

VSAP  
#4 Posted : Thursday, April 8, 2010 6:25:47 AM(UTC)
VSAP

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 7/8/2009(UTC)
Posts: 7

Hi Rob, The 50 MA was just an example I plucked from the air. In essence this is what I an trying to achive: * Check for stocks price on the previous day was below a given MA (price crossed downwards), and the current price of the stock has now moved above (price crossed above) the MA. Thanks and regards, Baz
mstt  
#5 Posted : Thursday, April 8, 2010 2:05:21 PM(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 Baz

Cross(C, Mov(C,50,E));

Take some time to work through the MetaStock Formula Language section of the User Manual - it's worth the effort.

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.