rob, Its a bit late for me to strat thinking too ghard on this one, but I would start by defining when 41 bars ago occurs: you can then start counting from there: CloseDiff:=LastValue(C)-C; x0:=Cum(1)>(LastValue(Cum(1))-41); x1:=If(x0=1 AND CloseDiff<0 AND BarsSince(x0=1 AND CloseDiff>0)>0, PREV+CloseDiff,PREV); x1; Does this do what you want? I didnt get the full grasp of exactly what you were looking for. Perhaps a drawing or graph might help? wabbit :D

You cannot list them, but you can certainly count them to return the total days: Just return the +ve days and -ve days: {uses Roy Larsen's latch} lookback:=41; CloseDiff:=LastValue(C)-C; x0:=Cum(1)>(LastValue(Cum(1))-lookback); Up:=If(x0=1 AND CloseDiff>0,PREV+1,PREV); Dn:=If(x0=1 AND CloseDiff<0,PREV+1,PREV); Up; -Dn; To count the number of consecutive days: {uses Roy Larsen's latch} lookback:=41; CloseDiff:=LastValue(C)-C; x0:=Cum(1)>(LastValue(Cum(1))-lookback); N:=x0=1 AND CloseDiff<0; X:=x0=1 AND CloseDiff>0; I:=Cum(N+X>-1)=1; Tr:=BarsSince(I OR N)<BarsSince(I OR X); Dn:=-If(Tr,BarsSince(tr=0),0); Tr:=BarsSince(I OR X)<BarsSince(I OR N); Up:=If(Tr,BarsSince(tr=0),0); Up; Dn; Thats about the limit of my imagination tonight.... Let me know how it goes. wabbit :D

Wabbit, just got back in, thanks for all the info, something to be getting on with this evening, let you know how it goes. Regards Robert

also proves the age old.... Don't ask - don't get wabbit :D

Wabbit. I thought Id explain what Im doing. I dont know how to add pictures. Basically I have a weekly chart with 41 week centered m/a. (plotted 20 weeks prev). on this chart I have a horizontal line marking the point 41 weeks ago. This is my drop point for the average. As Im sure you know the next calculated m/a point is add this weeks close and drop close 41 periods ago. This is all from brian Millards Books. Imagine youve printed two copys of your charts, one you place infront of you, the other you cut through the horizontal line and discard the piece prev to this point. taking the remaing piece with todays prices on lay at the end of your other copy. This gives a quick visual as to wether tommorows m/a wil rise or fall. Ie if price greater than 41 weeks ago then rise and vica versa. I cant really to this for 100 or so shares in metastock so I thought an Indicator taking todays close from 41s ago would be as good. if its minus then rising positve then falling. Taking it one stage further and anticipating the future, Ive assumed todays close will be tommorows and day after and forever. (obviously it wont). The todays close - 41, then -40, -then -39 etc which I have with CloseDiff:= LastValue(C)-C ; CloseDiff; Now with the indicator rabbits advised I have quick visual on the amount of weeks the m/a would rise or fall if the price remained the same. I have to emphasise this is in no way a buy/sell indicator, it is a quick visual aid to the m/a anticipated performance. What Ive found though is the greater the distance from 0, you would have to have a dramatic price change today to alter the m/a. The reason for the ability to show the data in the title bar is twofold, 1 im lazy it saves me counting the bars when scanning through 100 shares and 2, when doing an exploration I d like to able to ask for shares which have been +ve for more than 5 weeks from 41 weeks ago. Sorry if Ive waffled on Regards Robert

First attempt attachment. You may be searching the wrong millard, its Brian Millard Channel Analysis based on J hurst. Here Goes. Regards Robert

Wabbit, Ive got broadband, tommorow Im back at work, I work shift, next 4 days Im on days. Ill look at skype and have a look at ms chat, didnt realise there was a chat room. Ive seen the quodos site before, and have his software, but its very unflexible and ties you into his ideas, which although I like some, its of no benefit if I cant try others. Regards Robert

Hi, I need a formula to add to itself whenever a condition is true. But the numbers i check manually is incorrect. I have tried to use PREV function in the bold section to make it remember the last X value but it still won't work. Please help. Thanks, Edwin C1:=(O<=Ref(H,-1) AND O>=Ref(C,-1)); X:=Cum(Fml("open-close")); C2:=If(C1,X,Ref(X,-1)); C2

Hi Wabbit, Thanks for the prompt response. Yes, fml("open-close") is indeed Open-Close price. I tried exactly the Prev function as what u suggested earlier on but the summation value is still incorrect. This are my results: C1:=(O<=Ref(H,-1) AND O>=Ref(C,-1)); C2:=If(C1,Fml("open-close"),PREV); C2 Bar1 - C1 is False, Open-close=0.25, therefore C2 return value of 0 Bar2 - C1 is True, Open-close=0.75, C2 returns value of 1 (bar1+bar2) or 0.75 I still cant figure it out. Maybe u can try on yr stocks to see what I mean. Thanks, Edwin

Do you not want to reset it? like: C1:=(O<=Ref(H,-1) AND O>=Ref(C,-1)); C2:=If(C1,Fml("open-close")+PREV,PREV); C2 Patrick :mrgreen: