Array Formulas with Multiple Range Criterias - not returning result

I have the attached workbook. I need the formula to review the other worksheet to return value when the below criteria is met:

1. It is in between the Open Datetime and New Closing Time
   If trade is a Buy:
2. Is greater than 10+ Open Price
3. The value in K of the same row as the potential result is greater than the potential value
   If Trade is a Sell:
4. Is less than 10 - Open Price
5. The value in L of the same row as the potential result is less than the potential value

I have tried Index/Match, XLookup, Filter, and Aggregate formulas. But none of them work. I had a friend take a look and he thinks there is something about the arrays that is not working.

I have all the formulas I was trying in the attached workbook with sample data. As can see on the GBPAUD worksheet, I highlighted the green row where the result (in red) that actually meets the criteria. So I know wwhat the value should be returned, but the formulas are not returning that value.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I would appreciate if anyone could advise me on how do I fix this?