The buy and sell lines should read Buy:=If(TL>ST AND B>0,1,0); Sell:=If(TL it seems that the sell line of code doesn't post correctly just reverse the buy line and make the result a negative 1

Tenkan Kijun line 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:= ...

THERE ARE SEVERAL WAYS TO COMPARE THEM 1: mov(C,14,S)-Mov(Ref(C,-14),14,S) or you can use the ROC function

You could eliminate an if statement simply by writing  Buy-Sell

you can change the Mult to 2 to get closer to the Close for a tighter stop. on another matter, do you have the PowerPivot Plus Add-on?   Henry   

Dear Alpha, comparing Buy & Hold vs any system depends on the types of assets traded and then on how many periods are loaded into metastock. If you load enough data and then continue to compare a trading system with say 1500 bars all of the time, it's like using a 1500 bar moving average. You get drop off . you have to make sure that your test

Ifyou don't mind, please explain what is the benefit of using an sql server and this patch? I don't want to jump through hoops just to get data!

a formula called renko binary wave   K:=1.896;RenkoLine:=If(Cum(1)=1,CLOSE,If(PREV>=0,If(CLOSE<PREV-2*K,-(PREV-2*K),Floor(Max(C-PREV,0)/K)*K+PREV),If(CLOSE>Abs(PREV)+2*K,-PREV+2*K,Floor(Max(Abs(PREV)-C,0)/K)*K+PREV)));RL:=Abs(RenkoLine);RL; BW:=If(Cum(1)=1,0,If(RL>Ref(RL,-1),+1,If(RL<Ref(RL,-1),-1,PREV)));BW;0;

use the Ref function on your moving average   Ref(mov(V,15,S),-1)   this will shift the moving average to the left by one bar

A:=(HHV(H,50)+LLV(L,50))/2; B:=If(L>a,1,If(H<a,-1,0)); Buy:=B=1 and Ref(B,-1)<>1; Sell:=B=-1 and Ref(B,-1)<>-1; Buy-Sell;;

Dear PCM, The PowerPivot Toolkit is loaded with indicators that enhance the Powerpivot Add-on, they are noted in the indicator list by PP+ then the indicator name. They are not password protected, so you can open them up and see how the External functions work. There are so many indicators, that to give specifics on each would be to ...

are you looking for the 3rd consecutive close above or below a moving average? If(Sum(C>Mov(C,50,S),3)>2,1,If(Sum(C<Mov(C,50,S),3)>2,-1,0));

If I try to download the NYSE advancing issues, declining issues, volume or any of the other Market data symbols, I get an invalid symbol message. I also get this message when I try Data on demand using reuters Datalink.

When I try to download The Market data, I keep getting an invalid symbol Just what are the valid symbols for Market data?   Henry

Any indicator that uses Peak and trough functions will give unreliable signals for trading. they should be used to confirm your position and not be used for establishing a new signal

Please define your system? Long only?long only with trend?long and short?short only?short only with trend? long and short but only with trend? What is your buy signal? what is your exit signal?

A:=if (Sum(Mov(C,20,S)>Mov(C,50,S),50)>49,1,if (Sum(Mov(C,20,S)<Mov(C,50,S),50)>49,-1,0)); A

there can only be 6 scenarios of the 3 MA's 123;213;231; 321;312;132; of these 6 combinations 123 is very bullish,321 is very bearish,213 is still bullish,312 is still bearish,231 is neutral as is 132 now create an indicator rating the scenarios from +3 to -3 ie; 123=+3, 321=-3, 213=+2, 312=-2,231=+1,132=-1 and all else=0

to create Multi time frame indicators you would need PowerPivots + add-on using time data create external function and the time data localize external function if your indicator is just a moving average type ,then just expand the length to match the time frame