Rank: Newbie
Groups: Registered, Registered Users
Joined: 1/28/2006(UTC)
Posts: 2
|
Hello to All,
I wanted to create an explorer to filter stocks which had a 5 day EMA crossover with the close price in the last 10 days. (I tried to use the ref function but could filter stocks for a single period. ) i.e all the stocks with a crossover in the last 10 trading period.
Would appreciate any tips.
Thanks
Arul
|
|
|
|
|
|
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)
|
Arul,
Have a look in the MS Users Manual for the Alert() function. I think this is the answer to your problem.
wabbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey arul..... the 5 sma might cross several times over the course of 10 days.... by clicking on each returned security you will see the data sheet showing the past 10 days action for each......h
Col A: {up cross}
a:=Cross(C,Mov(C,5,S));
Alert(a,10);
Col B: {down cross}
b:=Cross(Mov(C,5,S),C);
Alert(b,10);
Filter colA OR colB
Filter enabled Yes
Periodicity Daily
Records required 1000
|
|
|
|
|
|
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)
|
h,
To extend the idea further, this is where that useful piece of code to replace the code comes into play:
x:=C>Mov(C,5,S);
x AND Alert(x=0,10);
which says, on the latest bar the close must be above the MA but at some time in the last 10 bars the close can be below the MA. It doesnt matter how many times the close and the MA cross in the last ten bars, just that on at least one bar the close is going to be below the MA and on the last bar the close is going to be above the MA.
This is why I ALWAYS use this code in lieu of the Cross() function.
wabbit :D
|
|
|
|
|
|
| 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.
