Data test

[hurrikane]

Glen or Carl...or anyone with a large database and roi calc

can you run the k1 horses at PRM.
also the k1-2 htr1-2 at PRM

first queries I've seen show a pos roi in place and show and a neg in the win.

[Glen]

Hurrikane,

I'm in the process of rebuilding the dB. Don't have PRM in yet. Should have it done in a couple of days. Hopefully, Carl has it avialable.

Glen

[hurrikane]

thanks Glen,
I did find a problem with my data
Now it shows pos roi in w/p/s wondering if it is short term or has held up over time.
Not sure if it will be the same PL1. the modeler has radically different results on pl1 and pl5 for this.

[Carl]

Hurrikane,

Are you O.K. now or do you still want some PRM run?

I have PRM from July to ? last, or this year. There is a thing about PRM where they change quality of horse downward big time in the fall. Please let me know what dates if any you would like run and I'll see what I can do.

Thanks for the post back about the calculator. Can you send me one that works on the basic HTR? That would be easier for me than changing field names (which I could do). As I remember when I merged HTR db and IMPACT db I used the place and show from Impact, the win from HTR.

later,
Carl

[hurrikane]

Carl,
yeah..just curious about the k1s at PRM..I'm showing a lot of juice there and have been playing with success but wondered if it was a short lived thing or maybe something consistent.

I can change the roi calc and shoot it to you. Send my your email

gparrot5@home.com

[MikeDee]

PRM fast dirt all for races Apr - Aug 99, Apr-Sept 00, and Apr to 5/13/01

Fac nWin nBet Win% aMut aBet aWon aP/L ROI
k1 382 1208 32% $5.99 $2,416 $2,290 ($126) -5%
k2 220 1200 18% $8.66 $2,400 $1,906 ($494) -21%
k3 186 1199 16% $11.05 $2,398 $2,055 ($343) -14%
k4 118 1194 10% $15.07 $2,388 $1,778 ($610) -26%
k5 98 1201 8% $18.16 $2,402 $1,780 ($622) -26%
k6 67 1163 6% $27.24 $2,326 $1,825 ($501) -22%
k7 61 1045 6% $30.69 $2,090 $1,872 ($218) -10%


sorry don't have place and show prices in my db
if you want this sliced and diced in any fashiom except with place and show ROI let me know.

[hurrikane]

thanks Carl. that is fine
about the roi report for the nWIN message

Following the old addage of give a man a fish and he eats for a day..teach a man to fish and he drinks for a lifetime....

open the roi report in design mode.
select the wins box with the formula
right click and open properties
the databox comes up...click on the data tab. In control source you will see the formula it uses to calc the roi
whereever you see nWIN change it to nWIN$
check all boxes in the win column...some formulas are longer than you can see so be sure to move the cursor all the way across to get all of the entries.
then save and run. If you still get the message you have missed an nWIN pointer somewhere.
Let me know if that fixes it. I don'thave the p/s roi at home..just at the office so I can send Mon if you can't get it fixed.

[Carl]

Thanks Hurrikane.

I made the changes you recommended, adding $ sign, works good now.

I still can't get column line up right here, I have tried "quote" and "list" in square brackets, still nowhere with the line up stuff.

So I attached my PRM query. It does show less loss for show K1, hope that helps. The data is last years.

later,
Carl