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

Re: [EquisMetaStock Group] Problem with LowestSince function



PureBytes Links

Trading Reference Links

Donald:

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 period
2. then find the lowest low value AFTER the highest high from #1
3. calculate the price change from the lowest low (#2) to today's
close (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
> > > 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 
> http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > > >


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Rent DVDs from home.
Over 14,500 titles. Free Shipping
& No Late Fees. Try Netflix for FREE!
http://us.click.yahoo.com/BVVfoB/hP.FAA/uetFAA/BefplB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/