Please help to develop a moving average indicator as below;

weekly pivot point = ( weekly high + weekly low + end of the week close)/3

3 period weekly pivot point average = (1st week pivot point + 2nd week pivot point + 3rd week pivot point )/3

Thanks.

Roy,

Thanks a lot for your help , once again I need your help to develop a moving average indicator as below;

monthly pivot point = ( monthly high + monthly low + end of the month close)/3

3 period monthly pivot point average = (1st month pivot point + 2nd month pivot point + 3rd month pivot point )/3

[:)]

Thanks.

lamkeng

Roy,

Thank you very much . What is the different between static , dynamic and delay mode ? Thanks.

from

lamkeng

Hi Lamkeng

I was about to post the following reply when the forum crashed yesterday. It might help someone else so I'll post anyway.

"Static" reports end-of-month (or end-of-week) values on the last bar of month when possible, otherwise on the first bar of the next month. If you had a month with only 1 EOD bar the end-of-month values for that month could not be reported by the indicator until the beginning of the following month. This would be a rare situation but certainly not unheard of. Note that "Static" does not update on the very last bar of a chart.

"Dynamic" is the same as "Static" except that the current (last) month is plotted dynamically as the month is formed with each EOD bar. The indicator updates the current month as each new bar is added, whereas "Static" cannot update until the first bar of a new month is in place (this only applies to the last bar).

"Delayed" holds reporting of results from every month until the first bar of the new month. Think of it as Dynamic mode delayed by one EOD bar.

These options give you choices about how you use the indicators for display, back test or explorations. For example, Dynamic is probably most useful when plotting on a chart. However, when back testing you might want to set to Delayed mode so that there's no danger of trading end-of-frame values (say the end-of-month CLOSE) before that information is actually available. If a trading system buys and sells with a 1-bar delay then there's no need to use the Delayed mode.

Roy

MetaStock Tips & Tools

Hello everyone,

Mr. Roy Larsen is a gem of a person, always ready to help people out. I'm speaking from personal experience.

arun

Mahen

Sorry, I don't understand your question.

Roy

Dear mstt,

I have coded this formula. Is it correct?

{Daily Pivot Point SMA}

{This indicator uses the Equis Forum DLL}

{Roy Larsen, 2004-2007}

{User settings}

N:=Input("Daily Pivot Point SMA, Periods",1,99,3);

Q:=Input("Mode, 0=Static 1=Dynamic 2=Delayed",0,2,1);

{0, update at last bar of current frame}

{1, update on each new bar}

{2, update on first bar of new frame}

{Daily frame timing}

{* Day counter from metastock@wabbit.com.au}

M:=Month();A:=Int((14-M)/12);D:=DayOfMonth();

Y:=Year()+4800-A;B:=M+(12*A)-3;

M:=D+Int((2+153*B)/5)+(365*Y)+Int(Y/4)-Int(Y/100)+Int(Y/400)-32045;

{*}I:=Int(M/7);

I:=I-ValueWhen(2,1,I);

G:= LastValue(Highest(Sum(DayOfWeek()<>

ValueWhen(2,1,DayOfWeek()),5))=5);

F:=G+(M=0)*ExtFml("Forum.Sum",Ref(I,1),1);

A:=LastValue(Cum(1)-1)=Cum(1);

B:=Alert(A,2)*(A=0);

J:=If(F,1,If(Alert(F,2)=0 AND M,2,0));

J:=If(A+LastValue(J)>2 OR B+(Q=1)=2,1,J);

J:=If(G,1,If(Q=2 OR Cum(J)<=1,M*2,J));

{Calculate weekly HLC prices}

Hw:=HighestSince(1,M,H);

Hw:=ValueWhen(1,J,If(J=1,Hw,ValueWhen(2-G,1,Hw)));

Lw:=LowestSince(1,M,L);

Lw:=ValueWhen(1,J,If(J=1,Lw,ValueWhen(2-G,1,Lw)));

K:=ValueWhen(1,J,If(J=1,C,ValueWhen(2-G,1,C)));

Hw:=ValueWhen(1,Hw>0,Hw);

Lw:=ValueWhen(1,Lw>0,Lw);

PP:=(K+Hw+Lw)/3;

{Calculate and plot SMA of daily pivot points}

J:=J>0; X:=Cum(J*PP);

(X-ValueWhen(N+1,J,X))/N;

REGARDS

SENTHIL KUMAR.M

To enable us to provide more efficient support, use the "Reply" feature in 
your email program when
responding to this email. Please send unrelated issues in a new email.
 

-----------------------------------------------------------------------
 
 
Dear Mahendra Bhavsar
 
Thank you for contacting MetaStock support, my name is William and I
will be taking ownership of your issue today. Here are the pivot point
formulas you asked for.
 
Daily:
new:=ROC(DayOfWeek(),1,$)<>0;
yh:=ValueWhen(1,new, Ref(HighestSince(1,new,H),-1));
yl:=ValueWhen(1,new, Ref(LowestSince(1,new,L),-1));
yc:=ValueWhen(1,new, Ref(C,-1));
 
pp:=(yc+yh+yl)/3;
r1:=(pp*2)-yl;
s1:=(pp*2)-yh;
r2:= pp+r1-s1;
s2:= pp-r1+s1;
r3:= pp+r2-s2;
s3:= pp-r2+s2;
 
r3;
r2;
r1;
pp;
s1;
s2;
s3;
 
 
 
Weekly:
new:=ROC(DayOfWeek(),1,$)<0;
yh:=ValueWhen(1,new, Ref(HighestSince(1,new,H),-1));
yl:=ValueWhen(1,new, Ref(LowestSince(1,new,L),-1));
yc:=ValueWhen(1,new, Ref(C,-1));
 
pp:=(yc+yh+yl)/3;
r1:=(pp*2)-yl;
s1:=(pp*2)-yh;
r2:= pp+r1-s1;
s2:= pp-r1+s1;
r3:= pp+r2-s2;
s3:= pp-r2+s2;
 
r3;
r2;
r1;
pp;
s1;
s2;
s3;
 
 
 
Monthly:
new:=ROC(Month(),1,$)<>0;
yh:=ValueWhen(1,new, Ref(HighestSince(1,new,H),-1));
yl:=ValueWhen(1,new, Ref(LowestSince(1,new,L),-1));
yc:=ValueWhen(1,new, Ref(C,-1));
 
pp:=(yc+yh+yl)/3;
r1:=(pp*2)-yl;
s1:=(pp*2)-yh;
r2:= pp+r1-s1;
s2:= pp-r1+s1;
r3:= pp+r2-s2;
s3:= pp-r2+s2;
 
r3;
r2;
r1;
pp;
s1;
s2;
s3;
 
 
 
Please contact us if there is anything further we can help you with,
have a nice day!
 
Thank You,
 

Hi Senthil

I need more information before I can consider your request. What do you mean by “dynamic”? I know what it means when used in my code but I’m not sure that your meaning is the same. Also, a “cross” of one signal above two others very rarely occurs on one bar. What would be more realistic to search for is a cross of the faster signal across the higher of the two slower signals. Other cross possibilities would perhaps need to be allowed a range of bars in which to check for successive crosses. Limiting to multiple crossovers on the same bar is not a particularly useful exercise so can you be more specific about this. Is you base data EOD or intraday?

Regards

Roy