AQU 01-01-2018 through 02-10-2018 with the data broken out by CFA and FigConsensus: query start: 2/12/2018 10:52:10 AM query end: 2/12/2018 10:52:11 AM elapsed time: 1 seconds Data Window Settings: Connected to: C:\Jeff\SpecialProjects\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE TRACK='AQU' AND [DATE] >= #01-01-2018# AND [DATE] <= #02-10-2018# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 1638.90 1614.70 1657.60 Bet -2254.00 -2254.00 -2254.00 ----------------------------------------------------- P/L -615.10 -639.30 -596.40 Wins 163 322 464 Plays 1127 1127 1127 PCT .1446 .2857 .4117 ROI 0.7271 0.7164 0.7354 Avg Mut 10.05 5.01 3.57 CFA-- By: SQL-F08 CFA Numeric Value >=Min < Max P/L Bet Roi Wins Plays Pct Impact -------------------------------------------------------------------------------------- -999.0000 70.0000 -53.20 142.00 0.6254 9 71 .1268 0.8764 70.0000 70.2500 -419.10 1032.00 0.5939 49 516 .0950 0.6566 70.2500 70.5000 77.40 318.00 1.2434 26 159 .1635 1.1306 70.5000 70.7500 -83.50 140.00 0.4036 9 70 .1286 0.8890 70.7500 71.0000 12.10 96.00 1.1260 10 48 .2083 1.4404 71.0000 71.2500 -31.80 58.00 0.4517 4 29 .1379 0.9537 71.2500 71.5000 -30.30 50.00 0.3940 4 25 .1600 1.1063 71.5000 71.7500 -13.60 44.00 0.6909 4 22 .1818 1.2571 71.7500 72.0000 -17.80 38.00 0.5316 2 19 .1053 0.7278 72.0000 72.2500 10.40 36.00 1.2889 7 18 .3889 2.6888 72.2500 72.5000 -7.10 18.00 0.6056 2 9 .2222 1.5365 72.5000 72.7500 -0.10 24.00 0.9958 4 12 .3333 2.3047 72.7500 73.0000 -3.70 14.00 0.7357 2 7 .2857 1.9755 73.0000 73.2500 -13.20 26.00 0.4923 2 13 .1538 1.0637 73.2500 73.5000 -10.30 14.00 0.2643 1 7 .1429 0.9877 73.5000 73.7500 34.80 8.00 5.3500 1 4 .2500 1.7285 73.7500 74.0000 -7.10 10.00 0.2900 1 5 .2000 1.3828 74.0000 74.2500 -3.70 6.00 0.3833 1 3 .3333 2.3047 74.2500 74.5000 1.60 4.00 1.4000 1 2 .5000 3.4571 74.5000 9999.0000 -56.90 176.00 0.6767 24 88 .2727 1.8857 By: SQL-F08 CFA Numeric Value expressed as a normalized probability distribution: >=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.0250 0.00 0.00 0.0000 0 0 .0000 0.0000 0.0250 0.0500 0.00 0.00 0.0000 0 0 .0000 0.0000 0.0500 0.0750 -22.40 44.00 0.4909 1 22 .0455 0.3143 0.0750 0.1000 -139.40 244.00 0.4287 10 122 .0820 0.5667 0.1000 0.1250 -198.80 632.00 0.6854 42 316 .1329 0.9190 0.1250 0.1500 -178.90 476.00 0.6242 29 238 .1218 0.8425 0.1500 0.1750 -56.90 474.00 0.8800 37 237 .1561 1.0794 0.1750 0.2000 -23.70 230.00 0.8970 25 115 .2174 1.5031 0.2000 0.2250 -17.40 90.00 0.8067 12 45 .2667 1.8438 0.2250 0.2500 39.60 28.00 2.4143 3 14 .2143 1.4816 0.2500 0.2750 -13.10 26.00 0.4962 3 13 .2308 1.5956 0.2750 0.3000 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.3000 0.3250 -4.00 4.00 0.0000 0 2 .0000 0.0000 0.3250 0.3500 0.00 0.00 0.0000 0 0 .0000 0.0000 0.3500 0.3750 3.90 2.00 2.9500 1 1 1.0000 6.9141 0.3750 0.4000 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.4000 0.4250 0.00 0.00 0.0000 0 0 .0000 0.0000 0.4250 0.4500 0.00 0.00 0.0000 0 0 .0000 0.0000 0.4500 9999.0000 0.00 0.00 0.0000 0 0 .0000 0.0000 FigConsensus-- By: SQL-F13 FigConsensus Numeric Value >=Min < Max P/L Bet Roi Wins Plays Pct Impact -------------------------------------------------------------------------------------- -999.0000 15.0000 -14.00 14.00 0.0000 0 7 .0000 0.0000 15.0000 20.0000 -12.40 24.00 0.4833 1 12 .0833 0.5762 20.0000 25.0000 -20.00 20.00 0.0000 0 10 .0000 0.0000 25.0000 30.0000 -30.00 30.00 0.0000 0 15 .0000 0.0000 30.0000 35.0000 -18.90 40.00 0.5275 3 20 .1500 1.0371 35.0000 40.0000 -16.20 94.00 0.8277 3 47 .0638 0.4413 40.0000 45.0000 -57.90 66.00 0.1227 1 33 .0303 0.2095 45.0000 50.0000 -0.90 138.00 0.9935 7 69 .1014 0.7014 50.0000 55.0000 -121.20 194.00 0.3753 5 97 .0515 0.3564 55.0000 60.0000 -94.80 256.00 0.6297 9 128 .0703 0.4861 60.0000 65.0000 -23.80 242.00 0.9017 16 121 .1322 0.9143 65.0000 70.0000 -49.60 250.00 0.8016 12 125 .0960 0.6638 70.0000 75.0000 -88.50 298.00 0.7030 24 149 .1611 1.1137 75.0000 80.0000 -82.70 242.00 0.6583 24 121 .1983 1.3714 80.0000 85.0000 32.40 178.00 1.1820 27 89 .3034 2.0975 85.0000 90.0000 -12.30 138.00 0.9109 25 69 .3623 2.5051 90.0000 95.0000 -4.30 30.00 0.8567 6 15 .4000 2.7656 95.0000 100.0000 0.00 0.00 0.0000 0 0 .0000 0.0000 100.0000 105.0000 0.00 0.00 0.0000 0 0 .0000 0.0000 105.0000 9999.0000 0.00 0.00 0.0000 0 0 .0000 0.0000 By: SQL-F13 FigConsensus Numeric Value expressed as a normalized probability distribution: >=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.0250 -10.00 10.00 0.0000 0 5 .0000 0.0000 0.0250 0.0500 -42.40 54.00 0.2148 1 27 .0370 0.2561 0.0500 0.0750 -61.50 106.00 0.4198 4 53 .0755 0.5218 0.0750 0.1000 -65.40 244.00 0.7320 10 122 .0820 0.5667 0.1000 0.1250 -180.60 418.00 0.5679 18 209 .0861 0.5955 0.1250 0.1500 -83.90 464.00 0.8192 21 232 .0905 0.6258 0.1500 0.1750 -121.20 420.00 0.7114 36 210 .1714 1.1853 0.1750 0.2000 -26.40 324.00 0.9185 44 162 .2716 1.8779 0.2000 0.2250 12.80 128.00 1.1000 19 64 .2969 2.0526 0.2250 0.2500 -27.30 58.00 0.5293 6 29 .2069 1.4305 0.2500 0.2750 -10.70 16.00 0.3313 1 8 .1250 0.8643 0.2750 0.3000 -0.40 8.00 0.9500 2 4 .5000 3.4571 0.3000 0.3250 0.00 0.00 0.0000 0 0 .0000 0.0000 0.3250 0.3500 3.90 2.00 2.9500 1 1 1.0000 6.9141 0.3500 0.3750 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.3750 0.4000 0.00 0.00 0.0000 0 0 .0000 0.0000 0.4000 0.4250 0.00 0.00 0.0000 0 0 .0000 0.0000 0.4250 0.4500 0.00 0.00 0.0000 0 0 .0000 0.0000 0.4500 9999.0000 0.00 0.00 0.0000 0 0 .0000 0.0000