Search results

sure. strangely, i remember posting this: =IF(AND(C4<C3,C3>=C2),MIN(B3:B7),0) and not what is posted in my response. the above formula matches the worded logic of that post. you could expand it further to match your desired criteria. for example, if you want to check if this high...

=IF(AND(C3<C2,C2>=C1),MIN(B3:B7),0) column c = highs, column b = lows. assuming you place this in row 2, it means: if the next high is lower than this high, and this high is higher than or equal to the previous high, then find the minimum low of the next five lows, otherwise output is zero...

maybe we are almost there? apple is great but the stock has moved up rapidly. 80 could be an interesting target in the short term:

daily chart of mini s&p, trading at 1264 <img src="http://i32.photobucket.com/albums/d32/prajsanders/11-22-2005-esdaily.jpg">