Bruce - your firmua is working great.  Thanks verymuch for your help!

Hi! I have a pcf which looks for compression - in other words, "todays" bar&#39;s Open - Close value is 25% or less of the High - Low range of the previous bar.  I have the code written as: abs(O-C) <=(H1-L1)*.25.

i am getting bizzare reuts where the scan flags charts where todays bar is much lager than yesterday&#39;s.  The scan had ben working fine untl recently.  Ay idea what is going on or how I need to re-write tthe pcf to get the desired results?

Thanks vey much!

Your formula is perfect - thanks very much!

Hi - I am working on a pcf condition which finds situations where the Open - Close of todays bar is less than 25% of the daily range of the prior  days bar.  I have written the pcf as SQR((O-C)*(O-C))<=(H1-L1)*.25.  I have used thwe square root of the square of the open - close range so that the result is a positive number reguardless of whether the bar closes higher or lower on the day.  When I use this formula to scan a list of 85 stocks, it returns very few positive results and misses many stocks which return "true" when the condition is checked on the individual stocks.

I also have modified the formula to look for the same result when comparing yesterdays open / close range versus the daily range from two day ago.  I have written the modified formula as SQR((O1-C1)*(O1-C1))<=(H2-L2)*.25  This version of the pcf always returns every stock in my scan list as "true" even though most of the stocks do not meet the criterea.

Do you have any idea of what I am doing wrong?

Thanks very much!!!!!!!

I would be thrilled to have you call me at 5123-919-1233 as this is driving me crazy