Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/18/2006(UTC)
Posts: 10
|
I am trying to write a formula that will returns stocks that the closing price is within 25 pecent or 1 dollar of the 50 day SMA. Here is what I have tried. Close=Ref(OscP(1,50,S,%),20) Since this doesn't work I am in need of help. Will you please line me out? Thanks
|
|
|
|
|
|
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)
|
$1 of a 50 SMA used on a 10 dollar stock is vastly different than that of a stock valued at $50, The same can be said using %
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/18/2006(UTC)
Posts: 10
|
My intention is to find prices in a retracement and near their 50 day MA
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
maybe you can adapt something like this to what you are trying to do:
{ ColA }
CLOSE
{ ColB }
Mov(C,50,S)
{ FILTER }
upper:=colB*1.25;
lower:=colB*0.75;
colA<upper AND colA>lower AND
abs(colA-colB)<1
|
|
|
|
|
|
| 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.
