Re: [EquisMetaStock Group] Re: Pivot Point Exploration

["Wiro Hardy" <wiro.pribadi@xxxxxxxxx>]

Preston,
Many thanks for your email.

Oddly enough, after I leave it no hope few weeks ago, today with a little
tweak, its work :)

In case somebody in this mailing list may need it, this is a indicator code
for S1, S2, S2, R1, R2 and R3:

{ Month' start }
m:=Month()<>Ref(Month(),-1);

{ Month's OHLC }
{Om:=ValueWhen(2,m,O);}
Hm:=ValueWhen(1,m,HighestSince(2,m,H));
Hm:=ValueWhen(1,Hm>0,Hm);
Lm:=ValueWhen(1,m,LowestSince(2,m,L));
Lm:=ValueWhen(1,Lm>0,Lm);
Cm:=ValueWhen(1,m,Ref(C,-1));
Pivot:= (Hm+Lm+Cm)/3;
{ Pivot levels }
r3:=Hm+2*(Pivot - Lm);
r2:=Pivot+Hm-Lm;
r1:=Pivot*2-Lm;
s1:=Pivot*2-Hm;
s2:=Pivot-Hm+Lm;
s3:=Lm-2*(Hm - Pivot);

{ Plot on daily chart }
r3;r2;r1;s1;s2;s3;

For is the exploration code:
ColA: S1/C
m:=Month()<>Ref(Month(),-1);

{ Month's OHLC }
{Om:=ValueWhen(2,m,O);}
Hm:=ValueWhen(1,m,HighestSince(2,m,H));
Hm:=ValueWhen(1,Hm>0,Hm);
Lm:=ValueWhen(1,m,LowestSince(2,m,L));
Lm:=ValueWhen(1,Lm>0,Lm);
Cm:=ValueWhen(1,m,Ref(C,-1));
Pivot:= (Hm+Lm+Cm)/3;
{ Pivot levels }
r3:=Hm+2*(Pivot - Lm);
r2:=Pivot+Hm-Lm;
r1:=Pivot*2-Lm;
s1:=Pivot*2-Hm;
s2:=Pivot-Hm+Lm;
s3:=Lm-2*(Hm - Pivot);

s1/C

ColB: S2/C
{ Month' start }
m:=Month()<>Ref(Month(),-1);

{ Month's OHLC }
{Om:=ValueWhen(2,m,O);}
Hm:=ValueWhen(1,m,HighestSince(2,m,H));
Hm:=ValueWhen(1,Hm>0,Hm);
Lm:=ValueWhen(1,m,LowestSince(2,m,L));
Lm:=ValueWhen(1,Lm>0,Lm);
Cm:=ValueWhen(1,m,Ref(C,-1));
Pivot:= (Hm+Lm+Cm)/3;
{ Pivot levels }
r3:=Hm+2*(Pivot - Lm);
r2:=Pivot+Hm-Lm;
r1:=Pivot*2-Lm;
s1:=Pivot*2-Hm;
s2:=Pivot-Hm+Lm;
s3:=Lm-2*(Hm - Pivot);

s2/C

We can sort coloum A and B to see which securities is near or at S1 and S2.

My questions:
1. How to filter results that shown "N/A" ?
2. Shouldn't available a better way to code the exploration since we can see
the code is very repetitive

Thanks again,
Wiro.



On 9/2/07, pumrysh <no_reply@xxxxxxxxxxxxxxx> wrote:
>
>   Wiro,
>
> I would think that your problem would be in how you define close or
> near so you will need to tell us what you were using for that.
>
> Preston
>
>


[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/