Formula Assistance

Copyright and Legal statement

henry1224 — Fri, 13 May 2005 06:41:03 GMT

All Rights Reserved

Copyright©2005

The original authors retain all rights to formulae that they post..
The end users may use the formulae for personal use only.

The formulae provided are not a recommendation to buy or sell, but rather a guideline to interpreting the specified analysis method.

This information should only be used by investors who are aware of the risk inherent in securities trading.

The authors accept no liability whatsoever for any loss arising from any use of these formulae.

next Higher low

budfox45 — Sat, 21 Nov 2009 04:29:39 GMT

I need help in placing a buy arrow on the next higher low AFTER b:=if(L>A,1,L);

B would be a set up bar the next low thats higher then the high of b would be

the Symbol bar

Thanks

A:=(HHV(L,50) + LLV(L,50))/2;

b:=If(L>A,1,L);

SELL:=b=-1 AND Ref(b,-1)<>-1;

BUY:=b=1 AND Ref(b,-1)<>1;

buy-sell;

BUY:=b=1 AND Ref(b,-1)<>1;

;

VALUE OF INDICATOR AT A PRICE PEAK

abu_shabuasi — Wed, 18 Nov 2009 08:15:31 GMT

WHAT IS THE FORMULA TO FIND VALUE OF STOCHASTIC ( 11,3) AT PEAK (1,H,3)

I WILL BE THANKFUL FOR EVERY ANSWER

Trailing stop loss in system tester

dhirbisht — Tue, 17 Nov 2009 06:33:32 GMT

I am testing system in system tester from last 6 month and still I am struck in the concept of trailing stop method used in metastock. I tried so many codes for trailing stop loss in system tester but the results vary. Can any one help me and tell about what exactly codes or concept used in trailing stop loss and initial stop loss in metastock system tester.

Pivot point forumula

AshBird — Sat, 14 Nov 2009 13:10:57 GMT

Hi Guys and Gals, first post. I'm looking for a pivot point formula to use on a weekly and daily chart. Can anyone assist?

Happy trading,
AshBird

How to get rid of the same value

Nathan — Tue, 17 Nov 2009 02:14:55 GMT

Hello,

I build a simple indicator as follows:

var1:=ValueWhen(1,H*0.909>PREV,H);
var1

It plots the H which is >= 10% growth of the previous H and it counts from the first bar.

But if I use it in System tester as follows:

{Buy signal:}
var1:=ValueWhen(1,H*0.909>PREV,H);
var1=H

If there are more than one H equals to var1, the system will activate the buy as well, which it should not.

Anyone can help me with that to get rid of those values, just make the tester to follow the indicator.
Thanks.

Regards,
nathan

Exploration combining CCI and MACD

tonya030 — Sat, 14 Nov 2009 02:35:41 GMT

I would appreciate if anyone can help me put together an exploration using the CCI and MACD. I am ok doing an expl. for each one and even combining them, but they are not giving me what I really want and God only knows I have tried but when it come to putting it together I am baffled. But anyhow, here is what I would like the exploration to do:

Find stocks where the CCI is below -100 and rising and the MACD is below 0 and increasing positive from previous bar.

Any help immensly appreciated; in the meantime I will go back into the book or find some tutorial stuff on the net.

Tonya030

Scanning for stock make 52 week high/Low

MAkleung — Fri, 13 Nov 2009 15:27:58 GMT

Dose any one know how to write a formula to scan for stock make 52 week high/low ? In addition, where I could find book about how to write Metastock code. I have experience in visual basic and easy language.
Thanks for all your help
Mak

How to plot the same value for just once

Nathan — Mon, 09 Nov 2009 04:06:15 GMT

Hi guys,

Could you help me with this, please?

How can I plot the same value for just once when they meet some condition.

E.g. C1=10, C2=9, C3=8, C4=9, C5=7

Condition: C
What i want to plot is 9,8,0,7, not 9,8,9, 7.

Many thanks.

nathan

Can I initialize prev with some value <>0?

Nathan — Sun, 08 Nov 2009 03:59:44 GMT

Hi,

I know the first prev is assumed to be 0. My question is: can I initialize prev with some other value.

E.g. IF plot C*1.03
Thanks.

Nathan

Can anyone program a cumulative product function?

exito100 — Sat, 07 Nov 2009 05:40:27 GMT

Is there a way to program in Metastock Formuar language a product of all e.g. closing values without a prev function?

product:=value1*value2*value3....*last value

for example as in:

product:=C*PREV;

is very slow.

In other words I am looking for the product equivalent of the cum() function.

I keep looking and trying.. but if someone figures this out earlier please post here!

Many thanks,

Klaus

std ?

neocon — Mon, 19 Oct 2009 19:14:21 GMT

hi,

could someone explain the meaning of "std" in the formula below?

is it standart deviation or sth else?

((C+2*Std(C,21)-Mov(C,21,S))/(4*(Std(C,21)))*100

thanks,

consolidation detector

garp — Sun, 01 Nov 2009 14:37:43 GMT

Need some help please. How can I intialize a constant value in MS? The manual is no help on this. I'm writing a trivial exploration where the price at t-n is within the channel formed by the high and low at t, + and - a specified percentage.

It seems the constant values for my channel are constantly changing rendering my algorithm useless. The code:

{ change the next 3 lines to change search criteria }
upPct:=.20; { 20 % }
dwnPct:=.20; { 20 % }
lookBack:=10;

baseHigh:=ref(H,0);
baseLow:=ref(L,0);

upLimit:=baseHigh+(baseHigh*upPct);
dwnLimit:=baseLow-(baseLow*dwnPct);

hiHigh:=HHV(H,lookBack);
lowLow:=LLV(C,lookBack);

{ if condition is true, return 1, els, return 0 }
If( upLimit <= hiHigh AND dwnLimit >= lowLow, 1, 0 )

Thanks in advance

Has anyone found a TD Sequential expert or addin that works sucessfully

SAILBEARS1 — Wed, 04 Nov 2009 15:37:27 GMT

I have seen many posts on here but none claims to work or be easy to load in. Thanks for any help.

anyone can help code these formulae

bull&bear — Fri, 23 Oct 2009 03:49:26 GMT

1) the nr of days macd > than its signal line.

2)the nr of days macd > 0

3)the nr of days close > parabolic stop & reversal (0.2, 0.02)

4)the nr of days ema20 > ema5

5)the nr of days counting backwards from today golden cross(ema20cross over & cut above ema50) has taken place.

Explorer producing same results each day

DaBassman — Sat, 31 Oct 2009 01:59:18 GMT

I have been using a formula in Explorer for a few years but for some reason it
has begun producing the same results each day that I run Explorer (EOD) although
the securities data is being updated daily correctly. This is the first time this has happened since I have been running Explorer for this formula. I even tried other Explorer formulas and got the same results. Any ideas? Thanks!

Peace!

Charles

P.S. The "most recent date" in Explorer Options is selected.

Questions about backward Reference

Nathan — Mon, 02 Nov 2009 00:31:26 GMT

Hi,

If i want to buy every time the close price goes up 10%, then close out, and then sell short every time the close drops 10%. How should I code.

E.g. C1=8,
C2=9 (buy)
C3=10(buy)
Then sell at C4
Then when C5=10
C6=8 (Sell short)

C10=6(Sell short)

C12=4 (Sell short)
My buy/sell short conditon is based on the previous buy/sell short price.

I have asked similar questions about it before. First of all, Thank you for replying.

I saw some people have this kind of backward reference questions as well, and GV.dll or latch or prev/valuewhen are advised. But I am still not quite understand how to use GV.dll and latch.

I have work out the formula for buy conditon, and it is fine to me:

var1:=valuewhen(1,C*0.9>prev, C);
var2:=valuewhen(2,C*0.9>prev, C);
Cross(var1,var2*1.1)

But, when I use the similar idea in sell short. It doesnt work.

I am still new to MS, so if you have a better solution for this, please help me with this. Thanks.

How can I write this with Metastock

rsdamha — Sat, 31 Oct 2009 11:51:41 GMT

Hi ,

How can I write a code that gives me a continuous value if condition A is continuing true.lets try this by using volume with condition ( value remains max ):
day --------- volume
1---------------- 5
2---------------- 2
3---------------- 3
4---------------- 6

At day 1 value is 5
day 2 value is 5
day 3 value is 5
day 4 valye is 6

How can I write this with metastock?

Thank you

Ichimoku Kinko Hyo Expert

henry1224 — Tue, 19 Apr 2005 09:04:32 GMT

This expert uses the default values from the standard indicators.

You will need the PowerPivots plus Add-on to use this Expert

Highlights

long

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B>0

Short

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B<0

out

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B=0

Symbol Tab

Long entry

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B>0 AND Ref(B,-1)<=0

Short entry

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B<0 AND Ref(B,-1)>=0

Long Exit

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B=0 AND Ref(B,-1)>0

Short Exit

ST:=(HHV(H,26)+LLV(L,26))/2;
TL:=(HHV(H,9)+LLV(L,9))/2;
A1:=Ref((ST+TL)/2,-25);
A2:=Ref((HHV(H,52)+LLV(L,52))/2,-25);
LE:= If(A1>=A2,Cross(C,A1),Cross(C,A2));
LX:= If(A1>=A2,Cross(A1,C),Cross(A2,C));
SE:= If(A1>=A2,Cross(A2,C),Cross(A1,C));
SX:= If(A1>=A2,Cross(C,A2),Cross(C,A1));
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B=0 AND Ref(B,-1)<0

What are the security function symbols for different time frames? Please?

Biff Malibu — Thu, 29 Oct 2009 16:19:51 GMT

I'd like to do a system test using different time frames of same symbol. I have loaded SPY Daily, SPY Weekly, and SPY monthly into a folder called SPY data using the downloader. I'd like to pull these securities into a system test but I can't find the actual symbols anywhere...

I know security("C:\Metastock Data\SPY DATA\"SPY",C) pulls the Daily, but how do I pull the weekly and monthly??? Thanks for any help...

Biff

How'd you guys like that GDP report today? Caught a lot of people by surprise.

Limit Entry

Adelaide — Wed, 28 Oct 2009 06:38:30 GMT

Hi all,

Can someone please help with the code for the following details-

Limit buy order for tomorrow at

Todays Low - 1*ATR (10)

Rounded to 2 decimal places

Thanks in advance

Countback Lines Expert

henry1224 — Sun, 17 Apr 2005 06:29:16 GMT

To create this expert, you have to create 2 custom indicators first
{Countbacklines buy}
Days:=10;
BV:=If(L>LLV(L,Days),PREV,
If(Ref(H,-2)>Ref(H,-1) AND Ref(H,-1)>H,Ref(H,-2),
If(Ref(H,-3)>HHV(H,3) AND Alert(Ref(H,-1)>H,2),Ref(H,-3),
If(Ref(H,-4)>HHV(H,4) AND Alert(Ref(H,-1)>H,3),Ref(H,-4),
If(Ref(H,-5)>HHV(H,5) AND Alert(Ref(H,-1)>H,4),Ref(H,-5),
PREV)))));
BV;

{Countbacklines Sell}
Days:=10;
SV:=If(H<HHV(H,Days),PREV,
If(Ref(L,-2)<Ref(L,-1) AND Ref(L,-1)<L,Ref(L,-2),
If(Ref(L,-3)<LLV(L,3) AND Alert(Ref(L,-1)<L,2),Ref(L,-3),
If(Ref(L,-4)<LLV(L,4) AND Alert(Ref(L,-1)<L,3),Ref(L,-4),
If(Ref(L,-5)<LLV(L,5) AND Alert(Ref(L,-1)<L,4),Ref(L,-5),
PREV)))));
SV;

Now for the expert
under the highlight tab

Long

Buy:=Cross(C, Fml( "Countbacklines buy"));
Sell:=Cross(Fml( "Countbacklines Sell"),C);
D:=If(BarsSince(Buy)<BarsSince(Sell),-1, If(BarsSince(Buy)>BarsSince(Sell),1,0));
D=-1

Short

Buy:=Cross(C, Fml( "Countbacklines buy"));
Sell:=Cross(Fml( "Countbacklines Sell"),C);
D:=If(BarsSince(Buy)<BarsSince(Sell),-1, If(BarsSince(Buy)>BarsSince(Sell),1,0));
D=1

now under the symbol tab

EL

Buy:=Cross(C, Fml( "Countbacklines buy"));
Sell:=Cross(Fml( "Countbacklines Sell"),C);
D:=If(BarsSince(Buy)<BarsSince(Sell),-1, If(BarsSince(Buy)>BarsSince(Sell),1,0));
D=-1 AND Ref(D,-1)>-1

ES

Buy:=Cross(C, Fml( "Countbacklines buy"));
Sell:=Cross(Fml( "Countbacklines Sell"),C);
D:=If(BarsSince(Buy)<BarsSince(Sell),-1, If(BarsSince(Buy)>BarsSince(Sell),1,0));
D=1 AND Ref(D,-1)<1

buy at preceding high

buyandsell — Sat, 24 Oct 2009 20:51:09 GMT

buy if once the highest price higher than preceding high :

H> REF(H,-1)

it may buy at preceding high or higher or lower, it depends on the closing price, however, how to make it to buy at preceding high only while using EST? any setting in EST should I set?

Is it possible to return the Close or date when my previous order was executed

Nathan — Sun, 25 Oct 2009 04:31:28 GMT

Hi,
I know Ref(DATA ARRAY, Period)
But my problem is every time the periods changes.

So my question is can I get the close price when my previous order was executed some days ago. If I can, what formula should I use.

Thanks

Can someone code this, please?

Nathan — Tue, 13 Oct 2009 23:40:33 GMT

Hi, how should I code if I want to buy shares when the price increases like 5% and close out when it goes down 10% in like 2 yrs.

I am sure this is simple for you. I am a new user, so if you can code this, please give me some hints. Many thanks.