An example UDM with the data broken out BY TRACK: query start: 9/7/2018 7:12:04 AM query end: 9/7/2018 7:12:43 AM elapsed time: 39 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None Betting Instructions: must validate SQL UDM Plays Report: Hide UDM: __Example-Spd-a --(Tagged as: Orig Tag Date: 06-09-2018 -- New Tag Date: 08-30-2018) SQL: SELECT * FROM STARTERHISTORY WHERE RANKF21 = 1 AND RANKF35 <= 3 AND RANKF19 <= 3 AND RANKF09 <= 4 AND VALF09 >= 55.75 AND VALF20 >= 150 AND RANKF06 <= 3 AND RANKF31 <= 7 AND CLSHIFT2 >= -2 AND RUNSTYLE < 60 AND QSPEEDPOINTS >= 5 AND DTSHIFT BETWEEN -0.5 AND 1.5 AND XTHSTARTLASIX >= 3 AND NOT (SEX < 3 AND STARTSLIFETIME >= 25) AND NOT (SEX >= 3 AND STARTSLIFETIME >= 50) AND NOT (DIST >= 1760 AND RANKF07 >= 3) AND PACEPRESSURE >= 10 AND RACEVOLATILITY >= 27.5 AND [DATE] >= #01-01-2018# AND [DATE] <= #09-05-2018# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 1646.20 1368.90 1317.10 Bet -1410.00 -1410.00 -1410.00 ----------------------------------------------------- P/L 236.20 -41.10 -92.90 Wins 292 403 496 Plays 705 705 705 PCT .4142 .5716 .7035 ROI 1.1675 0.9709 0.9341 Avg Mut 5.64 3.40 2.66 **************************************************************************************** BY TRACK sorted by Track Code Run Date: 9/7/2018 7:12:43 AM **************************************************************************************** WIN WIN WIN PLACE PLACE TRACK PLAYS WINS PCT IMPACT ROI PLACES PCT ROI **************************************************************************************** ALB 13 7 0.5385 1.3001 0.8923 9 0.6923 0.9154 APX 15 6 0.4 0.9658 0.7933 9 0.6 0.8667 AQU 14 7 0.5 1.2072 1.2036 7 0.5 0.7786 ARP 15 5 0.3333 0.8047 1.0933 8 0.5333 0.8667 ASD 8 2 0.25 0.6036 0.7562 3 0.375 0.8187 BEL 9 5 0.5556 1.3414 1.7611 6 0.6667 1.25 BTP 25 10 0.4 0.9658 0.9 14 0.56 0.904 CBY 7 1 0.1429 0.345 0.3857 3 0.4286 1.0714 CDX 11 3 0.2727 0.6584 0.8364 5 0.4545 1.0273 CLS 2 1 0.5 1.2072 0.9 2 1 1.95 CPW 1 1 1 2.4144 3.6 1 1 1.7 CTX 19 9 0.4737 1.1437 1.1316 11 0.5789 0.8737 DED 9 6 0.6667 1.6097 1.3556 7 0.7778 1.2056 DEL 6 3 0.5 1.2072 0.9167 5 0.8333 1.1333 DMR 9 3 0.3333 0.8047 1.3444 4 0.4444 0.9222 ELP 2 1 0.5 1.2072 2.25 2 1 2.05 EMD 10 5 0.5 1.2072 2.01 5 0.5 1 EVD 28 16 0.5714 1.3796 1.8571 17 0.6071 1.1893 FER 1 0 0 0 0 0 0 0 FEX 4 0 0 0 0 1 0.25 0.35 FGX 9 5 0.5556 1.3414 2.4556 6 0.6667 1.8778 FLX 27 10 0.3704 0.8943 1.0185 17 0.6296 1.0278 FON 4 2 0.5 1.2072 0.975 3 0.75 1.25 FPK 4 0 0 0 0 0 0 0 GGX 8 0 0 0 0 3 0.375 0.575 GPX 46 21 0.4565 1.1022 1.3674 28 0.6087 1.0217 HAW 2 1 0.5 1.2072 2.5 2 1 1.95 HOU 3 2 0.6667 1.6097 1.7667 2 0.6667 0.8833 HPO 3 3 1 2.4144 2.5333 3 1 1.7667 HST 12 3 0.25 0.6036 0.6375 7 0.5833 0.9375 IND 18 7 0.3889 0.939 0.9056 10 0.5556 0.8333 KEE 1 0 0 0 0 0 0 0 LAD 7 4 0.5714 1.3796 1.7143 6 0.8571 1.2786 LAX 2 1 0.5 1.2072 2.75 1 0.5 1.1 LRC 1 0 0 0 0 1 1 1.7 LRL 13 6 0.4615 1.1142 1 7 0.5385 0.9154 LSX 10 3 0.3 0.7243 1.18 5 0.5 1.12 MNR 21 9 0.4286 1.0348 1.281 13 0.619 1.0429 MTH 24 6 0.25 0.6036 0.8083 11 0.4583 0.7875 MVR 19 12 0.6316 1.5249 1.4632 13 0.6842 1.0553 NPX 3 0 0 0 0 0 0 0 OPX 27 11 0.4074 0.9836 1.2926 14 0.5185 0.9296 PEN 29 11 0.3793 0.9158 1.0759 18 0.6207 1.0121 PHA 23 12 0.5217 1.2596 1.5304 12 0.5217 0.887 PID 13 4 0.3077 0.7429 1.5538 5 0.3846 0.9846 PIM 3 1 0.3333 0.8047 1.3 1 0.3333 0.6333 PLN 1 1 1 2.4144 1.6 1 1 1.2 PMX 1 1 1 2.4144 2.3 1 1 1.2 PRM 27 11 0.4074 0.9836 0.9111 14 0.5185 0.8556 RET 3 0 0 0 0 1 0.3333 0.3667 RIL 1 1 1 2.4144 3.1 1 1 2.3 RPX 2 1 0.5 1.2072 2.3 1 0.5 1.35 RUI 2 2 1 2.4144 4.3 2 1 1.8 SAC 2 1 0.5 1.2072 1.1 1 0.5 0.75 SAR 10 4 0.4 0.9658 1.08 5 0.5 0.945 SAX 13 4 0.3077 0.7429 1.0462 9 0.6923 1.1462 SRP 6 5 0.8333 2.0119 1.4833 6 1 1.225 SUD 1 0 0 0 0 0 0 0 SUF 1 0 0 0 0 0 0 0 SUN 6 0 0 0 0 0 0 0 SWF 1 0 0 0 0 0 0 0 TAM 9 3 0.3333 0.8047 1.0444 4 0.4444 0.9556 TDN 37 13 0.3514 0.8484 0.9243 21 0.5676 0.8405 TPX 8 4 0.5 1.2072 1.0875 6 0.75 1.2125 TUP 16 8 0.5 1.2072 1.2688 11 0.6875 1.0281 UNX 2 1 0.5 1.2072 1.3 1 0.5 0.7 WOX 8 5 0.625 1.509 2.1 5 0.625 1.1312 WRD 8 2 0.25 0.6036 0.55 6 0.75 1.1375 **************************************************************************************** 68 Track Codes from file: StarterHistory Table **************************************************************************************** **************************************************************************************** BY TRACK sorted by Impact Value Run Date: 9/7/2018 7:12:43 AM **************************************************************************************** WIN WIN WIN PLACE PLACE TRACK PLAYS WINS PCT IMPACT ROI PLACES PCT ROI **************************************************************************************** HPO 3 3 1 2.4144 2.5333 3 1 1.7667 RUI 2 2 1 2.4144 4.3 2 1 1.8 CPW 1 1 1 2.4144 3.6 1 1 1.7 RIL 1 1 1 2.4144 3.1 1 1 2.3 PLN 1 1 1 2.4144 1.6 1 1 1.2 PMX 1 1 1 2.4144 2.3 1 1 1.2 SRP 6 5 0.8333 2.0119 1.4833 6 1 1.225 DED 9 6 0.6667 1.6097 1.3556 7 0.7778 1.2056 HOU 3 2 0.6667 1.6097 1.7667 2 0.6667 0.8833 MVR 19 12 0.6316 1.5249 1.4632 13 0.6842 1.0553 WOX 8 5 0.625 1.509 2.1 5 0.625 1.1312 EVD 28 16 0.5714 1.3796 1.8571 17 0.6071 1.1893 LAD 7 4 0.5714 1.3796 1.7143 6 0.8571 1.2786 BEL 9 5 0.5556 1.3414 1.7611 6 0.6667 1.25 FGX 9 5 0.5556 1.3414 2.4556 6 0.6667 1.8778 ALB 13 7 0.5385 1.3001 0.8923 9 0.6923 0.9154 PHA 23 12 0.5217 1.2596 1.5304 12 0.5217 0.887 TUP 16 8 0.5 1.2072 1.2688 11 0.6875 1.0281 AQU 14 7 0.5 1.2072 1.2036 7 0.5 0.7786 EMD 10 5 0.5 1.2072 2.01 5 0.5 1 TPX 8 4 0.5 1.2072 1.0875 6 0.75 1.2125 DEL 6 3 0.5 1.2072 0.9167 5 0.8333 1.1333 FON 4 2 0.5 1.2072 0.975 3 0.75 1.25 HAW 2 1 0.5 1.2072 2.5 2 1 1.95 LAX 2 1 0.5 1.2072 2.75 1 0.5 1.1 ELP 2 1 0.5 1.2072 2.25 2 1 2.05 SAC 2 1 0.5 1.2072 1.1 1 0.5 0.75 CLS 2 1 0.5 1.2072 0.9 2 1 1.95 RPX 2 1 0.5 1.2072 2.3 1 0.5 1.35 UNX 2 1 0.5 1.2072 1.3 1 0.5 0.7 CTX 19 9 0.4737 1.1437 1.1316 11 0.5789 0.8737 LRL 13 6 0.4615 1.1142 1 7 0.5385 0.9154 GPX 46 21 0.4565 1.1022 1.3674 28 0.6087 1.0217 MNR 21 9 0.4286 1.0348 1.281 13 0.619 1.0429 OPX 27 11 0.4074 0.9836 1.2926 14 0.5185 0.9296 PRM 27 11 0.4074 0.9836 0.9111 14 0.5185 0.8556 BTP 25 10 0.4 0.9658 0.9 14 0.56 0.904 APX 15 6 0.4 0.9658 0.7933 9 0.6 0.8667 SAR 10 4 0.4 0.9658 1.08 5 0.5 0.945 IND 18 7 0.3889 0.939 0.9056 10 0.5556 0.8333 PEN 29 11 0.3793 0.9158 1.0759 18 0.6207 1.0121 FLX 27 10 0.3704 0.8943 1.0185 17 0.6296 1.0278 TDN 37 13 0.3514 0.8484 0.9243 21 0.5676 0.8405 ARP 15 5 0.3333 0.8047 1.0933 8 0.5333 0.8667 TAM 9 3 0.3333 0.8047 1.0444 4 0.4444 0.9556 DMR 9 3 0.3333 0.8047 1.3444 4 0.4444 0.9222 PIM 3 1 0.3333 0.8047 1.3 1 0.3333 0.6333 SAX 13 4 0.3077 0.7429 1.0462 9 0.6923 1.1462 PID 13 4 0.3077 0.7429 1.5538 5 0.3846 0.9846 LSX 10 3 0.3 0.7243 1.18 5 0.5 1.12 CDX 11 3 0.2727 0.6584 0.8364 5 0.4545 1.0273 MTH 24 6 0.25 0.6036 0.8083 11 0.4583 0.7875 HST 12 3 0.25 0.6036 0.6375 7 0.5833 0.9375 WRD 8 2 0.25 0.6036 0.55 6 0.75 1.1375 ASD 8 2 0.25 0.6036 0.7562 3 0.375 0.8187 CBY 7 1 0.1429 0.345 0.3857 3 0.4286 1.0714 GGX 8 0 0 0 0 3 0.375 0.575 SUN 6 0 0 0 0 0 0 0 FEX 4 0 0 0 0 1 0.25 0.35 FPK 4 0 0 0 0 0 0 0 RET 3 0 0 0 0 1 0.3333 0.3667 NPX 3 0 0 0 0 0 0 0 SUF 1 0 0 0 0 0 0 0 LRC 1 0 0 0 0 1 1 1.7 SWF 1 0 0 0 0 0 0 0 KEE 1 0 0 0 0 0 0 0 SUD 1 0 0 0 0 0 0 0 FER 1 0 0 0 0 0 0 0 **************************************************************************************** 68 Track Codes from file: StarterHistory Table **************************************************************************************** **************************************************************************************** BY TRACK sorted by Win ROI Run Date: 9/7/2018 7:12:43 AM **************************************************************************************** WIN WIN WIN PLACE PLACE TRACK PLAYS WINS PCT IMPACT ROI PLACES PCT ROI **************************************************************************************** RUI 2 2 1 2.4144 4.3 2 1 1.8 CPW 1 1 1 2.4144 3.6 1 1 1.7 RIL 1 1 1 2.4144 3.1 1 1 2.3 LAX 2 1 0.5 1.2072 2.75 1 0.5 1.1 HPO 3 3 1 2.4144 2.5333 3 1 1.7667 HAW 2 1 0.5 1.2072 2.5 2 1 1.95 FGX 9 5 0.5556 1.3414 2.4556 6 0.6667 1.8778 RPX 2 1 0.5 1.2072 2.3 1 0.5 1.35 PMX 1 1 1 2.4144 2.3 1 1 1.2 ELP 2 1 0.5 1.2072 2.25 2 1 2.05 WOX 8 5 0.625 1.509 2.1 5 0.625 1.1312 EMD 10 5 0.5 1.2072 2.01 5 0.5 1 EVD 28 16 0.5714 1.3796 1.8571 17 0.6071 1.1893 HOU 3 2 0.6667 1.6097 1.7667 2 0.6667 0.8833 BEL 9 5 0.5556 1.3414 1.7611 6 0.6667 1.25 LAD 7 4 0.5714 1.3796 1.7143 6 0.8571 1.2786 PLN 1 1 1 2.4144 1.6 1 1 1.2 PID 13 4 0.3077 0.7429 1.5538 5 0.3846 0.9846 PHA 23 12 0.5217 1.2596 1.5304 12 0.5217 0.887 SRP 6 5 0.8333 2.0119 1.4833 6 1 1.225 MVR 19 12 0.6316 1.5249 1.4632 13 0.6842 1.0553 GPX 46 21 0.4565 1.1022 1.3674 28 0.6087 1.0217 DED 9 6 0.6667 1.6097 1.3556 7 0.7778 1.2056 DMR 9 3 0.3333 0.8047 1.3444 4 0.4444 0.9222 PIM 3 1 0.3333 0.8047 1.3 1 0.3333 0.6333 UNX 2 1 0.5 1.2072 1.3 1 0.5 0.7 OPX 27 11 0.4074 0.9836 1.2926 14 0.5185 0.9296 MNR 21 9 0.4286 1.0348 1.281 13 0.619 1.0429 TUP 16 8 0.5 1.2072 1.2688 11 0.6875 1.0281 AQU 14 7 0.5 1.2072 1.2036 7 0.5 0.7786 LSX 10 3 0.3 0.7243 1.18 5 0.5 1.12 CTX 19 9 0.4737 1.1437 1.1316 11 0.5789 0.8737 SAC 2 1 0.5 1.2072 1.1 1 0.5 0.75 ARP 15 5 0.3333 0.8047 1.0933 8 0.5333 0.8667 TPX 8 4 0.5 1.2072 1.0875 6 0.75 1.2125 SAR 10 4 0.4 0.9658 1.08 5 0.5 0.945 PEN 29 11 0.3793 0.9158 1.0759 18 0.6207 1.0121 SAX 13 4 0.3077 0.7429 1.0462 9 0.6923 1.1462 TAM 9 3 0.3333 0.8047 1.0444 4 0.4444 0.9556 FLX 27 10 0.3704 0.8943 1.0185 17 0.6296 1.0278 LRL 13 6 0.4615 1.1142 1 7 0.5385 0.9154 FON 4 2 0.5 1.2072 0.975 3 0.75 1.25 TDN 37 13 0.3514 0.8484 0.9243 21 0.5676 0.8405 DEL 6 3 0.5 1.2072 0.9167 5 0.8333 1.1333 PRM 27 11 0.4074 0.9836 0.9111 14 0.5185 0.8556 IND 18 7 0.3889 0.939 0.9056 10 0.5556 0.8333 BTP 25 10 0.4 0.9658 0.9 14 0.56 0.904 CLS 2 1 0.5 1.2072 0.9 2 1 1.95 ALB 13 7 0.5385 1.3001 0.8923 9 0.6923 0.9154 CDX 11 3 0.2727 0.6584 0.8364 5 0.4545 1.0273 MTH 24 6 0.25 0.6036 0.8083 11 0.4583 0.7875 APX 15 6 0.4 0.9658 0.7933 9 0.6 0.8667 ASD 8 2 0.25 0.6036 0.7562 3 0.375 0.8187 HST 12 3 0.25 0.6036 0.6375 7 0.5833 0.9375 WRD 8 2 0.25 0.6036 0.55 6 0.75 1.1375 CBY 7 1 0.1429 0.345 0.3857 3 0.4286 1.0714 GGX 8 0 0 0 0 3 0.375 0.575 SUN 6 0 0 0 0 0 0 0 FPK 4 0 0 0 0 0 0 0 FEX 4 0 0 0 0 1 0.25 0.35 NPX 3 0 0 0 0 0 0 0 RET 3 0 0 0 0 1 0.3333 0.3667 KEE 1 0 0 0 0 0 0 0 SUF 1 0 0 0 0 0 0 0 SWF 1 0 0 0 0 0 0 0 SUD 1 0 0 0 0 0 0 0 FER 1 0 0 0 0 0 0 0 LRC 1 0 0 0 0 1 1 1.7 **************************************************************************************** 68 Track Codes from file: StarterHistory Table **************************************************************************************** Ending BankRoll: $1,571.05 Starting BankRoll: $300.00 High BankRoll: $2,451.95 Low BankRoll: $261.50 Longest Losing Streak: 15.00 Bet Percentage: 0.0175 Max Bet: 999999999.00