|
PureBytes Links
Trading Reference Links
|
<FONT face=Arial color=#0000ff
size=2>Harry,
<FONT face=Arial color=#0000ff
size=2>
I do
not profess to be a whiz at programming but I needed to do something similar to
your request some little while ago and I came up with the undermentioned method
in the Explorer. You may wish to tidy the code up somewhat to meet your
requirements in each column.
<FONT face=Arial color=#0000ff
size=2>
Column
A: Lowest Low in last 30 periods - <SPAN
class=831160800-10052003>LLVBars(LOW,
30)
Column
B: Highest High in last 30 periods - HHVBars(HIGH,30)
Column
C: $ Range in Period - PREC((((HHV(HIGH, 30) - LLV(LOW, 30))/ LLV(LOW,
30))) * 100,1)
Column
D: Current Close as % Range from LLV - PREC(((CLOSE - LLV(LOW,30)) /
(HHV(HIGH,30) - LLV(LOW,30))) * 100,1)
<FONT face=Arial color=#0000ff
size=2>Filter: LLVBars(LOW, 30) < HHVBars(HIGH,30)
{Only finds tickers where LLV has occurred after the HHV in the last 30
days}
<FONT face="Kunstler Script" color=#008000
size=5>Regards,
<FONT face="Kunstler Script" color=#008000
size=5>
Gordon
Sutherland
<FONT
face=Tahoma size=2>-----Original Message-----From: bex1210
[mailto:hmw3@xxxxxxxxxxxxxx] Sent: Saturday, 10 May 2003 7:52
a.m.To: equismetastock@xxxxxxxxxxxxxxxSubject: Re:
[EquisMetaStock Group] Problem with LowestSince
functionDonald:I tried your suggestion.
Unfortunately, it has many of the same problems that my original suggestion,
and Roy's have: in a market where the stock price is rising and falling (i.e.,
not trending), the correct LLV does not get picked up after a new HHV (per the
period) has been established.To summarize, this is what I am trying to
do:1. find the highest high value over a period2. then find the lowest
low value AFTER the highest high from #13. calculate the price change from
the lowest low (#2) to today'sclose (then use Explorer to rank the stocks
by their price change)I can calculate #1 using HHV(). It charts just
fine.I think I can calculate #3 using div().But it is #2 that causes
the problem.I modified a suggestion that Roy made, and have come up
with
this:H1:=HHV(H,30);L1:=LowestSince(1,H1=H,L);L2:=LLV(LowestSince(1,H1<>Ref(H1,-1),L),30);S3:=Max(L1,L2);H1;S3;
{i.e., not charting L1 or L2}This is "almost" correct. I tried it on a
few stocks, and some weekly charts also. There were some mistakes, but none
looked too serious.If you plot your suggestion, plus the above, for
several stocks, you will see where the problems occur. Thanks for your
help. I am new to Metastock, and always open to
suggestions!Harry--- In equismetastock@xxxxxxxxxxxxxxx,
"keara33903" <keara33903@xxxx> wrote:> Hi:Try>
LowestSince(1,cross(H,Ref(HHV(HIGH,40),-1)),LOW) Don't know what your >
doing but <> gives a constant 1 and generally doesn't give what you
> want. Cross(above, below) gives a spike which is needed to start
> lowestsince(jk,KJK,JK) Donald > > --- In
equismetastock@xxxxxxxxxxxxxxx, "bex1210" <hmw3@xxxx> wrote:>
> Roy:> > > > Thanks for the explaination of when
true/false is required. I must > admit I have lots of trouble
understanding the nuances of the > Metastock manual.> >
> > Unfortunately, your > >
"LowestSince(1,H>Ref(HHV(HIGH,40),-1),LOW)" > > doesn't work any
better than my> > "H1:=HHV(HIGH,40);> >
LowestSince(1,H1=HIGH,LOW)".> > > > Both get in trouble
when the high rises and falls, yet does not > exceed a previous high
over the 40 period. Trying charting any stock > that rises and falls
(i.e., is not trending). Then plot an Indicator > of "HHV(HIGH,40)".
Then plot a 2nd indicator of either of the two > LowestSince() formulas
above. You will see that there are spots where > the HHV indicator
drops over time to pick up a newer (and lower) HHV, > but the
LowestSince() doesn't recognize the newer HHV, and therefore > doesn't
change the Low as it should. (It make take looking at several > stocks
before you find one with the correct relations of relative >
highs.)> > > > I thought I had a solution by calculating
the period back to when > the HHV occurred, and then substituting that
period into llv(); such > as> >
"H1:=HHVBars(HIGH,40);> > llv(low,H1)"> > but Metastock
will not allow a variable for the period in llv() > [although it does
allow variables for periods in formulas such as rsi> ().]> >
> > So I am stuck. With your vast experience in using these
Metastock > formulas, perhaps you have another suggestion.> >
> > And yes, when I can get something to chart correctly, my plan is
to > use it in the Explorer, and hopefully also in the System
Tester.> > > > Harry> > > > >
> > > --- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen"
<rlarsen@xxxx> > wrote:> > > Harry> > >
> > > I misunderstood/misread your question. I wrongly assumed it
was > concerning> > > an exploration.> > >
> > > Looking at your example below, you are using a price
"HHV> (HIGH,40)" as if it> > > were a binary value (true
or false). Any price above $1 will be > treated as a> > >
binary true. You need to set up a true/false condition inside the> >
> LowestSince() possibly "LowestSince(1,H>Ref(HHV(HIGH,40),->
1),LOW)". I'm> > > assuming the prices you are working with are
nearly always > greater than $1.> > > > > >
Sorry for the earlier misinformation. Hope this puts you on the > right
track> > > > > > Roy> > > > >
> ----- Original Message ----- > > > From: "bex1210"
<hmw3@xxxx>> > > To:
<equismetastock@xxxxxxxxxxxxxxx>> > > Sent: Saturday, May
03, 2003 5:10 PM> > > Subject: Re: [EquisMetaStock Group] Problem
with LowestSince > function> > > > > >
> > > > Roy:> > > >> > > >
Thanks for the rapid response.> > > >> > > > I
think I understand the "periods" suggestion, and will set > that up as
a> > > separate Indicator to call by Explorations.> >
> >> > > > But I don't understand your response on
LowestSince(), or my > question was> > > not phrased well,
or both!> > > >> > > > I was first trying to
use LowestSince () in a chart. It was my> > > understanding, from
one of your earlier posts, that Indicators in > charts> >
> scan ALL loaded data; so minimum should not be an issue as it is >
in the> > > Explorer.> > > >> > >
> When I try to chart an Indicator using "LowestSince(1,HHV>
(HIGH,40),LOW)",> > > I get a plot line identical to the Low of
each day (i.e., I get > today's low> > > today,
yesterday's low for yesterday, etc.)> > > >> > >
> I then thought that perhaps there had to be some form of cross >
for> > > LowestSince() to function, so I created an Indicator
which used:> > > > H1:=HHV(HIGH,40);> > > >
LowestSince(1,H1=HIGH,LOW)> > > >> > > > This
at least plots a curve, and works correctly part of the > time,
but> > > when the stock price (High) rises and subsequently falls
over a > period of> > > time, AND the resulting High is
below my calculated H1, then > LowestSince()> > >
calculates the wrong Low. I also tried H1<HIGH, and even H1>HIGH,
> and> > > combinations. None work.> > >
>> > > > So there is something which I must not understand
about how > LowestSince()> > > actually functions.>
> > >> > > > Any wisdom would be greatly
appreciated.> > > >> > > > Harry> >
> >> > > > --- In equismetastock@xxxxxxxxxxxxxxx, "Roy
Larsen" > <rlarsen@xxxx> wrote:> > > > >
Harry> > > > >> > > > > When using
LowestSince() in the Explorer you must force it to > scan at>
> > least> > > > > the required number of bars, and
preferably more. ValueWhen() > and> > > > >
BarsSince() are other function that will not return expected > values
when> > > > > used with "minimum" bars.> > >
> >> > > > > And don't forget the many functions
using any form of > exponential> > > smoothing>
> > > > require at least 5 times more data than the longest
"periods" > used by> > > the> > > > >
offending functions.> > > > >> > > > >
To access a "Periods" value for ALL exploration columns I > suggest
you> > > create> > > > > an indicator
specifically for this purpose. You can set up > any number of>
> > > > variable values then use FmlVar() in your exploration
columns > to call> > > the> > > > >
required value. This could be used for dates as well as > numbers. Just
be> > > > > aware that there is a performances trade-off
when the number > of formula> > > > > calls begins
to climb.> > > > >> > > > > Roy>
> > > >> > > > >> > > > >
----- Original Message ----- > > > > > From: "bex1210"
<hmw3@xxxx>> > > > > To:
<equismetastock@xxxxxxxxxxxxxxx>> > > > > Sent:
Saturday, May 03, 2003 5:59 AM> > > > > Subject:
[EquisMetaStock Group] Problem with LowestSince > function> >
> > >> > > > >> > > > > > I
have Metastock 8.01, EOD version. I am trying to > calculate
the> > > lowest> > > > > low since the highest
high for use in an Explorer. But I am > having real> > >
> > problems.> > > > > >> > > >
> > To visualize what is happening, I have created indicators >
to plot on> > > > > charts. If I create an indicator for
the HighestHigh [hhv()] > for a> > > specific> >
> > > period, it plots correctly. So does Lowest Low [llv()].>
> > > > >> > > > > > But when I try to
plot the lowest low since the highest > high for a> > >
period> > > > > using
[LowestSince(1,HHV(HIGH,40),LOW)], all I get is > today's low. If
I> > > > > change the Nth figure to 2, I get yesterday's
low. Neither > are the real> > > low> > >
> > since the last high; not anywhere close.> > > > >
>> > > > > > Clearly I am doing something wrong. Can
someone provide a > little> > > guidance?> >
> > > >> > > > > > Thanks in
advance,> > > > > >> > > > > >
Harry> > > > > >> > > > >
>> > > > > >> > > > > >>
> > > > >> > > > > > To unsubscribe from
this group, send an email to:> > > > > >
equismetastock-unsubscribe@xxxxxxxxxxxxxxx> > > > >
>> > > > > >> > > > > >>
> > > > > Your use of Yahoo! Groups is subject to> >
> <A
href="">http://docs.yahoo.com/info/terms/>
> > > > >> > > > > >> > >
> > >> > > > > >> > > >>
> > >> > > >> > > > To unsubscribe
from this group, send an email to:> > > >
equismetastock-unsubscribe@xxxxxxxxxxxxxxx> > > >> >
> >> > > >> > > > Your use of Yahoo!
Groups is subject to > <A
href="">http://docs.yahoo.com/info/terms/>
> > >> > > >> > > >> > >
>To
unsubscribe from this group, send an email
to:equismetastock-unsubscribe@xxxxxxxxxxxxxxxYour
use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|