--PART 1. query start: 5/1/2021 11:54:03 AM query end: 5/1/2021 11:54:03 AM elapsed time: 0 seconds Data Window Settings: Connected to: C:\Users\jeff\VBProgs\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE TRACK='CDX' AND DIST=2200 AND INTSURFACE=1 AND CLASSDESCRIPTOR='G1' AND [DATE] >= #01-01-2010# AND [DATE] <= #12-31-2020# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 299.00 306.40 276.60 Bet -418.00 -418.00 -418.00 ----------------------------------------------------- P/L -119.00 -111.60 -141.40 Wins 11 22 33 Plays 209 209 209 PCT .0526 .1053 .1579 ROI 0.7153 0.7330 0.6617 Avg Mut 27.18 13.93 8.38 ************************************************************************************************** BY TRACKLAST sorted by Win ROI Run Date: 5/1/2021 11:54:03 AM ************************************************************************************************** WIN WIN WIN PLACE PLACE TK PLAYS WINS PCT IMPACT ROI PLACES PCT ROI ************************************************************************************************** MTH 2 1 0.5 9.5 4.7 1 0.5 1.5 TPX 8 1 0.125 2.375 2.7375 1 0.125 1.225 OPX 33 3 0.0909 1.7271 2.397 6 0.1818 1.7091 SAX 22 3 0.1364 2.5916 1.0773 4 0.1818 0.7 GPX 29 3 0.1034 1.9646 0.531 5 0.1724 0.7897 KEE 36 0 0 0 0 1 0.0278 0.1278 FGX 24 0 0 0 0 2 0.0833 1.4667 AQU 22 0 0 0 0 0 0 0 MEY 9 0 0 0 0 0 0 0 SUN 7 0 0 0 0 1 0.1429 0.6 HAW 4 0 0 0 0 0 0 0 SAR 4 0 0 0 0 1 0.25 0.425 ELP 3 0 0 0 0 0 0 0 DMR 2 0 0 0 0 0 0 0 TAM 1 0 0 0 0 0 0 0 IND 1 0 0 0 0 0 0 0 NAK 1 0 0 0 0 0 0 0 BEL 1 0 0 0 0 0 0 0 ************************************************************************************************** 18 TrackLast Codes from file: StarterHistory Table ************************************************************************************************** By: SQL-F28 Rank (TDX_DIST_BEST10) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -9.60 24.00 0.6000 2 12 .1667 3.1667 7.20 2 -0.20 26.00 0.9923 2 13 .1538 2.9231 12.90 3 110.40 22.00 6.0182 1 11 .0909 1.7273 132.40 4 33.00 18.00 2.8333 3 9 .3333 6.3333 17.00 5 -26.00 26.00 0.0000 0 13 .0000 0.0000 0.00 6 0.80 18.00 1.0444 1 9 .1111 2.1111 18.80 7 -24.00 24.00 0.0000 0 12 .0000 0.0000 0.00 8 -20.00 20.00 0.0000 0 10 .0000 0.0000 0.00 9 -20.00 20.00 0.0000 0 10 .0000 0.0000 0.00 10 -24.00 24.00 0.0000 0 12 .0000 0.0000 0.00 11 -9.20 22.00 0.5818 1 11 .0909 1.7273 12.80 12 21.80 22.00 1.9909 1 11 .0909 1.7273 43.80 13 -24.00 24.00 0.0000 0 12 .0000 0.0000 0.00 14 -18.00 18.00 0.0000 0 9 .0000 0.0000 0.00 15 -22.00 22.00 0.0000 0 11 .0000 0.0000 0.00 16 -22.00 22.00 0.0000 0 11 .0000 0.0000 0.00 17 -22.00 22.00 0.0000 0 11 .0000 0.0000 0.00 18 -22.00 22.00 0.0000 0 11 .0000 0.0000 0.00 19 -22.00 22.00 0.0000 0 11 .0000 0.0000 0.00 Ending BankRoll: $105.30 Starting BankRoll: $300.00 High BankRoll: $330.00 Low BankRoll: $65.70 Longest Losing Streak: 28.00 Bet Percentage: 0.0175 Max Bet: 999999999.00 --PART 2. query start: 5/1/2021 11:58:56 AM query end: 5/1/2021 11:58:56 AM elapsed time: 0 seconds Data Window Settings: Connected to: C:\Users\jeff\VBProgs\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE TRACK='CDX' AND DIST=2200 AND INTSURFACE=1 AND CLASSDESCRIPTOR='G1' AND INSTR('GPX-MTH-OPX-SAX-TPX', TRACKLAST) > 0 AND RANKF28 <= 4 AND [DATE] >= #01-01-2010# AND [DATE] <= #12-31-2020# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 223.60 129.00 88.20 Bet -44.00 -44.00 -44.00 ----------------------------------------------------- P/L 179.60 85.00 44.20 Wins 8 11 13 Plays 22 22 22 PCT .3636 .5000 .5909 ROI 5.0818 2.9318 2.0045 Avg Mut 27.95 11.73 6.78 By: Calendar Year Year P/L Bet Roi Wins Plays Pct Impact AvgMut ------------------------------------------------------------------------------------ 2010 12.00 6.00 3.0000 1 3 .3333 0.9167 18.00 2011 -4.00 4.00 0.0000 0 2 .0000 0.0000 0.00 2012 26.60 6.00 5.4333 1 3 .3333 0.9167 32.60 2013 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 2014 3.00 4.00 1.7500 1 2 .5000 1.3750 7.00 2015 3.80 4.00 1.9500 1 2 .5000 1.3750 7.80 2016 -1.40 8.00 0.8250 1 4 .2500 0.6875 6.60 2017 9.40 2.00 5.7000 1 1 1.0000 2.7500 11.40 2018 3.80 4.00 1.9500 1 2 .5000 1.3750 7.80 2019 128.40 4.00 33.1000 1 2 .5000 1.3750 132.40 2020 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 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 Ending BankRoll: $885.60 Starting BankRoll: $300.00 High BankRoll: $885.60 Low BankRoll: $290.00 Longest Losing Streak: 4.00 Bet Percentage: 0.0175 Max Bet: 999999999.00