Formula for algorithm

[santiago_dl]

Hi everybody,

I make an effort to be very clear, if it's not, I will dedicate myself to another thing hah.



Table Below shows the prices and times where I calculate the data I need:



Date time Open High Low Close Volume
1/6/12 10:02 68.00 68.00 68.00 68.00 53064
1/6/12 10:01 67.96 68.04 67.86 68.04 58543
1/6/12 10:00 67.95 68.03 67.91 67.95 18531
1/6/12 9:59 68.10 68.11 67.91 67.97 38883
1/6/12 9:58 68.08 68.13 68.08 68.10 21993
1/6/12 9:57 68.25 68.15 68.07 68.08 45585


In the table below, I calculated with this formula =+INDEX(C$2:C$52545,MATCH(1,IF(A$2:A$52545=AA3,IF( B$2:B$52545<=$AA$2,IF(ISNUMBER(C$2:C$52545),1))),0 )) the open price at a specific time (9:57 in this case) for a specific date.

Date Open
9:57
1/6/12 68.25
1/5/12 58.38
1/4/12 54.65
1/3/12 54.51

What I need now is:

If 68.25 - 0.25 "68.00" or less exist from 9:57 to 13:00 give me the time/price when that happens.

The problem:

Date time Open High Low Close Volume
1/6/12 10:02 68.00 68.00 68.00 68.00 53064
1/6/12 10:01 67.96 68.04 67.86 68.04 58543
1/6/12 10:00 67.95 68.03 67.91 67.95 18531
1/6/12 9:59 68.10 68.11 67.91 67.97 38883
1/6/12 9:58 68.08 68.13 68.08 68.10 21993



This was the open price
Date Open
9:57
1/6/12 68.25


And from 9:57 to 10:00
Date time Open High Low Close Volume
1/6/12 10:00 67.95 68.03 67.91 67.95 18531


You can see in the table above that the price went down for more than 25 cents at 10:00.
I need a formula that gives me in return the time when that happens, in this case 10:00.


Thank you very much,
Santiago