June Six Through Twelve

[Victor]

Total Bets 59
Place 42
Pct. 71.19%
Amount Won 119.70
Profit/Loss 1.70
Pct Profit Loss 1.44%
Avg. Payout 2.85
Same rules, 2/25/04 through 6/5/04
ALL_MSA Misc Place Query ROI Report
13-Jun-04
Total Bets 604
Total Amount Bet 1208
Place 411
Pct. 68.05%
Amount Won 1203.70
Profit/Loss -4.30
Pct Profit Loss -0.36%
Avg. Payout 2.93

[Victor]

and I do mean place them . . . :)
tDAT tTRK nRAC tPRG tHOR
6/13/04 AP 1 2 Rizzen to Victo
6/13/04 ASD 1 3 Samand
6/13/04 CNL 8 5 One and Done
6/13/04 EMD 2 3 Lady Buccaneer
6/13/04 RUI 2 4 Go Kitty Go
6/13/04 STP 7 7 Ragtime Miss
6/13/04 WO 7 9 Judiths Wild Ru

[Victor]

This may be a pretty good query, but, there are a least a couple of problems:

1) It relies upon rebates to be profitable. There are no rebates with Pinnacle if the price is $2.20 or less on place or show. Of the 411 Place winners, 55 of them paid $2.20 or less.

2) All tracks are not offered by Pinnacle. There may or not be a rebate available for those tracks from other books. Some tracks would need to be omitted for this reason. The biggest payoffs did not necessarily come at the more obscure tracks, although there were two $9.00 plus prices at LBG and MAN. Also, if the bets are not made on-line with Pinnacle, it is possible to bet by phone with them, however, the rebate is 5% instead of 7% on-line. The minimum amount per call is $100.

Just guessing, but that's what we do sometimes :) , I would say drop the number of races bet to 400 because of losing tracks to unavailable status or no rebate. Drop the effective rebate to 5% because of some phone wagering with Pinnacle, no rebates with low price payoffs, and some other lesser rebates from other shops.

If we bet $100 times 400 plays times 5%, then the profit could have been $2000. I'm rich! well maybe not, and I know Ken has made this point more than once, it's a tough grind.

[Victor]

tDAT tTRK nRAC tPRG tHOR nPLA
6/13/04 AP 1 2 Rizzen to Victo $2.40
6/13/04 ASD 1 3 Samand $4.40
6/13/04 CNL 8 5 One and Done $2.80
6/13/04 EMD 2 3 Lady Buccaneer $2.80
6/13/04 RUI 2 4 Go Kitty Go $2.40
6/13/04 STP 7 7 Ragtime Miss $3.20
6/13/04 WO 7 9 Judiths Wild Ru $0.00

[Victor]

Total Bets 7
Total Amount Bet 14
Place 6
Pct. 85.71%
Amount Won 18.00
Profit/Loss 4.00
Pct Profit Loss 28.57%
Avg. Payout 3.00

[Victor]

Total Bets 142
Total Amount 284
Place 101
Pct. 71.13%
Amount Won 284.20
Profit/Loss 0.20
Pct Profit Loss 0.07%
Avg. Payout 2.81

[zimal2]

Victor

I'm trying to figure out how to do a Place bet query. Do you do it with the ROI report template, or the older WPS A1 query, or create a new report with Access. If the latter, how do you do it, and I assume that xfin would be <3

Zim

[Victor]

Actually Zim,

I'm using Rick's original ROI report which I edited to become my place report for the ALL_MSA table.

Do you have a copy of the A1_WinPlaceShow-ROI Report? This would allow you see place results as well as win and show results. Don't add any criteria for xFIN, just be sure that your ALL_MSA Misc Query includes xWIN, xPLA, and xSHO in it's design, then run the A1 report.

[MikeDee]

Z

I will make a place analysis report and put it in the template dB.

Question would you prefer a seprate report

OR

would you like to see s single report with both win and place stats?

[zimal2]

Victor

I have the A1 report. This might be a stupid question, but here goes: If I don't put anything in the xfin criteria box, does the A1 report give stats for the win and place horse, or the win horse, or the place horse only? Does putting in <3 duplicate what's already there?

Mike

Thanks. I guess since the existing ROI report is for win only, I would prefer one for place only.
Seems less confusing. If I figure out A1 I'll then have a separate WPS report. Again, would I assume that a place report would require leaving xfin blank?

Zim

[Victor]

Zim

Here are the A1_WinPlaceShow-ROI results for rK1, June 2004

The ALL_MSA Misc Query fields from the ALL_HX4 table include:
tTRK
tDATE = 6/*/04 (do NOT type in the equal sign, just 6/*/04)
nRACE
tPGM
tHOR
xFIN
xWIN
xPLA
xSHO
rKrat =1 (again, do not type the = sign)

This includes all races all tracks for June 2004

ALL_MSA Misc Query ROI Report
05-Jul-04
Total Bets 5981
WIN PLACE SHOW
Total Amount Bet 11962.00 11962.00 11962.00
Wins 1861 3058 3853
Pct. 31.12% 51.13% 64.42%
Amount Won 10698.00 10747.80 10970.30
Profit/Loss -1264.00 -1214.20 -991.70
Pct Profit Loss -10.57% -10.15% -8.29%
Avg. Payout 5.75 3.51 2.85

[Victor]

Originally posted by zimal2
Does putting in <3 duplicate what's already there?

The xFIN export does not give actual finish position if >=4, it gives all of these a "0"
If you write in <3, you will be excluding the third place finishers and you will get untrue results in the win and place calculations as well because you would also be excluding all races from your report in which rKrat=1 finished third.

You would get the following incorrect results:

ALL_MSA Misc Query ROI Report
05-Jul-04
Total Bets 5117
WIN PLACE SHOW
Total Amount Bet 10234.00 10234.00 10234.00
Wins 1861 3058 3010
Pct. 36.37% 59.76% 58.82%
Amount Won 10698.00 10747.80 8514.70
Profit/Loss 464.00 513.80 -1719.30
Pct Profit Loss 4.53% 5.02% -16.80%
Avg. Payout 5.75 3.51 2.83

[zimal2]

"If you write in <3, you will be excluding the third place finishers"

But I understand that to be exactly what I'm trying to do--that is, the query asks give me all win and place horses that meet the other criteria. What am I missing here?

" and you will get untrue results in the win and place calculations as well because you would also be excluding all races from your report in which rKrat=1 finished third."

That part I do see as the problem in using xfin <3!

Zim

[Victor]

Originally posted by zimal2
That part I do see as the problem in using xfin <3!

Right. Given the export definition, what you'd be saying is: show me all horses who didn't finish THIRD. But the report depends upon an accurate total number of races to calculate the correct win and place percentages. By taking out the xFIN=3 RACES, this is not possible.

[Victor]

ATRpro now allows advance conditional betting with Pinnacle. That's a big plus!

Same Query

June 21 through August 2
All tracks
All races
ALL everything . . .

Total Bets 366
Total Amount Bet 732
Place 252
Pct. 68.85%
Amount Won 725.90
Profit/Loss -6.10
Pct Profit Loss -0.83%
Avg. Payout 2.88

February 25th, 2004, through August 2

Total Bets 1100
Total Amount Bet 2200
Place 754
Pct. 68.55%
Amount Won 2191.90
Profit/Loss -8.10
Pct Profit Loss -0.37%
Avg. Payout 2.91