PDA

View Full Version : Exotic wager analysis/Access


MitchS
06-05-2005, 08:46 AM
Hey Guy's,

I am trying to add capabitity, to do some exotic wagering analysis, with my project within Access. It's way over my head :confused: . I would certainly be willing to do a reasonable pay for service job, if someone would want to tackle it.

I had some advise from a non professional programmer who outlined the following....... Still way over my head.. :)

>>>>Step 1 setting the payoff amounts
first step it to get all of the payoffs to the same denomination. In order
to do this I used a table for all the tracks where the payoff for any
exotic is less then $2 and change the payoff to the $2 payoff amout.

Step 2 contender identification

The first thing I did was to identify the horses that I wanted in the
1,2,3, and 4 holes of the exotics. I did with 4 queries. Or spot plays.
A vba module used the queries to mark all ot the selections. by putting a
value in a contender fields

Step 3 determine playable combinations. With a VBA module I then count all
of the contenders and price out all of the possible combinations of the
contenders based on $1 bets.

Step 4 determine winning combinations. Next a vba module goes through all
of the viable tickets and finds the winners. and the payoffs (based on a
$1)

All of the above is put in a table that can be queried or reported on for
win %, ROIs, P/L and the like.<<<<<<


I would like to be able to Query my DB within access for not only Exacta, but Trifectas and superfectas as well. Of course I would be very happy to start out with the exacta. As a simple example, lets say I wanted to look at the top 3 contenters at >=3/1 odds, with the top 5 contenders. That is just one simple Query of many that might want to be tested...


Thanks for any help,

Mitch

sjk
06-05-2005, 09:16 AM
I have never collected the exotic payoff data so I can't help you much. It would take some thought just to develop a reasonable data structure and a means of parsing the winning combinations with all of the exoctic results that different tracks report.

It seems to me that you are on the right track. As with any such project you just have to break it up into enough small pieces and work on them one at a time. None of the steps you have outlined seem undoable. The only thing that makes it tough is if you try to think about more than one small piece at a time.

I don't know anything about VBA; you could as easily do this with simple queries.

MitchS
06-06-2005, 07:34 AM
Thank's sjk... I appreciate the response. Lets see, 240+ views and only one response. I am sure just about every programmer in the place has seen this, so I can think of only 3 reasons for this. 1. Its not possible 2. Its just too much work and the fee may be great 3. I'm just not liked.

Mitch

hurrikane
06-06-2005, 08:10 AM
for me it has nothing to do with being liked Mitch,

email me and we can talk. to be honest my time is teally tight right now,

NoDayJob
06-07-2005, 09:26 PM
See if you can get a copy of "Techniques for the Exacta" by Rod Zieger. Library of Congress Cat. No. 77-91492. It may save you a lot of time and grief.

NDJ

MitchS
06-07-2005, 10:05 PM
Thank you hurrikane and No Day Job for the responses. I'm not sure I ever read "techniques for the Exacta", that I can remember. Actually my techniques are not as questionable as my reporting, and anayalsis, which leads me down this daunting path... :bang:

Mitch

CapperLou
06-08-2005, 08:12 PM
NoDayJob

Could not locate "Techniques for the Exacta" on amazon or alibris. Any suggestions?? I enjoy reading everything I can get my hands on--have the book that was written by professor that hurricane likes--cannot think of his name at the moment.

All the best,

CapperLou

NoDayJob
06-08-2005, 08:36 PM
NoDayJob

Could not locate "Techniques for the Exacta" on amazon or alibris. Any suggestions?? I enjoy reading everything I can get my hands on--have the book that was written by professor that hurricane likes--cannot think of his name at the moment.

All the best,

CapperLou

The last address I had for the publisher, Techpub, Ltd., is P.O. Box 997. Montrose, CA 91020. If that doesn't help, then perhaps posting a "wanted" on some of the other forums might dredge up a copy. Unfortunately, I loaned mine to a friend who died, and when I tried to get it back from the family, they were unable to find it.

Best of luck,

NDJ

osophy_junkie
06-09-2005, 12:07 AM
Library of Congress Cat. No. 77-91492 is a book titled "Your marriage needs three love affairs" by John Allan Lavender. Maybe you got your book titles mixed up?

NoDayJob
06-09-2005, 02:36 AM
Library of Congress Cat. No. 77-91492 is a book titled "Your marriage needs three love affairs" by John Allan Lavender. Maybe you got your book titles mixed up?

Perhaps the catalog card number was misprinted. All I have is a Xerox copy of the inside cover with the number, the publisher's name and p.o. box.

NDJ

hurrikane
06-09-2005, 08:07 AM
I dont' know osphy, sounds like a book about exotics to me

NoDayJob
06-09-2005, 11:40 AM
-------------------------------------------------------------------------

This was the reply I got from the Library of Congress. I didn't check with the copyright office.

NDJ

-------------------------------------------------------------------------
Question History:

Patron: To the Digital Reference Team:
I haven't been able to locate:

"Techniques for the Exacta"

(c) 1978

by Rod Zieger aka A. R. Zieger

LCCN 77-91492

Published by Techpub Ltd.
P.O Box 997, Montrose, CA 91020

Can you help?

Thank you,

Librarian 1: We have looked in our online catalog < http://catalog.loc.gov/ > and a national library database, OCLC WorldCat. (WorldCat is a subscription database showing the holdings of more than 35,000 libraries; it is available at some public and many academic libraries.) We have been unable to find any book as described in your query.

You may want to check with the U.S. Copyright Office at < http://www.copyright.gov/help/ > to see if they have a copy of this book in their copyright collection.

Also, if you have not already done so, you might want to try searching online used/rare book databases, such as Bookfinder < http://www.bookfinder.com/ > or Addall < http://www.used.addall.com >.

Furthermore, there are some book dealer services where you might direct your question. "Stump the Bookseller" is a feature of Loganberry Books, a used/rare book dealer. Go to < http://www.loganberrybooks.com/ >, and click on "Book Stumpers." This is a fee-based research service for people who cannot recall the exact author or title of a book they are seeking. BookSleuth is offered at < http://www.abebooks.com >, another online book dealer. Click on Reading Room and then on BookSleuth where you can post your question. Reference staff at your local library may also have further suggestions.

We hope this information is helpful.

Sincerely,

The Digital Reference Team/KD
Library of Congress





To check the status or the history of your library question(s), go to: http://questionpoint.org/crs/servlet/org.oclc.ask.PatronDirect?&language=1&email=eldoradousa@netscape.net&qid=872874

Please take a moment to fill out a survey at: http://questionpoint.org/crs/servlet/org.oclc.ask.PatronSurveyForm?&language=1&type=ask&qid=872874




Thank you for using the online resources of the Library of Congress.

If you use an email service with a spam blocker please make sure to add the Library of Congress to the list of places that you accept mail from or else you will not receive the answer to your question.

If you wish to send another question please use one of the following forms:

For American Memory Questions use the form at http://www.loc.gov/rr/askalib/ask-memory.html.

For questions relating to the Learning Page please use the question form found at http://www.loc.gov/rr/askalib/ask-learning.html.

For questions relating to virtual programs and services use the form at http://www.loc.gov/rr/askalib/ask-digital.html

For questions for other Library divisions please return to the Ask A Librarian page at http://www.loc.gov/rr/askalib.

Your question will be assigned to a digital reference specialist and you should receive a response within five business days. If, after 5 business days you have not received a response from us, please go to the acknowledgement email that you will receive and reply to it. This will allow reference staff to determine the status of your question and respond to you.

thoroughbred
06-09-2005, 12:44 PM
Maybe this will be of help.

http://www.cynthiapublishing.com/Merchant2/merchant.mv?Screen=PROD&Store_Code=THS&Product_Code=PK-MTE&Category_Code=PACKS

formula_2002
06-16-2005, 03:41 PM
Maybe this will be of help.

http://www.cynthiapublishing.com/Merchant2/merchant.mv?Screen=PROD&Store_Code=THS&Product_Code=PK-MTE&Category_Code=PACKS


A quote from the above web site;

"The exacta offers a wonderful opportunity along with a very big challenge. The exacta pools are larger than the straight pools, yet most players have a difficult time with this compound bet. "

Yes most player may have a difficult time, but the money doesn't seem to.

I have studied exacta boards for years (real time).
I have down loaded live tote's via my programs and watched the public make the adjustment to the payouts minuet by minuet.
General, 10 min to post, perhaps 30% of the combinations are calculated overlays. By the last tick, that percentage is down to almost nothing.

Trying to catch an overlay before the final tick, and have it still be an overlay at payout time is like trying to catch a falling blade.

But try it for your self..

Joe M

CapperLou
06-16-2005, 04:15 PM
Joe:

I agree with you---when is the last time you heard about Dick Mitchell playing exactas on a daily basis--heck--he went back to teaching in AZ.

Trying to catch exacta overlays is usually an exercise in futility!!!

I must admit I play a few of them---but few and far between--it's hard enough getting overlays who cross the wire first.

All the best,

CapperLou