******************************************************************************************************************** JCapper WagerHistory Report - File: C:\JCapper\exe\JCapper2.mdb - 5/29/2022 2:38:28 PM ******************************************************************************************************************** SQL: SELECT * FROM WAGERHISTORY WHERE (ENTRYTYPE = 2 OR ENTRYTYPE = 4) AND INSTR('AGAME-HATC-PHYS', SHORTDESCRIPTION) > 0 AND ESTIMATEDEDGE >= .95 AND [DATE] >= #05-24-2022# AND [DATE] <= #12-31-2022# ORDER BY [DATE] DESC, TRACKCODE, RACENUMBER, SHORTDESCRIPTION ************************************************************************************ WAGER TYPE SUMMARY ************************************************************************************ WAGER AMT AMT TYPE WAGERED COLLCTED P/L ROI HITS TICKETS PCT ------------------------------------------------------------------------------------ WIN 127.00 161.30 34.30 1.2701 11 38 0.2895 PLACE 14.00 14.60 0.60 1.0429 2 5 0.4000 ------------------------------------------------------------------------------------ Totals 141.00 175.90 34.90 1.2475 13 43 0.3023 ************************************************************************************ SHORT DESCR SUMMARY ************************************************************************************ SHORT AMT AMT DESCR WAGERED COLLCTED P/L ROI HITS TICKETS PCT ------------------------------------------------------------------------------------ AGAME 24.00 40.80 16.80 1.7000 3 4 0.7500 HATC 59.00 82.70 23.70 1.4017 6 16 0.3750 PHYS 58.00 52.40 -5.60 0.9034 4 23 0.1739 ------------------------------------------------------------------------------------ Totals 141.00 175.90 34.90 1.2475 13 43 0.3023 ******************************************************************************************************************** REPORT DETAIL SECTION ******************************************************************************************************************** STRIKE DECSN EST A SHORT WAGER AMT AMT ID DATE TRK R PRICE ODDS EDGE UDMs PHYS TKWT DESCR TYPE WAGERED COLLECTED P/L -------------------------------------------------------------------------------------------------------------------- 52 5/25/2022 CBY 4 1.00 2.30 1.08 1 3.00 3.25 HATC WIN 4.00 13.20 9.20 50 5/25/2022 CTX 2 1.00 1.30 1.05 1 3.00 3.25 HATC WIN 4.00 9.20 5.20 51 5/25/2022 CTX 2 1.00 3.30 1.07 1 3.00 3.25 PHYS WIN 2.00 0.00 -2.00 35 5/25/2022 DEL 1 1.00 1.20 1.05 0 3.00 3.00 HATC WIN 2.00 0.00 -2.00 34 5/25/2022 DEL 1 1.00 4.40 1.08 0 3.25 3.00 PHYS WIN 2.00 0.00 -2.00 42 5/25/2022 DEL 6 1.00 3.20 1.07 1 3.00 3.25 PHYS WIN 6.00 25.20 19.20 41 5/25/2022 FLX 4 1.00 1.15 1.06 1 3.00 3.25 HATC WIN 4.00 8.60 4.60 55 5/25/2022 FLX 4 1.00 11.70 1.08 1 3.00 3.25 PHYS PLACE 2.00 0.00 -2.00 39 5/25/2022 FLX 4 1.00 33.75 1.08 1 3.00 3.25 PHYS WIN 1.00 0.00 -1.00 40 5/25/2022 FLX 4 1.00 11.70 1.08 1 3.00 3.25 PHYS WIN 2.00 0.00 -2.00 43 5/25/2022 IND 3 1.00 4.60 1.07 1 3.00 3.25 HATC WIN 6.00 0.00 -6.00 45 5/25/2022 IND 5 1.00 2.20 1.08 1 3.00 3.25 HATC WIN 5.00 0.00 -5.00 44 5/25/2022 IND 5 1.00 34.20 1.07 1 3.00 3.25 PHYS WIN 2.00 0.00 -2.00 53 5/25/2022 MNR 5 1.00 2.90 1.07 1 3.00 3.25 HATC WIN 4.00 0.00 -4.00 54 5/25/2022 MNR 7 1.00 4.40 1.08 1 3.00 3.25 HATC WIN 4.00 0.00 -4.00 49 5/25/2022 PEN 4 1.00 10.70 1.08 1 3.00 3.25 PHYS WIN 2.00 0.00 -2.00 36 5/25/2022 PHA 1 1.00 1.70 1.05 1 3.00 3.25 HATC WIN 4.00 0.00 -4.00 47 5/25/2022 PHA 9 1.00 3.20 1.08 1 3.00 3.25 AGAME WIN 6.00 25.20 19.20 46 5/25/2022 PHA 9 1.00 2.60 1.07 1 3.00 3.00 HATC WIN 2.00 0.00 -2.00 48 5/25/2022 PHA 9 1.00 4.70 1.08 1 3.00 3.25 PHYS WIN 2.00 0.00 -2.00 38 5/25/2022 TDN 4 1.00 1.20 1.06 1 3.00 3.25 HATC WIN 7.00 15.40 8.40 37 5/25/2022 TDN 4 1.00 9.60 1.07 1 3.00 3.25 PHYS WIN 2.00 0.00 -2.00 57 5/24/2022 FLX 2 1.00 2.20 1.07 1 3.25 3.00 PHYS WIN 4.00 12.80 8.80 65 5/24/2022 FLX 4 1.00 5.30 1.09 1 3.25 3.00 HATC WIN 3.00 0.00 -3.00 64 5/24/2022 FLX 4 0.75 0.75 1.07 2 3.50 3.00 PHYS WIN 4.00 7.00 3.00 58 5/24/2022 FPK 1 1.00 8.80 1.08 1 3.25 3.00 HATC WIN 3.00 29.40 26.40 59 5/24/2022 FPK 1 1.00 1.00 1.06 1 3.25 3.00 PHYS WIN 3.00 0.00 -3.00 62 5/24/2022 IND 1 1.00 6.90 1.09 2 3.25 3.00 AGAME WIN 6.00 0.00 -6.00 63 5/24/2022 IND 1 1.00 3.20 1.09 2 3.25 3.00 PHYS WIN 4.00 0.00 -4.00 66 5/24/2022 IND 5 1.00 12.20 1.09 0 3.25 3.00 HATC WIN 2.00 0.00 -2.00 67 5/24/2022 IND 5 1.00 12.20 1.09 0 3.25 3.00 HATC PLACE 2.00 0.00 -2.00 69 5/24/2022 IND 5 1.00 12.60 1.09 0 3.25 3.00 PHYS WIN 2.00 0.00 -2.00 68 5/24/2022 IND 5 1.00 3.60 1.09 0 3.25 3.00 PHYS WIN 2.00 0.00 -2.00 71 5/24/2022 IND 7 1.00 2.20 1.08 0 3.25 3.00 PHYS PLACE 2.00 0.00 -2.00 70 5/24/2022 IND 7 1.00 2.20 1.08 0 3.25 3.00 PHYS WIN 2.00 0.00 -2.00 75 5/24/2022 MNR 4 1.00 1.30 1.06 1 3.25 3.00 HATC WIN 3.00 6.90 3.90 77 5/24/2022 MNR 5 1.00 9.30 1.08 1 3.25 3.00 PHYS PLACE 2.00 7.40 5.40 76 5/24/2022 MNR 5 1.00 9.30 1.08 1 3.25 3.00 PHYS WIN 2.00 0.00 -2.00 72 5/24/2022 PHA 11 0.40 0.40 1.06 2 3.25 3.00 AGAME WIN 6.00 8.40 2.40 73 5/24/2022 PHA 11 0.40 0.40 1.06 2 3.25 3.00 AGAME PLACE 6.00 7.20 1.20 60 5/24/2022 WRD 1 1.00 2.90 1.07 1 3.25 3.00 PHYS WIN 3.00 0.00 -3.00 61 5/24/2022 WRD 1 1.00 2.90 1.07 1 3.25 3.00 PHYS WIN 3.00 0.00 -3.00 74 5/24/2022 WRD 9 1.00 1.80 1.07 2 3.25 3.00 PHYS WIN 2.00 0.00 -2.00 -------------------------------------------------------------------------------------------------------------------- TOTALS 43 RECORDS COUNTED 141.00 175.90 34.90 -------------------------------------------------------------------------------------------------------------------- By: SQL-F35 Rank Rank Gain Bet Roi Wins Plays Pct Impact 1 10.40 68.00 1.1529 7 17 .4118 1.3620 2 46.10 44.00 2.0477 5 12 .4167 1.3782 3 -6.00 6.00 0.0000 0 3 .0000 0.0000 4 -10.00 10.00 0.0000 0 4 .0000 0.0000 5 -2.60 10.00 0.7400 1 5 .2000 0.6615 6 -1.00 1.00 0.0000 0 1 .0000 0.0000 7 0.00 0.00 0.0000 0 0 .0000 0.0000 8 -2.00 2.00 0.0000 0 1 .0000 0.0000 9 0.00 0.00 0.0000 0 0 .0000 0.0000 10 0.00 0.00 0.0000 0 0 .0000 0.0000 11 0.00 0.00 0.0000 0 0 .0000 0.0000 12 0.00 0.00 0.0000 0 0 .0000 0.0000 13 0.00 0.00 0.0000 0 0 .0000 0.0000 14 0.00 0.00 0.0000 0 0 .0000 0.0000 15 0.00 0.00 0.0000 0 0 .0000 0.0000 16 0.00 0.00 0.0000 0 0 .0000 0.0000 17 0.00 0.00 0.0000 0 0 .0000 0.0000 18 0.00 0.00 0.0000 0 0 .0000 0.0000 19 0.00 0.00 0.0000 0 0 .0000 0.0000