Exclude Races from a table?

[Victor]

From the All_HX4 table, I want to select a group of races which contain what I believe are bad favorites. I will then fire a few queries at ONLY these races and see what happens. Would I be building a new table from the ALL_HX4 table?

Thank you.

[Victor]

The basis query is called "bad favorites"
Select queries tab
Select new
New Queries
Design view
Add, Close
Here's where I am having trouble, if I move all the fields to the grid, and want to choose rF1=1, I get nothing because the original basis query (bad favorites) defined rF1>=5

I'd like to see how the rF1=1 does in my so called "bad favorite" races.

[Rick]

On second thought, I really don't think it will be as easy as I originally thought it would.

NEXT

[Rick]

The only thing that comes to mind that might work is creating a query using your first query and your table together.

Try linking them together just using date, track and race.

The idea is that this will display all the horses in the races selected with your 1st query.

Give it a try and see what you can come up with.

[Rick]

I just tried it and it doen't work. :confused:

[Rick]

I just went back and looked at it and it will work. I just had to make sure the fields displayed were from the table and not from the query.

Now I need to go back and look at how to do the relationships.

[MikeDee]

Victor

Hope you are coming to the seminar, as this is one of the techniques that I will be covering on Wednesday.

Rick's method is the way to do it. First make a query with your false fav's and save it. Now make a new query with hx4 and link it to yoru query by only date track and race.

Here is the key you have to make the 3 lines that join your table and query point from the table to the query.

This wiil give you all of the horses in the races that match. You change the join type by double clickig on the line and you will get a pop up menu. to change the join type from only matching to alll records in the table and only matching in th query.

You must do this with each of the 3 join lines

[Victor]

Thank you Rick :D and Mike Dee

I'm taking a little break now and will be back to work on this later and try your suggestions.

I really do think there has to be something good here ($$$!)

[Rick]

I just did a test of the three choices in the join property.

I found that either leaving at the default or changing it to all the records in the query comes out the same.

Just do not change it to all the records in the table.

[Victor]

Bad Favorites, type 4 (rMLO=1 and nCONT=0)
Since August 03

Total Bets 935
WIN PLACE SHOW
Total Amount Bet 1870.00 1870.00 1870.00
Wins 118 237 357
Pct. 12.62% 25.35% 38.18%
Amount Won 1025.50 1174.90 1240.70
Profit/Loss -844.50 -695.10 -629.30
Pct Profit Loss -45.16% -37.17% -33.65%
Avg. Payout 8.69 4.96 3.48

They really ARE bad!

Now, let's just bet the rF1=1 horse in these races
(not sure where the extra bet came from) . . . in any event,

Total Bets 936
WIN PLACE SHOW
Total Amount Bet 1872.00 1872.00 1872.00
Wins 145 247 342
Pct. 15.49% 26.39% 36.54%
Amount Won 1914.60 1715.90 1519.40
Profit/Loss 42.60 -156.10 -352.60
Pct Profit Loss 2.28% -8.34% -18.84%
Avg. Payout 13.20 6.95 4.44

[Victor]

Total Bets 935
WIN PLACE SHOW
Total Amount Bet 1870.00 1870.00 1870.00
Wins 221 393 533
Pct. 23.64% 42.03% 57.01%
Amount Won 1712.00 1809.40 1826.90
Profit/Loss -158.00 -60.60 -43.10
Pct Profit Loss -8.45% -3.24% -2.30%
Avg. Payout 7.75 4.60 3.43

[Victor]

This time, rF1=1 and rKrat=1

Total Bets 221
WIN PLACE SHOW
Total Amount Bet 442.00 442.00 442.00
Wins 62 90 122
Pct. 28.05% 40.72% 55.20%
Amount Won 436.80 406.80 417.90
Profit/Loss -5.20 -35.20 -24.10
Pct Profit Loss -1.18% -7.96% -5.45%
Avg. Payout 7.05 4.52 3.43

Not bad :cool:

[Victor]

Same races
rF1=1 and rWKSC=1

Total Bets 143
WIN PLACE SHOW
Total Amount Bet 286.00 286.00 286.00
Wins 31 43 61
Pct. 21.68% 30.07% 42.66%
Amount Won 344.80 250.00 267.80
Profit/Loss 58.80 -36.00 -18.20
Pct Profit Loss 20.56% -12.59% -6.36%
Avg. Payout 11.12 5.81 4.39

[MikeDee]

Victor you might want to try your "false fav" logic using rAODD ( the tote favorite). You may find that when the MLO fav is not one of the top HTR favs the public figures it out as well and makes another horse it's fav.

When I bet tris' I look for races where the "near post time fav" (you never are certain who the post time fav is in real time) is not the k1 or K2 or PSCN 1 or HTR 1. What I find is that in these situations the tote fav "out fo the money" finishes increases, and the tri payout can be substantial.

The problem is that in these races the normal HTR factors that win in the 30% range also drop quite a bit in win %, so it is a real challange configuring your tri ticket, but the rewards for getting it right can be huge.

[Victor]

Originally posted by MikeDee
Hope you are coming to the seminar, as this is one of the techniques that I will be covering on Wednesday.
Wish I could make it Mike, hopefully next year . . .

[tomcat]

Victor, if the betting favorite has a Mike or a Krat is <90, I think it has a good chance of being beat. You might want to test it.

[Victor]

Thanks Tomcat.

Don't think I'll be able to test the Mike # because I don't have an export for it, but I can test rAODD=1 and nKrat < 90

Since August 20 2003 and ending 7/10/04

Total Bets 547
WIN PLACE SHOW
Total Amount Bet 1094.00 1094.00 1094.00
Wins 118 209 273
Pct. 21.57% 38.21% 49.91%
Amount Won 769.10 887.20 924.90
Profit/Loss -324.90 -206.80 -169.10
Pct Profit Loss -29.70% -18.90% -15.46%
Avg. Payout 6.52 4.24 3.39

Look's promising in a "bad favorite" kind of way :)