|
PureBytes Links
Trading Reference Links
|
Hi
Harold,
<FONT face="Courier New"
color=#0000ff>
<FONT
face="Courier New" size=3>The formula in ColA <FONT
face="Courier New" color=#000000 size=3>
<FONT
face="Courier New" color=#000000 size=3>
<FONT
face="Courier New" color=#000000 size=3>If(Sum(Fml("FVE
DIV"),10) = 20,20,If(Sum(Fml("FVE DIV"),10) = -20,-20,0)) {change
fml name if appropriate}
<FONT
face=Arial color=#0000ff size=2><FONT face="Courier New" color=#000000
size=3>tells MS Explorer to include in the Report only
those tickers that have had either 2 or -2 for each of the last 10
consecutive periods. The formula tells the Explorer to Report in ColA either
20 or -20 if these conditions have been met - you could just as easily put 2 or
-2 in the Report. When you go to "Inspect" in the Report screen, the dates
stated are those dates that meet the criteria. Thus if on September 19, 2003
there had been 10 consecutive periods where the rule was met and counting back
from the 19th then "20" or "2" or whatever you put in the formula will show up
for just that period. If on the September 18th, 2003 the condition had been met
for 9 periods then that day would not appear in the Inspect Report because it
did not meet the 10 period rule.
<FONT face="Courier New"
color=#0000ff>
You
may be more comfortable therefore using the undermentioned
formula:
<FONT face="Courier New"
color=#0000ff>
<FONT face="Courier New"
color=#ff0000>If(Sum(Fml("FVE DIV"),10) = 20, <FONT
color=#008000>2,If(Sum(Fml("FVE DIV"),10) = -20, <FONT
color=#008000>-2,0)) {change fml name if
appropriate}
<FONT face="Courier New"
color=#ff0000>
<FONT face="Courier New"
color=#0000ff>Either formula will give you the correct answer. Hope this
helps.
<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: hcour
[mailto:no_reply@xxxxxxxxxxxxxxx] Sent: Sunday, 21 September 2003
12:23 p.m.To: equismetastock@xxxxxxxxxxxxxxxSubject:
[EquisMetaStock Group] Re: FVE Divergence
Scan?Gordon,He shoots, he scores! Great,
thanks.But I'm a bit confused. When I go into the "Results" of the
exploration and click on "Inspect", some of the charts only read 20 or
-20 for 1 or 2 days, but when I actually open the chart the indicator does
indeed read 20 or -20 for at least 10 days. I don't get it.Thanks
much,Harold--- In equismetastock@xxxxxxxxxxxxxxx, Gordon
Sutherland <gosuth@xxxx> wrote:> Harold,>
> Slot the following into ColA:> > If(Sum(Fml("FVE
DIV"),10) = 20,20,If(Sum(Fml("FVE DIV"),10) => -20,-20,0))
{change fml name if appropriate}> > and Slot the following
into the Filter:> > colA <> 0> >
Good hunting -------------->> > Regards,>
> Gordon Sutherland> > -----Original Message----->
From: hcour [mailto:no_reply@xxxxxxxxxxxxxxx] > Sent: Sunday, 21
September 2003 9:19 a.m.> To: equismetastock@xxxxxxxxxxxxxxx>
Subject: [EquisMetaStock Group] Re: FVE Divergence Scan?> >
> Thanks Preston, but that didn't work either. I'm still getting the
> same results - stocks at 2 or -2 w/in the time period, but not
> neccessarily *throughout* the time period.> > Wow. Have
I stumped the board?!> > Thanks,> Harold> >
> > > > --- In equismetastock@xxxxxxxxxxxxxxx,
pumrysh <no_reply@xxxx> wrote:> > H,> > >
> Off the top of my head.> > > >
(Ref(colA,-9)+Ref(colA,-8)+Ref(colA,-7)+Ref(colA,-6)+Ref(colA,-5)+>
> Ref(colA,-4)+Ref(colA,-3)+Ref(colA,-2)+Ref(colA,-1)+(colA) = 20)
or> >
(Ref(colA,-9)+Ref(colA,-8)+Ref(colA,-7)+Ref(colA,-6)+Ref(colA,-5)+>
> Ref(colA,-4)+Ref(colA,-3)+Ref(colA,-2)+Ref(colA,-1)+(colA) =
-20) > > > > > > P> >
> > > > --- In equismetastock@xxxxxxxxxxxxxxx, hcour
<no_reply@xxxx> wrote:> > > OK, this is what I have so
far:> > > > > > colA: Fml("FVE DIV")> >
> > > > colB: (colA = 2) OR (colA = -2) AND ????> >
> > > > The ALERT function doesn't work as "ALERT (10)"
because it > returns > > > stocks that have been at 2 or
-2 *anytime* w/in the last 10 days, > > not > > >
*all* 10 days.> > > > > > I think I have to do
something like:> > > > > > Ref(C,-1) AND Ref(C,-2)
ect...> > > > > > But when I try it that doesn't
work either because I'm sure of > the > > > syntax. Can
someone please help me figure out the last part of > this > >
> formula?> > > > > > Thanks,> > >
Harold> > > > Yahoo! Groups
Sponsor > >
ADVERTISEMENT> > <<A
href="">http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705>
375617:HM/A=1732163/R=0/SIG=11n0nglqg/*<A
href="">http://www.ediets.com/start.cfm?c>
ode=30510&media=zone> click here
> > <<A
href="">http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou>
pmail/S=:HM/A=1732163/rand=790543014>
> > 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>
<<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
ADVERTISEMENT
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.
|