_BC_Tnr-2021-x0 SQL Factor Setup Slot Factor ---- ---------------------- F16 _TNR_BC-SURF-DIST-120 query start: 11/5/2021 9:19:31 AM query end: 11/5/2021 9:19:31 AM elapsed time: 0 seconds Data Window Settings: Connected to: C:\Users\jeff\VBProgs\JCapper2.mdb 999 Divisor Odds Cap: None Betting Instructions: think SQL UDM Plays Report: Display (H12 Txt Green) UDM: _BC_Tnr-2021-x0 --(Tagged as: TAG DATE: 11-05-2021) SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('CDX-DMR-KEE-SAX', TRACK) > 0 AND WEEKDAY([DATE]) BETWEEN 6 AND 7 AND RANKF16 <= 2 AND DTSHIFT < 1 AND PACELOW < 2 AND DIST >= 1540 AND [DATE] >= #01-01-2010# AND [DATE] <= #12-31-2020# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 1253.40 642.40 480.00 Bet -440.00 -440.00 -440.00 ----------------------------------------------------- P/L 813.40 202.40 40.00 Wins 42 63 87 Plays 220 220 220 PCT .1909 .2864 .3955 ROI 2.8486 1.4600 1.0909 Avg Mut 29.84 10.20 5.52 By: Calendar Year Year P/L Bet Roi Wins Plays Pct Impact AvgMut ------------------------------------------------------------------------------------ 2010 77.80 40.00 2.9450 5 20 .2500 1.3095 23.56 2011 135.60 42.00 4.2286 5 21 .2381 1.2472 35.52 2012 4.00 46.00 1.0870 5 23 .2174 1.1387 10.00 2013 144.80 40.00 4.6200 4 20 .2000 1.0476 46.20 2014 2.00 36.00 1.0556 2 18 .1111 0.5820 19.00 2015 -46.80 50.00 0.0640 1 25 .0400 0.2095 3.20 2016 78.40 42.00 2.8667 5 21 .2381 1.2472 24.08 2017 51.80 40.00 2.2950 4 20 .2000 1.0476 22.95 2018 -13.40 44.00 0.6955 4 22 .1818 0.9524 7.65 2019 85.00 36.00 3.3611 3 18 .1667 0.8730 40.33 2020 294.20 24.00 13.2583 4 12 .3333 1.7460 79.55 2021 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2022 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2023 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2024 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2025 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2026 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2027 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2028 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 Day P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 S 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 2 M 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 3 T 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 4 W 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 5 T 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 6 F 407.80 206.00 2.9796 22 103 .2136 1.1188 27.90 7 S 405.60 234.00 2.7333 20 117 .1709 0.8954 31.98 ************************************************************************************************** BY TRACK sorted by Track Code Run Date: 11/5/2021 8:37:50 AM ************************************************************************************************** WIN WIN WIN PLACE PLACE TK PLAYS WINS PCT IMPACT ROI PLACES PCT ROI ************************************************************************************************** CDX 63 14 0.2222 1.1639 2.5873 22 0.3492 1.4063 DMR 20 4 0.2 1.0476 2.295 5 0.25 1.05 KEE 37 5 0.1351 0.7077 4.3432 8 0.2162 2.0622 SAX 100 19 0.19 0.9952 2.571 28 0.28 1.353 ************************************************************************************************** 4 Track Codes from file: StarterHistory Table ************************************************************************************************** By: Odds >=Min < Max P/L Bet Roi Wins Plays Pct Impact -------------------------------------------------------------------------------------- -999.0000 0.0000 0.00 0.00 0.0000 0 0 .0000 0.0000 0.0000 0.5000 0.00 0.00 0.0000 0 0 .0000 0.0000 0.5000 1.0000 2.00 8.00 1.2500 3 4 .7500 3.9286 1.0000 1.5000 -4.60 18.00 0.7444 3 9 .3333 1.7460 1.5000 2.0000 3.00 8.00 1.3750 2 4 .5000 2.6190 2.0000 2.5000 0.60 12.00 1.0500 2 6 .3333 1.7460 2.5000 3.0000 6.80 16.00 1.4250 3 8 .3750 1.9643 3.0000 3.5000 13.60 12.00 2.1333 3 6 .5000 2.6190 3.5000 4.0000 6.40 12.00 1.5333 2 6 .3333 1.7460 4.0000 4.5000 -8.00 8.00 0.0000 0 4 .0000 0.0000 4.5000 5.0000 -14.00 14.00 0.0000 0 7 .0000 0.0000 5.0000 5.5000 15.00 22.00 1.6818 3 11 .2727 1.4286 5.5000 6.0000 -2.20 16.00 0.8625 1 8 .1250 0.6548 6.0000 6.5000 -6.00 6.00 0.0000 0 3 .0000 0.0000 6.5000 7.0000 34.00 12.00 3.8333 3 6 .5000 2.6190 7.0000 7.5000 2.20 14.00 1.1571 1 7 .1429 0.7483 7.5000 8.0000 26.60 8.00 4.3250 2 4 .5000 2.6190 8.0000 8.5000 10.00 8.00 2.2500 1 4 .2500 1.3095 8.5000 9.0000 11.80 8.00 2.4750 1 4 .2500 1.3095 9.0000 9999.0000 716.20 238.00 4.0092 12 119 .1008 0.5282 Ending BankRoll: $29,848.70 Starting BankRoll: $300.00 High BankRoll: $29,848.70 Low BankRoll: $270.50 Longest Losing Streak: 14.00 Bet Percentage: 0.0175 Max Bet: 999999999.00