Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 8/2/2010(UTC)
Posts: 1
|
This may seem like a simple, or even a "duh", question, but is there a formula to scan for a price or price range?
Like only returning stocks that are $10 or less or stocks that are $5-$10?
I know nothing about formulas, coding, excel, etc.
Thanks in advance,
Jason
|
|
|
|
|
|
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)
|
Please read the manual that came with your software.It will save you a ton of money in the long run.
now for your request
for stocks that are less than $10 : If(Close<10,1,0) this will return a +1 when the condition is true and 0 when it is not
for stocks that are in a range: If(Close>5 and Close<10,1,0) this will return a +1 when the condition is true and 0 when it is not
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/10/2010(UTC)
Posts: 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.
