Spreadsheet: 685410d1593976011-5-minute-ohlc-data-and-question-grdnryn
Sheet: Sheet1

 |  | open | high | low | close | InsideHL | Expected result
2019-01-02 00:00:00 | 09:30:00.0 | 2430 | 2435.5 | 2429 | 2432.5
2019-01-02 00:00:00 | 09:35:00.0 | 2432.5 | 2437 | 2429 | 2435
2019-01-02 00:00:00 | 09:40:00.0 | 2435 | 2439 | 2430.75 | 2438.75
2019-01-02 00:00:00 | 09:45:00.0 | 2438.75 | 2443 | 2438.25 | 2440.75
2019-01-02 00:00:00 | 09:50:00.0 | 2441 | 2443.75 | 2436.75 | 2438.75
2019-01-02 00:00:00 | 09:55:00.0 | 2439 | 2442.25 | 2438 | 2441.5
2019-01-02 00:00:00 | 10:00:00.0 | 2441.5 | 2442 | 2435.75 | 2441.75
2019-01-02 00:00:00 | 10:05:00.0 | 2441.75 | 2454.5 | 2441.25 | 2453
2019-01-02 00:00:00 | 10:10:00.0 | 2453.25 | 2455.75 | 2451.75 | 2453.5
2019-01-02 00:00:00 | 10:15:00.0 | 2453.75 | 2455.5 | 2449.75 | 2451
2019-01-02 00:00:00 | 10:20:00.0 | 2451 | 2453.5 | 2449 | 2452
2019-01-02 00:00:00 | 10:25:00.0 | 2451.75 | 2456.75 | 2447.25 | 2448
2019-01-02 00:00:00 | 10:30:00.0 | 2448 | 2449.5 | 2443.75 | 2444.25
2019-01-02 00:00:00 | 10:35:00.0 | 2444.25 | 2448.25 | 2443.75 | 2447
2019-01-02 00:00:00 | 10:40:00.0 | 2447.25 | 2456 | 2447.25 | 2455.25
2019-01-02 00:00:00 | 10:45:00.0 | 2455.25 | 2457.5 | 2452.25 | 2453
2019-01-02 00:00:00 | 10:50:00.0 | 2453 | 2460.75 | 2451 | 2459.25
2019-01-02 00:00:00 | 10:55:00.0 | 2459.25 | 2461.5 | 2457.25 | 2458.5
2019-01-02 00:00:00 | 11:00:00.0 | 2458.5 | 2461 | 2455.75 | 2460.5
2019-01-02 00:00:00 | 11:05:00.0 | 2460.5 | 2465.75 | 2460.5 | 2464.5
2019-01-02 00:00:00 | 11:10:00.0 | 2464.75 | 2468.75 | 2463.5 | 2468.5
2019-01-02 00:00:00 | 11:15:00.0 | 2468.5 | 2473.25 | 2466 | 2472.75
2019-01-02 00:00:00 | 11:20:00.0 | 2472.75 | 2474.75 | 2468.75 | 2471.25
2019-01-02 00:00:00 | 11:25:00.0 | 2471.5 | 2473 | 2463.75 | 2465
2019-01-02 00:00:00 | 11:30:00.0 | 2465.25 | 2466.75 | 2462.25 | 2466.5
2019-01-02 00:00:00 | 11:35:00.0 | 2466.5 | 2467.5 | 2460.5 | 2462.25
2019-01-02 00:00:00 | 11:40:00.0 | 2462 | 2470.25 | 2461.75 | 2469.25
2019-01-02 00:00:00 | 11:45:00.0 | 2469.25 | 2470.75 | 2466 | 2469.5
2019-01-02 00:00:00 | 11:50:00.0 | 2469.5 | 2470 | 2461.25 | 2461.75
2019-01-02 00:00:00 | 11:55:00.0 | 2461.5 | 2465.75 | 2458.25 | 2458.75
2019-01-02 00:00:00 | 12:00:00.0 | 2459 | 2461.5 | 2457 | 2458.5
2019-01-02 00:00:00 | 12:05:00.0 | 2458.75 | 2463.5 | 2456.5 | 2459.75
2019-01-02 00:00:00 | 12:10:00.0 | 2460 | 2461.25 | 2458.5 | 2461
2019-01-02 00:00:00 | 12:15:00.0 | 2461 | 2461.5 | 2459 | 2460
2019-01-02 00:00:00 | 12:20:00.0 | 2459.75 | 2460.25 | 2457.25 | 2458.25
2019-01-02 00:00:00 | 12:25:00.0 | 2458.5 | 2460.75 | 2458 | 2460
2019-01-02 00:00:00 | 12:30:00.0 | 2459.75 | 2461.5 | 2459 | 2460.75
2019-01-02 00:00:00 | 12:35:00.0 | 2460.75 | 2469 | 2460.5 | 2468.75
2019-01-02 00:00:00 | 12:40:00.0 | 2468.75 | 2469.5 | 2466.75 | 2468.5
2019-01-02 00:00:00 | 12:45:00.0 | 2468.5 | 2471.5 | 2467.25 | 2468.25
2019-01-02 00:00:00 | 12:50:00.0 | 2468.25 | 2470.25 | 2468 | 2468.5
2019-01-02 00:00:00 | 12:55:00.0 | 2468.75 | 2473.5 | 2467.5 | 2471.75
2019-01-02 00:00:00 | 13:00:00.0 | 2471.5 | 2474.5 | 2471.5 | 2473.75
2019-01-02 00:00:00 | 13:05:00.0 | 2474 | 2479.25 | 2474 | 2478.25
2019-01-02 00:00:00 | 13:10:00.0 | 2478.25 | 2478.75 | 2474.25 | 2476
2019-01-02 00:00:00 | 13:15:00.0 | 2476.25 | 2477.25 | 2474 | 2477.25
2019-01-02 00:00:00 | 13:20:00.0 | 2477.25 | 2479 | 2475.75 | 2478.25
2019-01-02 00:00:00 | 13:25:00.0 | 2478.25 | 2480.75 | 2475.75 | 2478.25
2019-01-02 00:00:00 | 13:30:00.0 | 2478.25 | 2481.25 | 2478 | 2480
2019-01-02 00:00:00 | 13:35:00.0 | 2480 | 2480.25 | 2474.75 | 2476.5
2019-01-02 00:00:00 | 13:40:00.0 | 2476.75 | 2477.5 | 2474.75 | 2476.5
2019-01-02 00:00:00 | 13:45:00.0 | 2476.75 | 2480.25 | 2476.25 | 2478.25
2019-01-02 00:00:00 | 13:50:00.0 | 2478.5 | 2479.5 | 2477 | 2477.5
2019-01-02 00:00:00 | 13:55:00.0 | 2477.5 | 2482.5 | 2477 | 2481.75
2019-01-02 00:00:00 | 14:00:00.0 | 2482 | 2482 | 2475.25 | 2478.75
2019-01-02 00:00:00 | 14:05:00.0 | 2478.75 | 2479 | 2470.5 | 2472
2019-01-02 00:00:00 | 14:10:00.0 | 2472 | 2472.75 | 2467.25 | 2469.5
2019-01-02 00:00:00 | 14:15:00.0 | 2469.25 | 2473 | 2468 | 2471.25
2019-01-02 00:00:00 | 14:20:00.0 | 2471.25 | 2476 | 2470.25 | 2474.5
2019-01-02 00:00:00 | 14:25:00.0 | 2474.5 | 2476 | 2472 | 2472.75
2019-01-02 00:00:00 | 14:30:00.0 | 2472.75 | 2479.25 | 2472 | 2477
2019-01-02 00:00:00 | 14:35:00.0 | 2477 | 2478 | 2475 | 2476.25
2019-01-02 00:00:00 | 14:40:00.0 | 2476.25 | 2476.75 | 2469.75 | 2472.75
2019-01-02 00:00:00 | 14:45:00.0 | 2472.75 | 2476.75 | 2472 | 2476.25
2019-01-02 00:00:00 | 14:50:00.0 | 2476.5 | 2476.5 | 2472.25 | 2472.5
2019-01-02 00:00:00 | 14:55:00.0 | 2472.5 | 2473.5 | 2468.5 | 2468.5
2019-01-02 00:00:00 | 15:00:00.0 | 2468.5 | 2472.5 | 2466 | 2467
2019-01-02 00:00:00 | 15:05:00.0 | 2467 | 2467.25 | 2462.75 | 2463.75
2019-01-02 00:00:00 | 15:10:00.0 | 2464 | 2467 | 2460 | 2466
2019-01-02 00:00:00 | 15:15:00.0 | 2466 | 2467 | 2458.25 | 2460.75
2019-01-02 00:00:00 | 15:20:00.0 | 2460.75 | 2465.75 | 2459 | 2465
2019-01-02 00:00:00 | 15:25:00.0 | 2465.25 | 2468.25 | 2460.75 | 2463
2019-01-02 00:00:00 | 15:30:00.0 | 2463 | 2463.25 | 2458 | 2459
2019-01-02 00:00:00 | 15:35:00.0 | 2459 | 2464 | 2457.75 | 2458.25
2019-01-02 00:00:00 | 15:40:00.0 | 2458 | 2462.5 | 2457.25 | 2458
2019-01-02 00:00:00 | 15:45:00.0 | 2458.25 | 2464.75 | 2458 | 2461.75
2019-01-02 00:00:00 | 15:50:00.0 | 2461.75 | 2467.5 | 2461.5 | 2465.5
2019-01-02 00:00:00 | 15:55:00.0 | 2465.25 | 2475.25 | 2465.25 | 2473
2019-01-02 00:00:00 | 16:00:00.0 | 2472.75 | 2474.25 | 2472 | 2472.75
2019-01-02 00:00:00 | 16:05:00.0 | 2472.75 | 2474 | 2472 | 2472.25
2019-01-02 00:00:00 | 16:10:00.0 | 2472.5 | 2473.75 | 2472 | 2473
2019-01-03 00:00:00 | 09:30:00.0 | 2452.5 | 2455.5 | 2448.75 | 2450.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 |  | Not of interest
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 |  | Not of interest
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 |  | Not of interest
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 |  | Not of interest
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 |  | Not of interest
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 |  | Not of interest
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 |  | Not of interest
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