Spreadsheet: 685421d1593984820-5-minute-ohlc-data-and-question-grdnryn_reva
Sheet: Sheet1

 |  | open | high | low | close | InsideHL | Expected result
2019-01-03 00:00:00 | 09:30:00.0 | 2430 | 2435.5 | 2429 | 2432.5
2019-01-03 00:00:00 | 09:35:00.0 | 2450.25 | 2450.5 | 2443 | 2443.75
2019-01-03 00:00:00 | 09:40:00.0 | 2443.5 | 2450.25 | 2442.25 | 2447.5
2019-01-03 00:00:00 | 09:45:00.0 | 2447.5 | 2447.5 | 2439.75 | 2440.25
2019-01-03 00:00:00 | 09:50:00.0 | 2440.25 | 2441.75 | 2437.25 | 2440.5
2019-01-03 00:00:00 | 09:55:00.0 | 2440.75 | 2443.75 | 2439 | 2441.75
2019-01-03 00:00:00 | 10:00:00.0 | 2441.5 | 2441.5 | 2429.25 | 2430.75
2019-01-03 00:00:00 | 10:05:00.0 | 2430.5 | 2432 | 2425.5 | 2426 |  | DOWN
2019-01-03 00:00:00 | 10:10:00.0 | 2425.75 | 2427 | 2419.75 | 2420.5
2019-01-03 00:00:00 | 10:15:00.0 | 2420.5 | 2424.5 | 2416.75 | 2424
2019-01-03 00:00:00 | 10:20:00.0 | 2424.25 | 2428.75 | 2421 | 2426.75
2019-01-03 00:00:00 | 10:25:00.0 | 2426.5 | 2428.5 | 2424.25 | 2425.75
2019-01-03 00:00:00 | 10:30:00.0 | 2425.75 | 2425.75 | 2418.25 | 2420.25
2019-01-03 00:00:00 | 10:35:00.0 | 2420.5 | 2420.5 | 2410.75 | 2414.25
2019-01-03 00:00:00 | 10:40:00.0 | 2414.5 | 2417.25 | 2409.25 | 2411.75
2019-01-03 00:00:00 | 10:45:00.0 | 2411.75 | 2418.75 | 2411 | 2413
2019-01-03 00:00:00 | 10:50:00.0 | 2413 | 2419.5 | 2411 | 2416
2019-01-03 00:00:00 | 10:55:00.0 | 2416.25 | 2423 | 2416 | 2422.75
2019-01-03 00:00:00 | 11:00:00.0 | 2422.5 | 2425.75 | 2420.5 | 2425
2019-01-03 00:00:00 | 11:05:00.0 | 2425.25 | 2425.25 | 2419.25 | 2420.25
2019-01-03 00:00:00 | 11:10:00.0 | 2420.5 | 2431 | 2420.25 | 2428.75
2019-01-03 00:00:00 | 11:15:00.0 | 2429 | 2431.75 | 2427.75 | 2429
2019-01-03 00:00:00 | 11:20:00.0 | 2429 | 2434.75 | 2428.25 | 2431
2019-01-03 00:00:00 | 11:25:00.0 | 2431 | 2432 | 2425.5 | 2426 |  | Trend fails to continue
2019-01-03 00:00:00 | 11:30:00.0 | 2426.25 | 2429.75 | 2423.25 | 2426.25
2019-01-03 00:00:00 | 11:35:00.0 | 2426.25 | 2442.75 | 2426.25 | 2441 |  | UP
2019-01-03 00:00:00 | 11:40:00.0 | 2441.25 | 2451 | 2441.25 | 2447
2019-01-03 00:00:00 | 11:45:00.0 | 2447 | 2449.25 | 2444.25 | 2446
2019-01-03 00:00:00 | 11:50:00.0 | 2446 | 2449.75 | 2440.5 | 2441.5
2019-01-03 00:00:00 | 11:55:00.0 | 2441.75 | 2444.75 | 2438.5 | 2440.25
2019-01-03 00:00:00 | 12:00:00.0 | 2440.5 | 2442.75 | 2434.75 | 2436.5
2019-01-03 00:00:00 | 12:05:00.0 | 2436.75 | 2436.75 | 2433 | 2434.75
2019-01-03 00:00:00 | 12:10:00.0 | 2434.75 | 2442 | 2434 | 2439.5 |  | Trend fails to continue
2019-01-03 00:00:00 | 12:15:00.0 | 2439.5 | 2442.25 | 2432.5 | 2435.25
2019-01-03 00:00:00 | 12:20:00.0 | 2435 | 2439.75 | 2434.25 | 2438.25 |  | Trend fails to continue
2019-01-03 00:00:00 | 12:25:00.0 | 2438.25 | 2438.75 | 2432.5 | 2435.25
2019-01-03 00:00:00 | 12:30:00.0 | 2435.25 | 2440.75 | 2434.25 | 2439.5 |  | Trend fails to continue
2019-01-03 00:00:00 | 12:35:00.0 | 2439.25 | 2439.5 | 2429.5 | 2432.5
2019-01-03 00:00:00 | 12:40:00.0 | 2432.5 | 2435.5 | 2430.5 | 2433
2019-01-03 00:00:00 | 12:45:00.0 | 2432.75 | 2438.75 | 2432.5 | 2436.25 |  | Trend fails to continue
2019-01-03 00:00:00 | 12:50:00.0 | 2436 | 2441.25 | 2434.75 | 2440.25
2019-01-03 00:00:00 | 12:55:00.0 | 2440.25 | 2442 | 2437 | 2439.5
2019-01-03 00:00:00 | 13:00:00.0 | 2439.25 | 2439.5 | 2431.5 | 2433.25
2019-01-03 00:00:00 | 13:05:00.0 | 2433 | 2434.75 | 2429.25 | 2430.5
2019-01-03 00:00:00 | 13:10:00.0 | 2430.5 | 2433.5 | 2427.75 | 2432
2019-01-03 00:00:00 | 13:15:00.0 | 2431.75 | 2432 | 2416.5 | 2419.75 |  | DOWN
2019-01-03 00:00:00 | 13:20:00.0 | 2419.75 | 2426.25 | 2419 | 2424.5
2019-01-03 00:00:00 | 13:25:00.0 | 2424.25 | 2427.25 | 2422.25 | 2426
2019-01-03 00:00:00 | 13:30:00.0 | 2426.25 | 2427.25 | 2423 | 2423.75
2019-01-03 00:00:00 | 13:35:00.0 | 2423.75 | 2430.25 | 2421 | 2429.75
2019-01-03 00:00:00 | 13:40:00.0 | 2429.75 | 2433.25 | 2428 | 2431
2019-01-03 00:00:00 | 13:45:00.0 | 2431.25 | 2431.75 | 2425.75 | 2427 |  | Trend fails to continue
2019-01-03 00:00:00 | 13:50:00.0 | 2427 | 2427.25 | 2420.5 | 2420.75
2019-01-03 00:00:00 | 13:55:00.0 | 2420.75 | 2422.25 | 2418 | 2421
2019-01-03 00:00:00 | 14:00:00.0 | 2420.75 | 2423.25 | 2418.75 | 2419.75
2019-01-03 00:00:00 | 14:05:00.0 | 2419.5 | 2425.75 | 2419.25 | 2424.5
2019-01-03 00:00:00 | 14:10:00.0 | 2424.25 | 2427.25 | 2422.75 | 2423.5
2019-01-03 00:00:00 | 14:15:00.0 | 2423.25 | 2428 | 2420.5 | 2426.75
2019-01-03 00:00:00 | 14:20:00.0 | 2426.75 | 2428 | 2424.25 | 2426
2019-01-03 00:00:00 | 14:25:00.0 | 2426 | 2432.5 | 2423.25 | 2431.75
2019-01-03 00:00:00 | 14:30:00.0 | 2431.75 | 2435.75 | 2428 | 2430.5
2019-01-03 00:00:00 | 14:35:00.0 | 2430.75 | 2431.75 | 2425 | 2428.25 |  | Trend fails to continue
2019-01-03 00:00:00 | 14:40:00.0 | 2428.25 | 2430.5 | 2424.25 | 2424.5
2019-01-03 00:00:00 | 14:45:00.0 | 2424.5 | 2425.75 | 2419.5 | 2421.25
2019-01-03 00:00:00 | 14:50:00.0 | 2421.25 | 2423 | 2419.25 | 2420.75
2019-01-03 00:00:00 | 14:55:00.0 | 2420.75 | 2420.75 | 2414 | 2417.75
2019-01-03 00:00:00 | 15:00:00.0 | 2418 | 2419.75 | 2415.5 | 2416
2019-01-03 00:00:00 | 15:05:00.0 | 2416.25 | 2418.75 | 2414.25 | 2416
2019-01-03 00:00:00 | 15:10:00.0 | 2415.75 | 2417 | 2411.25 | 2411.25
2019-01-03 00:00:00 | 15:15:00.0 | 2411.25 | 2418.25 | 2410.5 | 2416.5
2019-01-03 00:00:00 | 15:20:00.0 | 2416.5 | 2419.25 | 2412.75 | 2413.25
2019-01-03 00:00:00 | 15:25:00.0 | 2413.25 | 2418.75 | 2412.25 | 2415
2019-01-03 00:00:00 | 15:30:00.0 | 2415 | 2423.25 | 2413 | 2420.25
2019-01-03 00:00:00 | 15:35:00.0 | 2420.5 | 2422.5 | 2413.25 | 2413.75
2019-01-03 00:00:00 | 15:40:00.0 | 2413.75 | 2417 | 2411.75 | 2414.25
2019-01-03 00:00:00 | 15:45:00.0 | 2414.5 | 2418.5 | 2414.5 | 2414.75
2019-01-03 00:00:00 | 15:50:00.0 | 2414.75 | 2417.75 | 2411.5 | 2413.75
2019-01-03 00:00:00 | 15:55:00.0 | 2414 | 2415.5 | 2405.25 | 2410.25
2019-01-03 00:00:00 | 16:00:00.0 | 2410.25 | 2417 | 2408.5 | 2410.75
2019-01-03 00:00:00 | 16:05:00.0 | 2410.5 | 2413.75 | 2410.25 | 2412.5
2019-01-03 00:00:00 | 16:10:00.0 | 2412.25 | 2412.75 | 2408.5 | 2410.25
 |  |  |  |  |  | UP
 |  |  |  |  |  | DOWN
 |  |  |  |  |  | Trend fails to continue