Spreadsheet: 791908d1660655482-sum-with-date-condition-in-a-table-test
Sheet: BO 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 possible |  |  |  |  |  |  |  |  |  |  | < 100M
 |  | Days Off |  | 10 | Vacation |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  | Trading Days (Net) |  |  | Annualized net annual trading days |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 |  | Entry < | Risk | [NAME] | [NAME] | Ave [NAME] | Net Gain | ATI
 |  | N/A | 1000 | 5000 | 25000 |  |  |  |  |  |  |  |  |  |  | POINTS (AT LEAST 20 TRADES)
 |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap | Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | GAIN/LOSS (Average Per Trade, Unless Otherwise Stated) |  |  |  |  |  |  |  |  | WEEKLY |  |  |  |  |  | 100-500M
 |  | All-time | Prev 3 Wk | Pre-ATH | Post-ATH |  |  |  |  | WEEK | TRADES | POINTS | WIN % | PF |  | 500M-1B
 | Days (Total) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Trades
 | Trades % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (AVERAGE OF AT LEAST 20 TRADES)
 | Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap | Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Profit Factor |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Net Gain % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Points (Total) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Points % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Points (Wk Ave)
 | Neg Trades ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WINNING % (AVERAGE OF AT LEAST 20 TRADES)
 | Neg Trades |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap | Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Risk |  |  |  |  |  |  |  |  | ENTRY < |  |  |  |  |  | < 100M
 | [NAME] |  |  |  |  |  |  |  |  | WEEKLY |  |  |  |  |  | 100-500M
 | [NAME] % |  |  |  |  |  |  |  |  | WEEK | TRADES | POINTS | WIN % | PF |  | 500M-1B
 | Stopped Out % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | PM Trades |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENTRY PRICE (AVERAGE OF AT LEAST 20 TRADES)
 | PM Trades % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Cap | Float | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | PM Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | PM Points (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | SETUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Setup | Trades | Trades % | Win % | Points | PF
 | Consolidation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (MEAN -1% 5X20 EXITS)
 | DNR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= 4 | >= 5 | >= 6 | >= 7 | >= 8 | >= 9 | >= 10
 | PM Consolidation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All-TIME (5)
 | Day 3 Surge |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 10 Wk
 | Trend Break |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 5 Wk
 | VWAP Hold
 | WORG
 | ENTRY POINT
 | Entry Point | Trades | Trades % | Win % | Points
 | Daily
 | HOD
 | PDC
 | PDH
 | PMH
 | R2G
 | Range High
 | ENTRY TIME
 |  | Trades | Trades % | Ave | Win % | Points | Points %
 | 8:30-8:59
 | 9:00-9:29
 | 9:30-9:45
 | 9:46-10:29
 | 10:30-11:29
 | 14:00-15:59
 | ENTRY PRICE
 |  | Trades | Trades % | Win % | Points | Points %
 | < 3
 | 3 - 5
 | 5 - 7
 | 7 - 10
 | 10 - 15
 | 15 - 20
 | 20 - 25
 | 25 - 30
 | 30 >
 | MAX
 |  | Mean -1% |  | > 5 pt | > 10 pt | > 20 pt | > 30 pt
 | Entry-High
 | High-Exit