Finding if price data between cells satisfies conditions

Hi, I'm trying to determine if a price at a specified date (x) is greater than all the subequent prices (from date x+1) to another point (Y). I'd like to iterate this so that to the right of this column, I have further columns that show the results from Y to its corresponding previous Xs.

So, basically two conditions.

1. If cell = Y (then this triggers the calculation)
2. if price at x is > prices from x+1 to Y.
3. iterate for Y to all previous x

Spreadsheet attached for reference. Thanks very much.

Maybe you can try showing a more detailed worksheet with various possibilities along with a sample of completed expected results and detail why those are the results expected.

Try this:

In E2:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down

in F2:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down

in G2:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down

Note:

If there are not enough "x's" before the current row, then a blanks is returned.

Is the attached an improvement?

New formulas in E2:G2, respectively:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

each confirmed with CSE key combination and copied down.