Help I have this Excel formula that I need to convert to Metastock: Signal is in column H =if(previousvalue<close,1,0) Value is in column I =if(signal=1,if(close*percent1<previousvalue,previousvalue,close*percent1),if(close*percent2>previousvalue,previousvalue,close*percent2) I located the following formula but it only gives me binary values - I need the values computed on price. If(PREV = 1, If(CLOSE < HighestSince(1,PREV <> 1,CLOSE)*.985, -1,PREV), If(PREV = -1, If(CLOSE>LowestSince(1,PREV <> -1,CLOSE)*1.015, +1,PREV), If(PREV = 0, If(CLOSE>Lowest(CLOSE)*1.015, +1, If(CLOSE<Highest(CLOSE)*.985, -1, PREV)),PREV))) I have tried HighestSince, ValueWhen, etc. but it does not give me the same value as the Excel formula generates. I am currently linking Excel data to Metastock but really would lke to compute this in Metastock. Any assistance is greatly appreciated. Charley

I will try Roy, actually that is what I was trying to describe in the Excel formula I posted. This is an always in system I modified from Larry William's Definative Guide to Futures Trading Vol 1, pp141-144. The signal is always a Buy or Sell. A buy is triggered when the current close is greater than yesterday's computed stop value. The reverse for a Sell. If the current signal is a Buy, it computes today's close times a percent (i.e. .985) and compares to yesterday's value. If the computed value today is lower than yesterday, it keeps yesterday's value. Otherwise it uses the value computed today. If the current signal is a Sell, it computes today's close times a percent (i.e. 1.015) and compares to yesterday's value. If the computed value today is greater than yesterday, it keeps yesterday's value. Otherwise it uses the value computed today. Here is a sample from my Excel worksheet: Date Open High Low Close Signal Stop Value 11/10/2005 1629.56 1651.05 1620.74 1650.93 B 1626.17 11/11/2005 1653.41 1659.72 1651.09 1653.36 B 1628.56 11/14/2005 1653.65 1657.53 1648.26 1651.9 B 1628.56 11/15/2005 1651.97 1658.65 1638.97 1644.31 B 1628.56 11/16/2005 1648.92 1653.74 1642.36 1651.45 B 1628.56 11/17/2005 1659.16 1676.39 1657.27 1676.39 B 1651.24 11/18/2005 1685.05 1689.59 1674.75 1679.85 B 1654.65 11/21/2005 1678.7 1686.79 1673.05 1686.23 B 1660.94 11/22/2005 1686.23 1688.23 1679.73 1680.23 B 1660.94 11/23/2005 1691.96 1704.42 1691.08 1696.77 B 1671.32 And I have attached a screen shot. I hope this is clear, Charley

Charley Is this close to what you're looking for? It has 5 PREVs so you should be careful about the amount of data you open. P1:=0.985; P2:=1.015; Bar1:=Cum(1)=1; Bar2:=Cum(1)=2; Close1:=LastValue(ValueWhen(1,Bar1,C)); Close2:=LastValue(ValueWhen(1,Bar2,C)); StartValue:=If(Close1<Close2,C*p1,C*p2); Trail:=If(Bar1,StartValue, If(PREV<C, If(C*P1<PREV,PREV,C*P1), If(C*P2>PREV,PREV,C*P2))); Trail; Roy MetaStock Tips & Tools