Calculated Fields

[Carl]

These are probably the things that I do worst of the things that I want to do.

Could someone type out the calculated field for me for
1) Off odds 1/2 or less of MLO?

I suspect it looks something like ([nodds]<=.5[MLO]). But I don't know.... I wish I could do them better, for some reason I have a hard time with them (calculated fields).

later,
Carl

[fred4now]

Carl, if you are putting this in the nODDs field, you only have to put in <=0.5*[nmlo]

[Rick]

Carl,
If that's not it you are awful close.

Try it, you have the right idea.

[Glen]

<=(0.5*[nmlo]) works when I don't have my tables linked. But I get the following error message when tables are linked:

"the specified field "[nmlo]" could refer to more than one table listed in then FROM clause of your SQL statement."

Any solutions?

[Rick]

Yeah. You just have to list the right table name with the field name.

Something like [ALL_MSA]:[nMLO]

[MikeDee]

glen the other thing that should work in the box jsut below the field box is the table box just right click on it and the table names should appear and you can pick the table that access should use for the nmlo field

[Carl]

Thanks guys,

I hope to play with it in the next few days, any problems/questions I'll post back.

later,
Carl

[Rick]

Carl,
I just tried it. At first I thought you were talking of creating a calculated field. Turns out you just want to use that query expression.

Field: nOdds
Criteria: <=0.5*[nMLO]

for single table

Field: nOdds
Criteria: <=0.5*[ALL_MSA]:[nMLO]

for joined tables.

Good luck with it. I have no idea what you have in mind to use it for.:confused:

[Carl]

Rick,

I have a THEORY (fancy way of saying that I don't know) that my spot plays that go off at 1/2 of MLO or more do better ROI wise than those that get bet up, just wanted to check it.

Glen and George had an interesting similiar thread a few weeks back where they arrived I think at the conclusion that horses going off at a little better than MLO (but not a lot better) were "best bets", all things being equal.

Just fishing for an off odds system that will enhance my spot plays, don't know what I will do if I catch one, since
1) Half the time I am not there to benefit anyway
2) The other half watching the tote gets me so jacked that I can't enjoy my bet anyway.

What is that song about "unanswered prayers" being the best gift of all?

later,
Carl

[Glen]

Carl, I would be interested in your results of how the plays do when going off at 1/2 of MLO.

[hurrikane]

I remember on PAs board someone made the assertion that at tracks with good MLO makers 80% of the winners were within a point or 2 of MLO. Can't remember how he qualified the 'good' MLO makers..if you could also look at it along those lines I'd be interested in what you might find

[Carl]

Glen and Hurrikane,

Will post back what I find.

Why I THINK it will work is the same reason that my horses chosen by more than one spot play perform much better. (Think there maybe something to that TIPS system.)

And that is that the public's "confirmation" of my choice (i.e. their betting it down to 1/2 MLO) might well work as a "futher positive factor for my choice" and improve the ROI on the play, the same way having the horse picked by multiple spots increases the ROI on the play.

Then again, maybe no. I'll post back in either case.

later,
Carl

[Carl]

Follow up Glen requested, about the results of the plays that were bet down to 1/2 or less of MLO.

Ran my spot plays on a year of data (July 1 2000 to June30 2001).

While the win percentage almost doubled on the bet downs, the average pay was cut by a little more than half, leaving this "angle" washy at best.

The raw numbers:

ALL_MSA Misc Query ROI Report
All spot plays.
Total Bets 8166
Total Amount Bet 16332.00
Wins 1024
Pct. 12.54%
Amount Won 19991.30
Profit/Loss 3659.30
Pct Profit Loss 22.41%
Avg. Payout 19.52

ALL_MSA Misc Query ROI Report
All spot plays going off 1/2 MLO or less.
Total Bets 1547
Total Amount Bet 3094.00
Wins 364
Pct. 23.53%
Amount Won 3629.10
Profit/Loss 535.10
Pct Profit Loss 17.29%
Avg. Payout 9.97

later,
Carl