Hi -- I am a total newbie, although I have mastered the basics of writing formulas thanks to the Formula Primer. I have a fairly simple question: How do I write a formula to calculate the average daily percent (%) decrease in the closing price for a period N, i.e. calculate the average negative daily percent price change for the period N, ignoring any positive changes (increases) in the same period. I would like to set up a buy signal for when the % change in the latest closing price versus the previous close is smaller than the average daily percent decrease in the closing price for the previous N days. Any ideas? Perhaps there is a formula/system already in existence along these lines? Thanks in advance, Trevor

Thanks for the quick reply Jose! That gets me halfway there; the problem is that I don't believe that AvgDailyCh:=Mov(DailyChange,Nperiods,S); includes only negative ROC values in the average. The price will move up and down over the period in question, but I want to exclude the upward ROC values when calculating the average... Can this be done relatively easily? Cheers, Trevor

ok Jose, I've settled for this... Nperiods:=21; DailyChange:=ROC(C,1,%); DownDailyChange:=ROC(C,1,%)*(ROC(C,1,%)<0); AvgDownDailyChange:=Mov(DownDailyChange,Nperiods,S); short:=DailyChange<AvgDownDailyChange; long:=DailyChange>AvgDownDailyChange; long-short Agree? Thanks for the help, Trevor