Basic ROI Calculation

[Victor]

Using Access 2000 and want to produce an ROI calculation and display it in table form ... like I've seen in other posts. What do I need to do?

[Glen]

Use this one:

http://www.homebased2.com/km/dnl/ricks2.mdb

or just copy and paste the Report within the above link to create a ROI report for your dB.

[Victor]

How do I get this table to execute on a query?
I guess I'm just alot clueless about Access right now.

Glen, here's a 15 Step progressive scheme which you may find interesting:

Step number 1: Bet 2 Step number 9: Bet 8
2: Bet 2 10: Bet 9
3: Bet 3 11: Bet 10
4: Bet 3 12: Bet 12
5: Bet 4 13: Bet 14
6: Bet 5 14: Bet 17
7: Bet 6 15: Bet 20
8: Bet 7
If the Horse Loses, progress one step.
If the Horse pays < $4, no step up, same bet repeated.
If the Horse pays 4 to 4.80, go one step back for next bet.
5 to 5.80, retreat 2 steps
6 to 7.80, retreat 3 steps
8 to 9.80, retreat 5 steps
10 to 10.80, retreat 8 steps back for next bet amount.
12 to 13.80, retreat 11 steps back
$14.00 or more, go back 15 steps.

[Carl]

Hi Victor and welcome.

The ROI report will give a summary for a query you call "ALL_MSA MISC QUERY".

1) If you create a query with wizard using all fields and don't fill them in, you should show a report that shows about a -22% loss for all races.

2) I think Donnie's "How to use Access in HTR" report covers some of this.

So....my advice to you is about what Miss Frizzel tells the kids on Magic School Bus (yeah, I know I need to get out more):
"Get dirty, make mistakes!" (That's how we learn new stuff best I think. I crashed my whole Access Program three times in the first two days I used it hehe.)

later,
Carl

[MikeDee]

Victor, IMO to do what you want to put ROI results in a table and to test your progressive wagers requires the use of VBA. I have a module that builds a ROI table by track, If you want to go there I can send it to you and walk you through geting it running.

Writing code for your progressive beting test will be harder because of the amount of logic that would be required. Have you had sucess with it?

[hurrikane]

Hey Mike...being the lazy person I am..I'd like a copy...:D
Thanks
gparrott5@home.com

[Glen]

Interesting Victor. Did you come up with this yourself? Will have to let it absorb in the mushy matter in my brain a while to figure it all out..

[Cliff]

Mike,

Could you send me a copy of the ROI calculator by track as well please? I was to the point of wanting to test some spot plays by track and couldn't figure out a way to do it other than to get the query to "prompt" me for the track parameter and repeat the process 50+- times. Obviously, your way would be much better.

Thanks,
Cliff


cliffhartnitt@home.com

[Rick]

Cliff,
I use the three query approach, the same used in the longshots report.

One query for totals by track.

A 2nd query for the winners by track.

And a third query for calculated fields.

Queries:
qTot

SELECT LAD_MSA.tTRACK, Count(LAD_MSA.tTRACK) AS [Total Races]
FROM LAD_MSA
GROUP BY LAD_MSA.tTRACK
ORDER BY LAD_MSA.tTRACK;

qLS

SELECT LAD_MSA.tTRACK, Count(LAD_MSA.tTRACK) AS [LS Races], Avg(LAD_MSA.[nWIN$]) AS [AvgOfnWIN$]
FROM LAD_MSA
WHERE (((LAD_MSA.[nWIN$])>=18))
GROUP BY LAD_MSA.tTRACK
ORDER BY LAD_MSA.tTRACK;

qLSbyTrk

SELECT qLS.tTRACK AS TRACK, qLS.[LS Races]/qTot.[Total Races] AS [LS%], [LS%]*[AvgOfnWIN$]*10 AS Rating, * INTO Longshots
FROM qLS INNER JOIN qTot ON qLS.tTRACK = qTot.tTRACK
ORDER BY qLS.tTRACK;

This was the first one I ever did like this. If you try be sure to change the name of the table to yours.

[MikeDee]

hk and cliff....send it to you tue AM

[Cliff]

Thanks Mike.

Thanks to Ricks as well. I'm going to attempt that method as well, although, I don't think my learning curve has caught up to that level yet.

Later,
Cliff

[hurrikane]

Thanks Mike. I'm also thinking of doing something to pull your MikeD number into Access. I'm really impressed with it on dirt. Think I can do something similar to your to the trainer module for that?

[MikeDee]

HK- you don't really need to pull it in just create a calculated field 53% on npow + 47% of of npscan and you have it.

when I bring in the export file I have a query that I run with the calcualted field in it. then I run a vba module to rank it. Next I append this to my daily table and my master table. So it becomes part of my daily routine and jsut another HTR number. I'll include it in the package I send you.

[hurrikane]

thanks mike

[Gramps]

I'm just getting started, and all of this data is mind boggling. Please add me to the list of those who would appreciate any templates that you have. runez@earthlink.net. Thanks.

[MikeDee]

Gramps- Since you are just getting started I would wait awhile on calculated fields and the like, once you are comfortable with the data and running queries we can do more complex things.