Mark's Spotplay (Mark #3) / Access Question

[kylelenn]

Greeting all,

First, I have been meaning to e-mail Ken for quite some time as I have been using HTR for the past several months.... I love this product! Everyday I learn something new and just shake my head in amazement! Ken, thank you!

Not sure where to post this question and I do apologize if I have incorrectly started a new thread.... Some folks have commented on a disparity in the number of plays (Mark #3) in Access verse Robot.... I also have the same problem and assumed my data was corrupted in some fashion.

I have found that when I run both $ and $$ in access (nLong>=1) i get a very close match to the "Robot" (using $$ only).... When I substitute $ in the "Robot" (all other criteria the same), I get "zero" plays? I suspect the 8-1 + morning line has something to do with this? Can anyone offer any comment?

Thanks,

Kyle

[AwolAtHTR]

in your Access query, use separate Long 1 and 2 queries, (ie =1 and =2)

IF you get do NOT get zero records, then the Robot result would be in doubt.

duane

[kylelenn]

Duane, thanks for the reply.... I should have mentioned that I had run separate queries in Access and in fact, had individual results for both $ and $$.... When added together they equaled "$$" in Robot.... Not sure why there is a discrepancy?

KL

[km]

kylelenn, welcome to our bbs, it can get confusing. '

Next contest = ROBOT ONLY or HX4 ONLY, not both!

db HX4 query
Use nLONG = 2 for $$ only, nLONG = 1 for $ only
nLONG > 0 will get them both

Robot version 2007 (which version are you using?) now has a AND/OR grouping with the $ and $$. If you check both of them, you should get all the $/$$ in the sample. I just tried it and got the expected result --->

I ran a track with $ alone, then $$ alone, then both. It added up.

LEARN ALL separates the $ and $$ on the output. Try a test without $ or $$ checked, and get the result for $ and $$ respectively on the printout. Then run it again with one or the other checked and see if that matches the result you got the first time.

Try running $ and $$ in various sequences with GET MY PLAYS and then take a look at the individual horses for the correct $, $$ on the HTR Program Screen. They should match. Use GET MY PLAYS to verify any questionable results by inspecting the output with individual horses.

The $ and $$ have a built in MLO >= 6/1. If the MLO criteria is set below 6/1, then the total would be zero plays. But if you set it at 6/1 or higher, there will be no conflict.

[kylelenn]

Ken,

Thanks for responding.... I am running HTR 2007 (version: Jan 15, 2007).... It seems I have a "glitch" in my robot.... I have race files loaded dating back to Oct 1, 2006.... For this test, I selected criteria HTR=1 and $ only and ran "learn all". Out of 10,391 total races, there were zero plays (see attachment marked "A"). Then, I ran "learn all" again selecting only HTR=1 and got zero hits for $ (see attachment marked "B"). Finally, I ran the HTR=1 and nLong=1 query in Access for the same time frame...this resulted in 1028 plays.

When you get a chance, please take a look at this and advise your comments (no rush).

Thanks,

Kyle

I was unable to attach "B".... If needed, I will send via e-mail.

[km]

No glitch kyle' - but it was a little tricky to figure out.

EVERY HTR=1 that is 6/1 up is automatically = $$

So if you select single ($) with HTR=1, it won't find any because they are ALL doubles ($$).

Remember: $ and $$ must be 6/1 up MLO to start with. HTR=1 at 6/1 up is an automatic = $$.

Re-run your Robot on LEARN ALL with HTR=1 (only) and look at the report. You'll see lots of $$, but "$" = 0 plays.

See list below for other automatic $$.

So why would anyone need to run HtR=1 AND $$ together? - as Mark's play did.
Becuase the $$ filters out the HTR=1 that < 6/1. In his case he also added MLO >= 8/1, filtering it slightly more, but as he stated in one of his posts, the MLO filter was largely unnecessary.

Automatic $$, off the top of my head, there may be more
HTR=1
Wk 85+
K=1,2 if MLO 8/1 up
E/P =1 AND Fr1=1,2

Now how did you get Access to give you a query result with the same two items? My guess is you used nLONG > 0, which gets all the $$ too. If you used nLONG=1, it should have been a zero though. Else you may have done the query "$" OR "HTR=1" getting both together. Try the query nLONG =1 AND rHTR=1 and you should get = zero plays.

[kylelenn]

Ken,

Well, I guess the "glitch" is in Access.... As originally stated, when I run HTR=1 and nLong=1, I get 1028 plays. When I run HTR=1 and nLong=2, I get an additional 1345 plays. When run HTR=1 and nLong >0, I get the matching total of 2373 plays.

I have spot checked several examples of the HTR=1 and nLong=1 query, and sure enough, they all show up in the HTR program as $$! The most recent examples were dated Jan 1, 2007.... Regardless, this will not be a problem.

Thanks so much for your earlier explaination.... it makes perfect sense that HTR=1 and ML Odds >=6 would result in the "$$" connotation.

In conclusion, this was the reason I was unable to duplicate Mark's (spotplay #3) number of plays in Access.... I certainly feel better now that I know the reason for this disparity.

Thanks for your time,

Kyle