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

Notification

Icon
Error

Options
Go to last post Go to first unread
mark91345  
#1 Posted : Sunday, June 12, 2011 11:56:02 PM(UTC)
mark91345

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles

Thanks: 4 times
Hi,

I want to find stocks where (at end-of-day) today's low is 10 cents lower than yesterday's low, for stocks priced between $1.15 and $1.85.

I have Metastock 9.1 if that matters.

Thanks,
Mark

jjstein  
#2 Posted : Monday, June 13, 2011 6:27:35 AM(UTC)
jjstein

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA

Was thanked: 1 time(s) in 1 post(s)
Try an Exploration with code in the Filter tab.

Use the REF function. You'll need to decide what "priced" means -- just the close, a range of low to high, etc.

Post your code if you have any problems.

mark91345  
#3 Posted : Monday, June 13, 2011 9:52:00 AM(UTC)
mark91345

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles

Thanks: 4 times
Thanks for the reply, but I am still unclear.

I want to find stocks where (at end-of-day) today's low is 10 cents lower than yesterday's low, for stocks priced between $1.15 and $1.85.

I am only concerned about the low.
wabbit  
#4 Posted : Monday, June 13, 2011 10:06:56 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)
Have a go at doing the exercises in the free Equis formula primer and you will be able to write your own explorations, and more. wabbit [:D]
henry1224  
#5 Posted : Monday, June 13, 2011 10:35:52 AM(UTC)
henry1224

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)
(Ref(L,-1)-.1) > L and C > 1.15 and C "<" 1.85 this will find lower lows that are 10 cents or more below the previous low on the last C it should say close is less than 1.85
mark91345  
#6 Posted : Monday, June 13, 2011 1:27:43 PM(UTC)
mark91345

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles

Thanks: 4 times
Ref(L,-1)-.1) > L AND C > 1.15 AND C
Thanks for your help.

I made a couple changes to the above formula and it seems to be working.

(Ref(L,-1)-.1) > L AND L < 1.15

Now, I am seeing what I want. Thanks again for your help, as I did not know where to begin!

Thanks,
Mark



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.