Spreadsheet: 730775d1619921036-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy-ans
Sheet: DATA

TICKER | DATE | ENTRY TIME | ENTRY $ | HIGH $ | EXIT $ | GAIN / LOSS $ | ENTRY REASON | EXIT REASON
ADMA | 2021-04-28 00:00:00 | 09:24:00 | 2.29 | 2.63 | 2.5 |  | PM CONSOLIDATION | 5X20 | 10:30:00 | 11:30:00 |  | cell formatted for [h]:mm
UXIN | 2021-04-28 00:00:00 | 09:30:00 | 1.9 | 2.76 | 2.55 |  | PM CONSOLIDATION | 5X20
CLOV | 2021-04-29 00:00:00 | 09:32:00 | 11.5 | 11.77 | 11.44 |  | PMH | FBO
GRTX | 2021-04-29 00:00:00 | 09:30:00 | 9.78 | 10.1 | 9.51 |  | PM CONSOLIDATION | FBO
METX | 2021-04-29 00:00:00 | 09:46:00 | 1.92 | 2.43 | 2.24 |  | PMH | 5X20
MVIS | 2021-04-28 00:00:00 | 08:30:00 | 20.25 | 25.75 | 21.75 |  | PM CONSOLIDATION | 5X20
MVIS | 2021-04-28 00:00:00 | 10:10:00 | 22.53 | 25.75 | 24.24 |  | R2G | 5X20
BOXL | 2021-04-28 00:00:00 | 09:36:00 | 2.69 | 3.03 | 2.78 |  | PM CONSOLIDATION | 5X20
BOXL | 2021-04-28 00:00:00 | 12:28:00 | 2.85 | 3.03 | 2.93 |  | R2G | 5X20
[NAME] | 2021-04-27 00:00:00 | 09:32:00 | 13.91 | 22.5 | 15.86 |  | PM CONSOLIDATION | 5X20
[NAME] | 2021-04-27 00:00:00 | 12:20:00 | 17.32 | 22.5 | 20.4 |  | R2G | 5X20
NSPR | 2021-04-27 00:00:00 | 09:30:00 | 6.18 | 7.4 | 6.06 |  | PM CONSOLIDATION | FBO
NSPR | 2021-04-27 00:00:00 | 09:44:00 | 6.18 | 7.4 | 6.67 |  | PM CONSOLIDATION | 5X20
[NAME] | 2021-04-27 00:00:00 | 09:34:00 | 4.78 | 6.12 | 5.43 |  | R2G | 5X20
[NAME] | 2021-04-27 00:00:00 | 09:36:00 | 13.69 | 15.95 | 13.45 |  | MOMO | FBO
[NAME] | 2021-04-27 00:00:00 | 09:48:00 | 13.72 | 15.95 | 13.67 |  | MOMO | FBO
[NAME] | 2021-04-27 00:00:00 | 12:24:00 | 14.31 | 15.95 | 14.55 |  | R2G | 5X20
[NAME] | 2021-04-27 00:00:00 | 14:08:00 | 15.07 | 15.95 | 15.39 |  | R2G | 5X20
BNGO | 2021-04-20 00:00:00 | 09:34:00 | 5.31 | 6.08 | 5.71 |  | PMH | 5X20
BNGO | 2021-04-26 00:00:00 | 09:30:00 | 6.4 | 7.65 | 6.34 |  | PM CONSOLIDATION | FBO
BNGO | 2021-04-26 00:00:00 | 10:58:00 | 6.53 | 7.65 | 7.15 |  | CONSOLIDATION | 5X20
CSPR | 2021-04-26 00:00:00 | 09:34:00 | 7.9 | 9.3 | 8.66 |  | PM CONSOLIDATION | 5X20
CSPR | 2021-04-26 00:00:00 | 11:42:00 | 8.45 | 9.3 | 8.74 |  | R2G | 5X20
LAZR | 2021-04-26 00:00:00 | 09:38:00 | 24.2 | 26.45 | 24.52 |  | PM CONSOLIDATION | 5X20
LAZR | 2021-04-26 00:00:00 | 11:12:00 | 24.99 | 26.45 | 25.67 |  | R2G | 5X20
MVIS | 2021-04-26 00:00:00 | 09:32:00 | 20.34 | 23.39 | 21.63 |  | PM CONSOLIDATION | 5X20
NNDM | 2021-04-20 00:00:00 | 09:12:00 | 6.79 | 7.79 | 7.46 |  | PM CONSOLIDATION | 5X20
PLTR | 2021-04-20 00:00:00 | 09:28:00 | 21.86 | 22.55 | 22.15 |  | PM CONSOLIDATION | 5X20
WBT | 2021-04-21 00:00:00 | 09:30:00 | 19.18 | 22 | 21.32 |  | PM CONSOLIDATION | 5X20
BNGO | 2021-04-22 00:00:00 | 09:30:00 | 6.71 | 6.96 | 6.67 |  | PMH | FBO
MVIS | 2021-04-22 00:00:00 | 08:52:00 | 13.5 | 14.9 | 13.78 |  | PM CONSOLIDATION | 5X20
MVIS | 2021-04-22 00:00:00 | 09:40:00 | 14.43 | 14.9 | 14.39 |  | PMH | FBO
CVM | 2021-04-22 00:00:00 | 09:38:00 | 21 | 27.84 | 25.86 |  | PM CONSOLIDATION | 5X20
SNAP | 2021-04-23 00:00:00 | 09:20:00 | 60.81 | 63.2 | 60.69 |  | PMH | FBO
SKX | 2021-04-23 00:00:00 | 09:26:00 | 49.76 | 53.14 | 50.1 |  | PM CONSOLIDATION | 5X20
MVIS | 2021-04-23 00:00:00 | 09:36:00 | 14.36 | 19.14 | 18.19 |  | PM CONSOLIDATION | 5X20
SYPR | 2021-04-23 00:00:00 | 11:16:00 | 3.86 | 5.82 | 4.78 |  | CONSOLIDATION | 5X20
INO | 2021-04-15 00:00:00 | 08:24:00 | 9.9 | 10.82 | 10.15 |  | PMH | 5X20
WHLM | 2021-04-15 00:00:00 | 09:52:00 | 8.98 | 14.21 | 11.59 |  | CONSOLIDATION | 5X20
TV | 2021-04-14 00:00:00 | 09:42:00 | 12.6 | 13.85 | 12.82 |  | R2G | 5X20
VTVT | 2021-04-13 00:00:00 | 09:46:00 | 3.03 | 3.58 | 3.32 |  | PM CONSOLIDATION | 5X20
WHLM | 2021-04-12 00:00:00 | 09:06:00 | 9.02 | 9.16 | 8.94 |  | BO | FBO
WHLM | 2021-04-12 00:00:00 | 09:32:00 | 9.02 | 10.45 | 9 |  | BO | FBO
RMO | 2021-04-12 00:00:00 | 12:28:00 | 9.59 | 10.23 | 9.86 |  | BO | 5X20
FBIO | 2021-04-09 00:00:00 | 09:34:00 | 5.3 | 5.78 | 5.36 |  | BO | 5X20
PRVB | 2021-04-09 00:00:00 | 09:30:00 | 6.58 | 8.44 | 7.98 |  | PMH | 5X20
[NAME] | 2021-04-08 00:00:00 | 08:22:00 | 11.5 | 15.45 | 13.69 |  | PMH | 5X20
SJ | 2021-04-06 00:00:00 | 10:30:00 | 14.88 | 18.5 | 16.23 |  | CONSOLIDATION | 5X20
SJ | 2021-04-06 00:00:00 | 09:30:00 | 14.88 | 15.51 | 14.8 |  | BO | FBO
RMO | 2021-04-06 00:00:00 | 08:02:00 | 8.8 | 9.18 | 8.86 |  | PMH | 5X20
RMO | 2021-04-06 00:00:00 | 10:04:00 | 9.18 | 13.64 | 12.76 |  | PMH | 5X20
UPC | 2021-04-01 00:00:00 | 08:20:00 | 4.95 | 5.88 | 5.15 |  | PMH | 5X20
UPC | 2021-04-01 00:00:00 | 09:34:00 | 5.89 | 7.22 | 6 |  | PMH | 5X20
JFIN | 2021-03-30 00:00:00 | 09:54:00 | 8.05 | 10.24 | 9.02 |  | CONSOLIDATION | 5X20
PFMT | 2021-03-30 00:00:00 | 09:30:00 | 1.86 | 2.42 | 2.15 |  | PM CONSOLIDATION | 5X20
YVR | 2021-03-23 00:00:00 | 09:32:00 | 5.9 | 7.5 | 6.38 |  | PMH | 5X20
AMC | 2021-03-25 00:00:00 | 09:32:00 | 9.7 | 9.74 | 9.65 |  | PMH | 5X20
AMC | 2021-03-25 00:00:00 | 10:02:00 | 9.7 | 11.23 | 10.65 |  | PMH | 5X20
KOSS | 2021-03-25 00:00:00 | 10:24:00 | 19.06 | 26 | 22.89 |  | PMH | 5X20
CLEU | 2021-03-26 00:00:00 | 09:30:00 | 4.59 | 7.58 | 5.41 |  | PM CONSOLIDATION | 5X20
[NAME] | 2021-03-24 00:00:00 | 09:30:00 | 5.45 | 7.2 | 6.39 |  | BO | 5X20
JFIN | 2021-03-22 00:00:00 | 10:04:00 | 7.92 | 12.75 | 11.32 |  | PM CONSOLIDATION | 5X20
TKAT | 2021-03-17 00:00:00 | 11:14:00 | 6.06 | 24.92 | 19.45 |  | PM CONSOLIDATION | 5X20
CLVS | 2021-03-19 00:00:00 | 09:30:00 | 6.4 | 8.95 | 8.08 |  | PM CONSOLIDATION | 5X20
SLGG | 2021-03-19 00:00:00 | 09:36:00 | 8.8 | 9.42 | 8.68 |  | PM CONSOLIDATION | FBO
SLGG | 2021-03-19 00:00:00 | 10:25:00 | 9.46 | 11.12 | 10.31 |  | PMH | 5X20
SOS | 2021-03-18 00:00:00 | 10:46:00 | 7.9 | 8.86 | 8.41 |  | BO | 5X20
JFIN | 2021-03-18 00:00:00 | 09:32:00 | 5.5 | 13.61 | 9.56 |  | PM CONSOLIDATION | 5X20
EXPR | 2021-03-18 00:00:00 | 09:30:00 | 4.86 | 6.34 | 5.63 |  | PM CONSOLIDATION | 5X20
IMTE | 2021-03-17 00:00:00 | 12:02:00 | 5.25 | 9.3 | 7.19 |  | BO | 5X20
OCG | 2021-03-17 00:00:00 | 11:05:00 | 6.18 | 10.85 | 8.84 |  | BO | 5X20
STRM | 2021-03-16 00:00:00 | 10:04:00 | 2.66 | 3.86 | 2.91 |  | BO | 5X20
SVRA | 2021-03-16 00:00:00 | 09:32:00 | 2.33 | 3.58 | 2.53 |  | PM CONSOLIDATION | 5X20
SOS | 2021-03-15 00:00:00 | 08:04:00 | 6.71 | 8.65 | 7.89 |  | PM CONSOLIDATION | 5X20
AMC | 2021-03-15 00:00:00 | 09:32:00 | 12.41 | 14.49 | 13.94 |  | PMH | 5X20
EBON | 2021-03-12 00:00:00 | 09:30:00 | 7.27 | 11.31 | 10.34 |  | PM CONSOLIDATION | 5X20
ENTX | 2021-03-12 00:00:00 | 09:34:00 | 7.25 | 10.16 | 7.17 |  | PMH | FBO
ENTX | 2021-03-11 00:00:00 | 09:38:00 | 5.25 | 5.79 | 5.17 |  | PMH | FBO
ENTX | 2021-03-11 00:00:00 | 10:26:00 | 5.25 | 7.87 | 5.68 |  | PMH | 5X20
OCGN | 2021-03-11 00:00:00 | 09:30:00 | 8.36 | 8.39 | 8.29 |  | PMH | FBO
OCGN | 2021-03-11 00:00:00 | 11:12:00 | 8.36 | 10.65 | 9.69 |  | PMH | 5X20
OGI | 2021-03-11 00:00:00 | 06:00:00 | 3.54 | 4.4 | 3.97 |  | MOMO | 5X20
INVO | 2021-03-09 00:00:00 | 09:30:00 | 5.59 | 12.3 | 9.32 |  | PM CONSOLIDATION | 5X20
XELA | 2021-03-09 00:00:00 | 09:38:00 | 2.41 | 5.5 | 4.51 |  | PM CONSOLIDATION | 5X20
EYES | 2021-03-08 00:00:00 | 06:10:00 | 6 | 14.83 | 10.78 |  | PMH | 5X20
EYES | 2021-03-05 00:00:00 | 10:00:00 | 2.51 | 9.89 | 6.56 |  | PM CONSOLIDATION | 5X20
MGI | 2021-03-09 00:00:00 | 09:30:00 | 6.36 | 6.95 | 6.63 |  | MOMO | 5X20
VCNX | 2021-02-19 00:00:00 | 09:30:00 | 6.33 | 9.56 | 6.9 |  | PMH | 5X20
IMGN | 2021-02-12 00:00:00 | 09:38:00 | 8.85 | 10.88 | 10.25 |  | PMH | 5X20
CAN | 2021-03-01 00:00:00 | 09:40:00 | 17.74 | 21.83 | 21.83 |  | PM CONSOLIDATION | 5X20
BNGO | 2021-02-12 00:00:00 | 10:00:00 | 12 | 14.44 | 13.51 |  | PMH | 5X20
OCGN | 2021-02-12 00:00:00 | 11:15:00 | 9.83 | 13.51 | 11.28 |  | CONSOLIDATION | 5X20
AMTX | 2021-03-02 00:00:00 | 10:05:00 | 14.97 | 15.24 | 14.86 |  | PMH | FBO
AMTX | 2021-03-02 00:00:00 | 10:30:00 | 14.97 | 19.98 | 18.49 |  | PMH | 5X20
APHA | 2021-03-02 00:00:00 | 09:30:00 | 19.3 | 21.21 | 20.15 |  | PM CONSOLIDATION | 5X20
APHA | 2021-02-08 00:00:00 | 09:36:00 | 17.14 | 19.14 | 18.54 | 1.4 | PM CONSOLIDATION | 5X20
FLDM | 2021-02-12 00:00:00 | 09:58:00 | 5.45 | 6.55 | 6.27 |  | BO | 5X20