Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59
|
Haven't used formulas for a long time - what's a formula to show all stocks with a lower close price than the previous day please? Thanks in advance!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59
|
Thanks John - which column are you putting that formula in? (Or doesn't it matter?)
I have one for finding all stocks which have INCREASED by at least 1.4%, but for some reason it doesn't work in reverse:
Col C: ROC (CLOSE,1,percent)
Filter: colC >= 1.4
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59
|
Ah fixed it, made Filter: colC < -.1
:)
edit: that says colC < -.1 above, why doesn't it show?
|
|
|
|
|
|
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)
|
your version
Col C: ROC (CLOSE,1,percent)
Filter: colC >= 1.4
try this for stocks that have increased by at least 1.4%
Col C: C-Ref(C,-1)>=(C-(Ref(C,-1))*.014
Col C
try this for stocks that have decreased by more than 1.4%
Col D: Ref(C,-1)-C>=((Ref(C,-1)-C)*.014
Col 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.
