Spreadsheet: 781471d1653358778-count-cell-a-if-cell-a-is-cell-b-bo_test
Sheet: RESULTS

 | ANNUALIZED NET GAIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRADES (AT LEAST 10 TRADES)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap / Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  | Trading Days (Gross) |  | 252 | Annual calendar trading days |  |  |  |  |  |  |  |  |  |  | < 100M
 |  | No Trade Days |  | 26 | Days w/ no trades available and vacation |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  | Traded % |  |  | Used in Annualized Net Gain calculations |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  | Trading Days (Net) |  |  | Net annual trading days |  |  |  |  |  |  |  |  |  |  | 1B <
 |  | Entry < | [NAME] | [NAME] | [NAME] | Days | Net | ATI |  |  |  |  |  |  |  | POINTS (AT LEAST 10 TRADES)
 |  | N/A | 500 | 3000 | 25000 |  |  |  |  |  |  |  |  |  |  | M Cap / Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  | WEEKLY |  |  |  |  |  | 100-500M
 | GAIN/LOSS |  |  |  |  |  |  |  |  | WEEK | TRADES | POINTS | WIN % | PF |  | 500M-1B
 |  | All-time | Prev 3 Wk | > 1 pt | > 2 pt | > 3 pt | > 4 pt |  |  |  |  |  |  |  |  | 1B <
 | Trades
 | Trades % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (AVERAGE OF AT LEAST 10 TRADES)
 | Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap / Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Profit Factor |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Gain % (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Days (Traded) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Points (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Points % (Net)
 | Points (Wk Ave) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WINNING % (AVERAGE OF AT LEAST 10 TRADES)
 | Entry Success % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap / Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Neg Trades ([NAME]) |  |  | Greatest sequence of negative trades |  |  |  |  |  | ENTRY LESS THAN |  |  |  |  |  | < 100M
 | Neg Trades (Ave) |  |  | Average sequence of negative trades |  |  |  |  |  | WEEKLY |  |  |  |  |  | 100-500M
 | Risk (Ave-5%) |  |  |  |  |  |  |  |  | WEEK | TRADES | POINTS | WIN % | PF |  | 500M-1B
 | Entry > DD (Ave-5%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | PM Trades
 | PM Trades % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENTRY PRICE (AVERAGE OF AT LEAST 10 TRADES)
 | PM Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap / Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | PM Points (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | SETUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Setup | Trades | Trades % | Win % | Points | PF | Entry % | Column1 |  |  |  |  |  |  |  | 1B <
 | Consolidation
 | D&R |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (MEAN -10% 5X20 EXITS)
 | Opening Range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= 4 | >= 5 | >= 6 | >= 7 | >= 8 | >= 9 | >= 10
 | PM Consolidation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All-TIME (5)
 | Sympathy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 10 Wk
 | Trend Break |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 5 Wk
 | VWAP Hold
 | WORG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SETUP (WIN % ENTRY TIME)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setup | 9:30-10 | 10-11:30 | 13-14:00 | 14-15:00 | 15-16:00 | Column | Column2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consolidation
 | ENTRY POINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D&R |  |  | N/A | N/A | N/A
 | Entry Point | Trades | Trades % | Win % | Points | Column2 | Column3 | Column4 |  |  |  |  |  |  |  | Opening Range |  |  | N/A | N/A | N/A
 | AHH |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM Consolidation |  |  | N/A | N/A | N/A
 | Daily |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sympathy
 | HOD |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trend Break
 | PDC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VWAP Hold | N/A | N/A
 | PDH |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORG |  |  | N/A | N/A | N/A
 | PMH
 | R2G
 | Range High
 | ENTRY TIME
 |  | Trades | Trades % | Ave | Win % | Points | Points %
 | 8:30-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-15:59
 | ENTRY PRICE
 |  | Entries | Trades % | Points | Points %
 | < 3
 | 3 - 5
 | 5 - 7
 | 7 - 10
 | 10 - 15
 | 15 - 20
 | 20 - 25
 | 25 - 30
 | 30 >
 | MAX
 |  | Mean 20% |  | > 5 pt | > 10 pt | > 20 pt | > 30 pt
 | Entry-High
 | High-Exit