Spreadsheet: 737669d1624536359-xlookup-with-multiple-criteria-finding-if-a-date-time-falls-within-two-dates-and-times-sample-book
Sheet: Trade Analysis

30 | Mins between for Duplicates |  |  |  | Number of Rows in this Worksheet |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Pair's Rows to Search in [NAME] |  |  |  |  |  |  | 60000 | : [NAME] by this Minutes | Static Equations |  |  |  |  |  |  | Indirection of Trade |  | L1L2 Cross |  |  |  |  | [NAME] |  |  |  |  | WZ Expansion before entry |  |  |  |  | WZ Collabpse before entry |  |  |  |  | WZ Phase |  |  |  |  | Pips between 1m to 5m [NAME] | Min Pips to the Box |  |  |  | [NAME] for entry |  |  | RB for Entry |  |  |  | Dynamic vs OneClick |  | Clear Lanes Calculations |  |  | <---- TEST FORMULA |  |  |  |  |  |  |  |  |  |  |  | Clear Lanes |  |  |  | WZ Included for Entry |  |  |  |  | 10 | 10 |  |  | 9.999999999998899 | 10 | 20 |  |  | -9.999999999998899 | 10 | 30 |  |  | -9.999999999998899 | 10 | 40 |  |  | -9.999999999998899 | 10 | 50 |  |  | -9.999999999998899 | 20 | 10 |  |  | 9.999999999998899 | 20 | 20 |  |  | -20.00000000000002 | 20 | 30 |  |  | -20.00000000000002 | 20 | 40 |  |  | -20.00000000000002 | 20 | 50 |  |  | -20.00000000000002 | Play Defense | 10 |  | 10 | [NAME]: | 5 |  | Play Defense | 10 |  | Play Defense | 10 |  | Play Defense | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swing Stop | 15 | 70 | Dynamic Settings | 70 |  | Ris/Reward    1: | 2 | Dynamic TP |  |  |  |  |  |  |  | Dynamic SL
Settings | Ticket | Open_Date | Open_Hour | Duplicates | Close_Date | Symbol | Action | Lots | SL | TP | Open_Price | Close_Price | Commission | Swap | Pips | Profit | Gain | Signal | Magic_Number | Duration | NumOpenTrades | ConcurrentTrade | PreviousTradeCloseDate | Pip_Conv | News_Before | News_During | New_Closing_Time | [NAME] | Min | Max_SL_Distance | Max_TP_Distance | L1_1m_in_Direction | L1_5m_in_Direction | L1_15m_in_Direction | L1_60m_in_Direction | L1_240m_in_Direction | L1L2_1m_Cross | L1L2_5m_Cross | L1L2_15m_Cross | L1L2_60m_Cross | L1L2_240m_Cross | L1L7_1m_Cross | L1L7_5m_Cross | L1L7_15m_Cross | L1L7_60m_Cross | L1L7_240m_Cross | WZ_1m_Expanse | WZ_5m_Expanse | WZ_15m_Expanse | WZ_60m_Expanse | WZ_240m_Expanse | WZ_1m_Collapse | WZ_5m_Collapse | WZ_15m_Collapse | WZ_60m_Collapse | WZ_240m_Collapse | WZ_1m_Phase | WZ_5m_Phase | WZ_15m_Phase | WZ_60m_Phase | WZ_240m_Phase | Min_Pips_5m_1m_Box | Min_Pips_to_1m_Box | [NAME] | Min_Pips_to_15m_Box | Min_Pips_to_60m_Box | Require_1m_L7_entry | Require_15m_L7_entry | Require_1m_WZ_for_entry | Require_1RB_for_Entry | Require_2RB_for_Entry | Require_3RB_for_Entry | Require_4RB_for_Entry | Pips_bw_OneClick_Dynamic | Time_bw_OneClick_Dynamic | Lanes_1mMA | Lanes_1mBand | Clear_Lanes_1m_in_Pips_ | Lanes_5mMA | Lanes_5mBand | Clear_Lanes_5m_in_Pips_ | Lanes_15mMA | Lanes_15mBand | Clear_Lanes_15m_in_Pips_ | Lanes_60mMA | Lanes_60mBand | Clear_Lanes_60m_in_Pips_ | Lanes_240mMA | Lanes_240mBand | Clear_Lanes_240m_in_Pips_ | Clear_Lane_1 | Clear_Lanes_2 | Clear_Lanes_3 | Clear_Lanes_4 | WZ_1m_Entry_1Clck | WZ_5m_Entry_1Clck | WZ_15m_Entry_1Clck | WZ_60m_Entry_1Clck | WZ_240m_Entry_1Clck | _10_10_New_SL | _10_10_New_TP | _10_10_Time_Hit_SL | _10_10_Time_Hit_TP | _10_10_PL | _10_20_New_SL | _10_20_New_TP | _10_20_Time_Hit_SL | _10_20_Time_Hit_TP | _10_20_PL | _10_30_New_SL | _10_30_New_TP | _10_30_Time_Hit_SL | _10_30_Time_Hit_TP | _10_30_PL | _10_40_New_SL | _10_40_New_TP | _10_40_Time_Hit_SL | _10_40_Time_Hit_TP | _10_40_PL | _10_50_New_SL | _10_50_New_TP | _10_50_Time_Hit_SL | _10_50_Time_Hit_TP | _10_50_PL | _20_10_New_SL | _20_10_New_TP | _20_10_Time_Hit_SL | _20_10_Time_Hit_TP | _20_10_PL | _20_20_New_SL | _20_20_New_TP | _20_20_Time_Hit_SL | _20_20_Time_Hit_TP | _20_20_PL | _20_30_New_SL | _20_30_New_TP | _20_30_Time_Hit_SL | _20_30_Time_Hit_TP | _20_30_PL | _20_40_New_SL | _20_40_New_TP | _20_40_Time_Hit_SL | _20_40_Time_Hit_TP | _20_40_PL | _20_50_New_SL | _20_50_New_TP | _20_50_Time_Hit_SL | _20_50_Time_Hit_TP | _20_50_PL | _1m_Play_Def_Cross_Date | _1m_Play_Def_Exit_Date | _1m_Play_Def_Exit_Price | TrdProt_Trigger_Price | Time_TrdProt_Triggered | TrdProt_Amount | TrdProt_Time_hit | _5m_Play_Def_Cross_Date | _5m_Play_Def_Exit_Date | _5m_Play_Def_Exit_Price | _15m_Play_Def_Cross_Date | _15m_Play_Def_Exit_Date | _15m_Play_Def_Exit_Price | _60m_Play_Def_Cross_Date | _60m_Play_Def_Exit_Date | _60m_Play_Def_Exit_Price | _1m_L1_Price | _1m_L1_Time | _1m_L2_Price | _1m_L2_Time | _1m_L3_Price | _1m_L3_Time | _1m_L4_Price | _1m_L4_Time | _1m_L5_Price | _1m_L5_Time | _1m_L7_Price | _1m_L7_Time | _1m_WZ_Price | _1m_WZ_Time | _5m_L1_Price | _5m_L1_Time | _5m_L2_Price | _5m_L2_Time | _5m_L3_Price | _5m_L3_Time | _5m_L4_Price | _5m_L4_Time | _5m_L5_Price | _5m_L5_Time | _5m_L7_Price | _5m_L7_Time | _5m_WZ_Price | _5m_WZ_Time | _15m_L1_Price | _15m_L1_Time | _15m_L2_Price | _15m_L2_Time | _15m_L3_Price | _15m_L3_Time | _15m_L4_Price | _15m_L4_Time | _15m_L5_Price | _15m_L5_Time | _15m_L7_Price | _15m_L7_Time | _15m_WZ_Price | _15m_WZ_Time | _60m_L1_Price | _60m_L1_Time | _60m_L2_Price | _60m_L2_Time | _60m_L7_Price | _60m_L7_Time | _60m_WZ_Price | _60m_WZ_Time | _240m_L1_Price | _240m_L1_Time | _240m_L2_Price | _240m_L2_Time | _1m_Box_TP_Price | _1m_Box_TP_Time | _1m_L1_TP_Price | _1m_L1_TP_Time | _1m_L3_TP_Price | _1m_L3_TP_Time | _1m_L4_TP_Price | _1m_L4_TP_Time | _1m_L5_TP_Price | _1m_L5_TP_Time | _1m_L7_TP_Price | _1m_L7_TP_Time | _1m_WZ_TP_Price | _1m_WZ_TP_Time | _5m_Box_TP_Price | _5m_Box_TP_Time | _5m_L1_TP_Price | _5m_L1_TP_Time | _5m_L7_TP_Price | _5m_L7_TP_Time | _5m_WZ_TP_Price | _5m_WZ_TP_Time | _5m_WZ_Other_TP_Price | _5m_WZ_Other_TP_Time | _5m_B1_TP_Price | _5m_B1_TP_Time | _5m_B2_TP_Price | _5m_B2_TP_Time | _15m_Box_TP_Price | _15m_Box_TP_Time | _15m_L1_TP_Price | _15m_L1_TP_Time | _15m_L7_TP_Price | _15m_L7_TP_Time | _15m_WZ_TP_Price | _15m_WZ_TP_Time | _15m_WZ_Other_TP_Price | _15m_WZ_Other_TP_Time | _15m_B1_TP_Price | _15m_B1_TP_Time | _15m_B2_TP_Price | _15m_B2_TP_Time | _60m_Box_TP_Price | _60m_Box_TP_Time | _1m_Swing_Stop_Price | _1m_Swing_Stop_Time | Dyn_Fixed_SL | Time_Hit_Fixed_SL | Dyn_Fixed_TP | Time_Hit_Fixed_TP | RR_Exit_Price | RR_Exit_Time | Dynamic_TP_1_lane_Time | Dynamic_TP_1_lane_Price | Dynamic_TP_2_lane_Time | Dynamic_TP_2_lane_Price | Dynamic_TP_3_lane_Time | Dynamic_TP_3_lane_Price | Dynamic_TP_4_lane_Time | Dynamic_TP_4_lane_Price | Dynamic_SL_1_lane_Time | Dynamic_SL_1_lane_Price | Dynamic_SL_2_lane_Time | Dynamic_SL_2_lane_Price | Dynamic_SL_3_lane_Time | Dynamic_SL_3_lane_Price | Dynamic_SL_4_lane_Time | Dynamic_SL_4_lane_Price | _5m_Swing_Stop_Price | _5m_Swing_Stop_Time | _15m_Swing_Stop_Price | _15m_Swing_Stop_Time | _60m_Swing_Stop_Price | _60m_Swing_Stop_Time
Set 1 | 78432159 | 2021-06-17 17:00:00 | 17 |  | 2021-06-18 08:13:00 | AUDCAD | Sell | 1 | 0.93506 | 0.92696 | 0.93206 | 0.93004 | -7 | -2.26 | 20.2 | 153.94 | 0.05 | BreakoutTrade | 11152 | 00:15:12:57 | 19 | True | 2021-06-18 18:30:00
Set 1 | 78439410 | 2021-06-17 17:50:00 | 17 |  | 2021-06-18 15:15:00 | AUDCAD | Sell | 1 | 0.94263 | 0.92263 | 0.93264 | 0.92961 | -7 | -2.26 | 30.3 | 235.6 | 0.08 | 5mTrend | 11118 | 00:21:25:00 | 15 | True | 2021-06-18 18:30:00
Set 2 | 78443383 | 2021-06-17 18:11:00 | 18 |  | 2021-06-18 15:19:00 | AUDCAD | Sell | 1 | 0.94239 | 0.92239 | 0.9324 | 0.92937 | -7 | -2.26 | 30.3 | 235.64 | 0.04 | 5mTrend | 11118 | 00:21:08:23 | 18 | True | 2021-06-18 18:30:00