[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Filtering for cyclical stocks



PureBytes Links

Trading Reference Links

Jim,

My assumption for this type of test would be

(HHV(C,250)-C)/HHV(C,250)<=0.01
or
(L-LLV(C,250))/LLV(C,250)<=0.01

The ABS() would work as you suggest.  These formulas above are true/false
tests, so they should be returning either zero or one.

If you are still getting errors, I'd be happy to look at your coding itself
to see what might be causing this.

Dave Nadeau
Fort Collins, CO

-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Jim
Sent: Tuesday, February 13, 2001 2:29 PM
To: metastock@xxxxxxxxxxxxx
Subject: RE: Filtering for cyclical stocks


I plugged your spread% in a column and get an error message.... "passing
zero or negative value"..I realize i can use abs just to get an absolute
value or have a test for zero.... but ..are you getting this as well...i am
using 6.52....thanks...jim



At 10:31 PM 1/27/01 -0700, you wrote:

Bill,

I still owe you a response I promised on your earlier email.  My apologies.
My monitor went out on Saturday, and I'm just getting caught up with all of
my email.

How about creating a custom indicator that returns +1 when the price (close)
is within 1% (or some other value) of the HHV(C,250) and a -1 when the same
is true at the LLV(C,250)?  Then you can use
BarsSince(yourIndicator=1)>=BarsSince(yourIndicator=-1)as the UP condition
and the reverse as the DOWN condition.  Your second indicator is just =1
during the UP period, then =-1 during the down period.  Count the number of
Cross() 'es and sort or filter in your exploration.  (I'd also divide that
by Cum(1) which is the total number of bars loaded to give you a rate
comparison).

Dave Nadeau
Fort Collins, CO

-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Bill Irwin
Sent: Saturday, January 27, 2001 6:22 PM
To: Mail List - MetaStock Submit (E-mail)
Subject: Filtering for cyclical stocks


One of the criterial I'm using in my Explorations is to find stocks that
have a 1 year high/low spread of greater than 100% and less than 300%.  This
finds stocks that are moving up or down, but also picks ones that move
steadily up or down, rather than cycling.

Col E: Spread % ((HHV(C,250)-LLV(C,250))/LLV(C,250))*100

Does anyone have a formula for selecting stocks that move between the
defined high/low points at least X number of times?  This would select the
ones on a rollercoaster.  Whether they're predicatable or not is another
question.

Bill
Bill-Irwin@xxxxxxxx
http://members.home.net/bill-irwin


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com