--1. ALL TRACKS 2022 YTD: query start: 6/26/2022 5:42:25 PM query end: 6/26/2022 5:43:33 PM elapsed time: 68 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE [DATE] >= #01-01-2022# AND [DATE] <= #06-25-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 174847.70 173427.70 172333.80 Bet -231638.00 -231638.00 -231638.00 ----------------------------------------------------- P/L -56790.30 -58210.30 -59304.20 Wins 16109 32012 46207 Plays 115819 115819 115819 PCT .1391 .2764 .3990 ROI 0.7548 0.7487 0.7440 Avg Mut 10.85 5.42 3.73 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -6127.40 31978.00 0.8084 3179 15989 .1988 1.4295 8.13 2 -7728.30 32084.00 0.7591 2939 16042 .1832 1.3172 8.29 3 -5616.60 32202.00 0.8256 2792 16101 .1734 1.2467 9.52 4 -7470.80 31824.00 0.7652 2229 15912 .1401 1.0072 10.93 5 -6961.20 30824.00 0.7742 1908 15412 .1238 0.8901 12.51 6 -8095.00 27226.00 0.7027 1380 13613 .1014 0.7288 13.86 7 -6187.70 19480.00 0.6824 833 9740 .0855 0.6149 15.96 8 -4070.90 12236.00 0.6673 451 6118 .0737 0.5300 18.10 9 -2727.50 7184.00 0.6203 209 3592 .0582 0.4183 21.32 10 -852.50 3986.00 0.7861 117 1993 .0587 0.4221 26.78 11 -688.50 1744.00 0.6052 52 872 .0596 0.4287 20.30 12 -357.60 792.00 0.5485 18 396 .0455 0.3268 24.13 13 -39.90 48.00 0.1688 1 24 .0417 0.2996 8.10 14 -18.00 18.00 0.0000 0 9 .0000 0.0000 0.00 15 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 16 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 17 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 18 161.60 2.00 81.8000 1 1 1.0000 7.1897 163.60 19 -4.00 4.00 0.0000 0 2 .0000 0.0000 0.00 --------------------------------------------------------------------------------------- --2. MTH-SAX-GGX, ALL: query start: 6/26/2022 5:27:49 PM query end: 6/26/2022 5:28:01 PM elapsed time: 12 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('MTH-SAX-GGX', TRACK) > 0 AND [DATE] >= #01-01-2022# AND [DATE] <= #06-25-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 15670.20 15709.30 15493.50 Bet -20840.00 -20840.00 -20840.00 ----------------------------------------------------- P/L -5169.80 -5130.70 -5346.50 Wins 1521 3017 4346 Plays 10420 10420 10420 PCT .1460 .2895 .4171 ROI 0.7519 0.7538 0.7435 Avg Mut 10.30 5.21 3.57 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -639.30 3040.00 0.7897 331 1520 .2178 1.4918 7.25 2 -905.30 3028.00 0.7010 267 1514 .1764 1.2082 7.95 3 -470.40 3034.00 0.8450 264 1517 .1740 1.1922 9.71 4 -496.00 3018.00 0.8357 217 1509 .1438 0.9852 11.62 5 -597.20 2914.00 0.7951 199 1457 .1366 0.9357 11.64 6 -972.60 2428.00 0.5994 109 1214 .0898 0.6151 13.35 7 -492.80 1620.00 0.6958 67 810 .0827 0.5667 16.82 8 -467.20 916.00 0.4900 39 458 .0852 0.5834 11.51 9 -47.00 470.00 0.9000 16 235 .0681 0.4664 26.44 10 -55.80 246.00 0.7732 8 123 .0650 0.4456 23.78 11 5.80 94.00 1.0617 4 47 .0851 0.5830 24.95 12 -32.00 32.00 0.0000 0 16 .0000 0.0000 0.00 13 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 14 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 15 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 16 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 17 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 18 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 19 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 --------------------------------------------------------------------------------------- --3. MTH-SAX-GGX, NON SHIPPERS: query start: 6/26/2022 5:36:05 PM query end: 6/26/2022 5:36:19 PM elapsed time: 14 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('MTH-SAX-GGX', TRACK) > 0 and not ((track='MTH' and not tracklast='MTH') or (track='SAX' and not tracklast='SAX') or (track='GGX' and not tracklast='GGX')) AND [DATE] >= #01-01-2022# AND [DATE] <= #06-25-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 11206.80 11286.10 11090.50 Bet -14738.00 -14738.00 -14738.00 ----------------------------------------------------- P/L -3531.20 -3451.90 -3647.50 Wins 1099 2214 3182 Plays 7369 7369 7369 PCT .1491 .3004 .4318 ROI 0.7604 0.7658 0.7525 Avg Mut 10.20 5.10 3.49 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -647.40 2184.00 0.7036 219 1092 .2005 1.3447 7.02 2 -659.00 2178.00 0.6974 195 1089 .1791 1.2007 7.79 3 -194.80 2152.00 0.9095 199 1076 .1849 1.2401 9.84 4 -336.80 2148.00 0.8432 161 1074 .1499 1.0052 11.25 5 -289.80 2092.00 0.8615 152 1046 .1453 0.9744 11.86 6 -702.60 1748.00 0.5981 80 874 .0915 0.6137 13.07 7 -401.00 1112.00 0.6394 49 556 .0881 0.5909 14.51 8 -319.20 582.00 0.4515 26 291 .0893 0.5991 10.11 9 8.20 308.00 1.0266 9 154 .0584 0.3919 35.13 10 0.00 164.00 1.0000 6 82 .0732 0.4906 27.33 11 31.20 50.00 1.6240 3 25 .1200 0.8046 27.07 12 -20.00 20.00 0.0000 0 10 .0000 0.0000 0.00 13 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 14 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 15 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 16 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 17 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 18 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 19 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 --------------------------------------------------------------------------------------- --4. MTH-SAX-GGX, SHIPPERS: query start: 6/26/2022 5:33:24 PM query end: 6/26/2022 5:33:31 PM elapsed time: 7 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('MTH-SAX-GGX', TRACK) > 0 and ((track='MTH' and not tracklast='MTH') or (track='SAX' and not tracklast='SAX') or (track='GGX' and not tracklast='GGX')) AND [DATE] >= #01-01-2022# AND [DATE] <= #06-25-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 4463.40 4423.20 4403.00 Bet -6102.00 -6102.00 -6102.00 ----------------------------------------------------- P/L -1638.60 -1678.80 -1699.00 Wins 422 803 1164 Plays 3051 3051 3051 PCT .1383 .2632 .3815 ROI 0.7315 0.7249 0.7216 Avg Mut 10.58 5.51 3.78 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 8.10 856.00 1.0095 112 428 .2617 1.8919 7.72 2 -246.30 850.00 0.7102 72 425 .1694 1.2248 8.38 3 -275.60 882.00 0.6875 65 441 .1474 1.0656 9.33 4 -159.20 870.00 0.8170 56 435 .1287 0.9307 12.69 5 -307.40 822.00 0.6260 47 411 .1144 0.8268 10.95 6 -270.00 680.00 0.6029 29 340 .0853 0.6167 14.14 7 -91.80 508.00 0.8193 18 254 .0709 0.5124 23.12 8 -148.00 334.00 0.5569 13 167 .0778 0.5628 14.31 9 -55.20 162.00 0.6593 7 81 .0864 0.6248 15.26 10 -55.80 82.00 0.3195 2 41 .0488 0.3527 13.10 11 -25.40 44.00 0.4227 1 22 .0455 0.3286 18.60 12 -12.00 12.00 0.0000 0 6 .0000 0.0000 0.00 13 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 14 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 15 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 16 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 17 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 18 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 19 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00