Weekly & Monthly High Low Formula for Metastock

[mumbaibiz]

Dear All

Please any body HELP ME for Weekly & Monthly High Low Formula for Metastock.

Kamlesh Gosalia

 

[carbonmimetic]

MONTHLY LOW

Dw:=If(DayOfMonth()<=Ref(DayOfMonth(),-1),1,0);
Wl1:=If(Dw=1,
Ref(LowestSince(1,Dw=1,L),-1),0);
Wl:=ValueWhen(1,Wl1>0,Wl1);
Wl;

MONTHLY HIGH

Dw:=If( DayOfMonth()<=Ref(DayOfMonth(),-1),1,0);
Wh1:=If(Dw=1,
Ref(HighestSince(1,Dw=1,H),-1),
0);
Wh:=ValueWhen(1,Wh1>0,Wh1);
Wh;


Carbonmimetic from ITALY

 

[sam3333]

Hi,

I want to take First three days for a month Highest High & Lowest low value,
Anybody can help me about what will be formula for this?

Thanks in advance.

 

[casey]

MONTHLY LOW

Dw:=If(DayOfMonth()<=Ref(DayOfMonth(),-1),1,0);
Wl1:=If(Dw=1,
Ref(LowestSince(1,Dw=1,L),-1),0);
Wl:=ValueWhen(1,Wl1>0,Wl1);
Wl;

MONTHLY HIGH

Dw:=If( DayOfMonth()<=Ref(DayOfMonth(),-1),1,0);
Wh1:=If(Dw=1,
Ref(HighestSince(1,Dw=1,H),-1),
0);
Wh:=ValueWhen(1,Wh1>0,Wh1);
Wh;


Carbonmimetic from ITALY

Thanks Carbonmimetic, I plotted the above formula in Metastock and it's very useful. I'm trying to change the plot to current month's high and low instead of prev month high and low. I would appreciate if you could help with the modifications of the formula. Casey

 

[rkkarnani]

Found this on the Net :

This indicator has been written for those who want to use Monthly closing or any other monthly price element in their formula's. Indicator provides you a clear curve for each day of monthly closing or according to your required price element. The advantage of this indicator is, you can analyse the daily price chart with monthly curve.

Coding:
{Variables}
x1:=Input("[1]Open [2]High [3]Low [4]Close [5]Vol",1,5,4);
xx:=Input("Nth Periods",1,365,1);

{Data Array}
x1:=If(x1=1,O,If(x1=2,H,If(x1=3,L,If(x1=4,C,If(x1=5,V,C)))));

{Logic}
x:=If(DayOfMonth() <= Ref(DayOfMonth() ,-1),1,0);

{Out put}
(ValueWhen(xx,x>0,Ref(x1,-1)))

 

[dojiexplorer]

if my question is :-

I want to put a formula in column A : display the ABC stock's High on February of 2013 ,

Can anyone help ?

thanks in advance !

 

[purush]

Hi dojiexplorer,

if my question is :-

I want to put a formula in column A : display the ABC stock's High on February of 2013 ,

Can anyone help ?

thanks in advance !

Is it that you want a particular stock's monthly high in the exploration report? or is it that you want explored stock's monthly high for a particular month?

Say you explore a directory containing 50 symbols, you want in Col A one particular stock's monthly high or monthly high of the respective symbol, if that is filtered in your exploration.

please explain with example in detail so that I can try doing something for you.

regards

purush