Spreadsheet: 737449d1624428309-determine-value-from-multiple-column-conditions-low-floats-gap-up-backtesting
Sheet: DATA

 |  |  |  | PRE-MARKET |  |  |  |  | OPEN |  |  |  | DAY |  |  | FUNDAMENTALS
TICKER | DATE | CATALYST | CATALYST TYPE | PDC | PMH | MAX MAX PM GAP % | PM PB % | PM VOL | OPEN | CLOSE | LOD | HOD | MAX % GAIN | % GAIN | VOL | INDUSTRY | M CAP | FLOAT
ATOS | 2021-06-11 00:00:00 | Y | Phase II initiated | 4.07 | 4.5 |  |  | 1450000 | 4.48 | 4.31 | 4.12 | 4.49 |  |  | 13890000 | Biotech | 520750000 | 120770000
GENE | 2021-06-11 00:00:00 | Y | US patent | 4.16 | 5.35 |  |  | 1230000 | 4.76 | 4.53 | 4.23 | 5.15 |  |  | 7900000 | Healthcare Research | 68230000 | 11790000
MBIO | 2021-06-11 00:00:00 | 2 |  | 3.81 | 4.39 |  |  | 564000 | 4 | 3.78 | 3.69 | 4.06 |  |  | 4490000 | Biotech | 302140000 | 71760000
MX | 2021-06-11 00:00:00 | Y | Acquisition (aquirier) | 23.04 | 33 |  |  | 1800000 | 26.9 | 26.84 | 25.5 | 26.9 |  |  | 6689822 | Semiconductors | 1200000000 | 42830000
NOVN | 2021-06-11 00:00:00 | Y | Endpoint met | 9.06 | 15.57 |  |  | 13000000 | 14.36 | 14.8 | 13.6 | 18.68 |  |  | 126000000 | Biotech | 23000000 | 14000000
RCON | 2021-06-11 00:00:00 | Y | 52-week high | 12.76 | 16.09 |  |  | 695000 | 15.74 | 6.22 | 4.62 | 17.5 |  |  | 123430000 | Energy | 124920000 | 3620000
ATOS | 2021-06-14 00:00:00 | 2 |  | 4.31 | 4.45 |  |  | 576000 | 4.41 | 4.62 | 4.35 | 4.84 |  |  | 13750000 | Biotech | 520750000 | 120770000
BTX | 2021-06-14 00:00:00 | Y | Acquisition (aquirier) | 14.32 | 17.33 |  |  | 825000 | 15.65 | 15.22 | 14.95 | 17.45 |  |  | 6940000 | Biotech | 670140000 | 19050000
CLNE | 2021-06-14 00:00:00 | WSB |  | 10.79 | 11.69 |  |  | 1640000 | 11.42 | 11.17 | 10.92 | 12.57 |  |  | 61330000 | Energy | 2270000000 | 145730000
ENOB | 2021-06-14 00:00:00 | Y | Pre-IND approval | 4.43 | 12.4 |  |  | 14940000 | 11.88 | 6.77 | 6.71 | 12.99 |  |  | 105790000 | Biotech | 323000000 | 15690000
NOVN | 2021-06-14 00:00:00 | Y | Anayst price target | 14.68 | 16.92 |  |  | 560000 | 15.4 | 17.32 | 15.05 | 20.74 |  |  | 55910000 | Biotech | 137110000 | 14070000
ORPH | 2021-06-14 00:00:00 | 3 |  | 9.35 | 12.25 |  |  | 5660000 | 11.5 | 11 | 10.35 | 12.75 |  |  | 25060000 | Biotech | 326100000 | 24590000
ALF | 2021-06-15 00:00:00 | Y | Uber PO | 3.4 | 5.2 |  |  | 7920000 | 5.13 | 6.95 | 4.66 | 7 |  |  | 198810000 | Software | 84820000 | 3830000
CLSD | 2021-06-15 00:00:00 | Y | Endpoint met | 3.02 | 5.94 |  |  | 8910000 | 3.99 | 4.17 | 3.61 | 4.79 |  |  | 91000000 | Biotech | 247520000 | 50690000
TRCH | 2021-06-15 00:00:00 | Y | Special dividend | 3.58 | 5.2 |  |  | 10640000 | 4.79 | 5.06 | 4.32 | 6.15 |  |  | 264540000 | Energy | 711930000 | 125940000
UXIN | 2021-06-15 00:00:00 | Y | Financing | 5.18 | 6.6 |  |  | 3890000 | 5.82 | 4.51 | 4.05 | 5.82 |  |  | 37440000 | Communications | 1270000000 | 183830000
APRE | 2021-06-16 00:00:00 | Y | Endpoint met | 4.86 | 7.46 |  |  | 17390000 | 7.31 | 5.38 | 5.35 | 7.8 |  |  | 139710000 | Biotech | 112230000 | 19060000
AUVI | 2021-06-16 00:00:00 | Y | Positive trial results | 9.03 | 13.1 |  |  | 3920000 | 12 | 10.5 | 9.6 | 12.15 |  |  | 15460000 | Internet Retail | 101870000 | 4170000
BCTX | 2021-06-16 00:00:00 | Y | Expanding platform | 6.02 | 7.32 |  |  | 1230000 | 6.65 | 6.55 | 6.33 | 7.58 |  |  | 19730000 | Biotech | 44000000 | 4330000
GOED | 2021-06-16 00:00:00 | Y | Positive prev mo sales | 3.06 | 3.26 |  |  | 1630000 | 3.22 | 3.22 | 3.14 | 3.39 |  |  | 19700000 | Internet Retail | 342090000 | 4910000
ORPH | 2021-06-16 00:00:00 | 4 |  | 10.05 | 10 |  |  | 435370 | 9.86 | 16.18 | 9.86 | 23.9 |  |  | 167810000 | Biotech | 566680000 | 24590000
SPI | 2021-06-16 00:00:00 | Y | Product announcement | 6.57 | 8.85 |  |  | 7220000 | 7.68 | 7.21 | 6.87 | 7.95 |  |  | 17100000 | Green Energy | 183240000 | 16230000
AGEN | 2021-06-17 00:00:00 | Y | FDA lic acceptance | 5 | 5.38 |  |  | 415060 | 5.21 | 5.32 | 2.5 | 5.66 |  |  | 9940000 | Biotech | 1100000000 | 192680000
APOP | 2021-06-17 00:00:00 | Y | Merger | 3.27 | 5.9 |  |  | 11220000 | 3.91 | 4.09 | 3.91 | 6.34 |  |  | 78570000 | Biotech | 12780000 | 3570000
CLSD | 2021-06-17 00:00:00 | Y | Analyst price target | 4.08 | 5.4 |  |  | 5470000 | 4.99 | 4.61 | 4.41 | 6 |  |  | 43030000 | Biotech | 242760000 | 50690000
NNOX | 2021-06-17 00:00:00 | Y | FDA submission | 27.97 | 33.79 |  |  | 676790000 | 30.76 | 30.56 | 29.63 | 33.35 |  |  | 8040000 | Medical Devices | 1400000000 | 34450000
PHAS | 2021-06-17 00:00:00 | Y | Licensing agreement | 3.95 | 4.93 |  |  | 1240000 | 4.1 | 3.98 | 3.86 | 4.24 |  |  | 2290000 | Biotech | 192870000 | 17520000
[NAME] | 2021-06-17 00:00:00 | Y | Contract | 6.4 | 7.85 |  |  | 830770000 | 7.09 | 6.75 | 6.6 | 8.25 |  |  | 12170000 | Financial | 46410000 | 2420000
ANPC | 2021-06-18 00:00:00 | Y | Patent granted | 4.33 | 5.87 |  |  | 7340000 | 5.28 | 4.57 | 4.45 | 5.6 |  |  | 42820000 | Biotech | 54860000 | 2810000
EDSA | 2021-06-18 00:00:00 | Y | Favorable study review | 5.7 | 7.2 |  |  | 766730 | 6.17 | 5.56 | 5.35 | 6.35 |  |  | 2570000 | Biotech | 75240000 | 8900000
AEI | 2021-06-21 00:00:00 | Y | Contract | 4.91 | 8.27 |  |  | 16070000 | 7.39 | 6.1 | 6 | 7.64 |  |  | 92100000 | Real Estate Dev | 54100000 | 74000000
EARS | 2021-06-21 00:00:00 | Y | Positive trial results | 3.32 | 4.3 |  |  | 1100000 | 3.79 | 3.61 | 3.45 | 4.13 |  |  | 15060000 | Biotech | 46210000 | 12200000
MNOV | 2021-06-21 00:00:00 | Y | Positive trial results | 3.75 | 5.97 |  |  | 7380000 | 5.01 | 4.2 | 4.01 | 5.09 |  |  | 22310000 | Biotech | 208660000 | 41960000
TRCH | 2021-06-21 00:00:00 | Y | Business deal update | 6.27 | 10.2 |  |  | 20960000 | 8.9 | 9.9 | 8.07 | 10.88 |  |  | 389430000 | Energy | 1240000000 | 121750000
ALF | 2021-06-22 00:00:00 | Y | Buyback | 7.8 | 9.65 |  |  | 5550000 | 9.48 | 16.22 | 9.03 | 16.3 |  |  | 205640000 | Software | 74490000 | 4390000
BPTH | 2021-06-22 00:00:00 | Y | Patent granted | 6.38 | 8.54 |  |  | 2450000 | 7.26 | 6.99 | 6.57 | 7.29 |  |  | 5150000 | Biotech | 44600000 | 6900000
BIOC | 2021-06-22 00:00:00 | Y | Business collaboration | 4.2 | 6.32 |  |  | 1940000 | 4.76 | 4.41 | 4.24 | 4.97 |  |  | 8520000 | Healthcare Research | 57160000 | 13400000
NTEC | 2021-06-22 00:00:00 | Y | Business proposal | 4.12 | 5.18 |  |  | 2450000 | 4.96 | 3.85 | 3.67 | 5.01 |  |  | 10350000 | Biotech | 18550000 | 4370000