curious Posted December 29, 2018 Share Posted December 29, 2018 I've usually used MS Access and Mardi has helped me at times writing the queries. If you can find a DB package that suits, it will allow you, as Mardi says, to run the group by and where clauses etc. and you can test a lot of ideas that way using historic data. I have a couple of other mates that know how to do this stuff that I can turn to. I'm not an IT genius by any stretch but if the data is in there, I can easily get help to extract what I want. Quote Link to comment Share on other sites More sharing options...
FeelTheFear Posted December 29, 2018 Share Posted December 29, 2018 34 minutes ago, mardigras said: FTF, lot's of info there. Have you considered installing some database software on your computer. And then do a bit of teach yourself SQL. There are many free choices around for databases. Just allows analysing the information you have in an easier way. Options like MySQL or Microsoft SQL Express can be installed and used free. Learning SQL. Even just enough to load the data into tables. Then some simple querying to select data with group by and where clauses. If wanting to get more advanced and take up less disk space, you could look to normalise your data. I.e. have different types of data stored in separate tables with identifiers that relate the data together. Separating horses from meetings from races from runners and horse prior starts etc. Just means you don't have to store the same data repeatedly. I understand these things take time. But the main issue with things like spreadsheets, when you want to change something minor, it can become more time consuming compared to changing the same thing in a database query. Thanks mate, yes I have wondered about a more efficient way of doing it. Will have a look at those free SQL. Have used Access many years ago. I only recently taught myself basic formulae including vlookup, have data on different sheets that can be brought into main sheet. This was a triumph for me and I know it isn't the best way of doing things but it was my entry into data processing. The information that I have recorded for HK has all the important info. I need though I don't know how to effectively use it yet. I have found that I can read a race quite accurately without even seeing the race (barring interference etc). I can tell where a horse exerted itself, where it saved energy. Each sectional tells a part of a story. I can tell for instance, where a horse has exerted a 104% effort (par = 100%) over a certain sectional, see how many lengths off the leader it was and compare to each runner, particularly the leader. Is the horse gaining or has the field quickened. I can tell if the winner has gained in the straight by accelerating or has it retained its original momentum and the horses ahead of it have started to weaken. Now, all this may turn out to be useless but I don't mind spending the time doing it as I am very patient and always learn something. I'm never hesitant to throw away any research, even if a lot time has gone into it. I want accuracy. I've always loved data. I love the thrill of the 'chase' Quote Link to comment Share on other sites More sharing options...
FeelTheFear Posted December 30, 2018 Share Posted December 30, 2018 5 hours ago, curious said: I've usually used MS Access and Mardi has helped me at times writing the queries. If you can find a DB package that suits, it will allow you, as Mardi says, to run the group by and where clauses etc. and you can test a lot of ideas that way using historic data. I have a couple of other mates that know how to do this stuff that I can turn to. I'm not an IT genius by any stretch but if the data is in there, I can easily get help to extract what I want. I tried to run the Open Office version of Access but it would not run because it needs Java. I think the Java was blocked by the Chrome browser. I think I need to have another look at how to enable it again. Cheers Quote Link to comment Share on other sites More sharing options...
curious Posted January 4, 2019 Share Posted January 4, 2019 This article is now rather old and probably not for the number phobic. It does however highlight what the research shows about variables might be important and which might not be (mainly the loser BP ones) - see the highlighted sentences. I realise this is based on US racing and it may be different in Australasia. It particularly reinforces what Mardi and others have been trying to point out for the more serious among you, e.g., "The shocker to me was that jockeys, post position, and weight were deemed inconsequential for the most part. The best jockeys were often put on the best horses, and their correlation nullified much of their value." It also indicates how you might translate those variables to percentage chance to then assess where value bets might lie. Sorry for the very long post but hope it helps. Cracking The Horse Racing Code Matthew DonatoJune 6, 2008 Yes, I have been away for quite some time now. I have been saying that I had something worthwhile up my sleeve, but it has not been ready to put into words.....until now. For months I have been researching horse racing. It has not been research to find great horses, jockeys and trainers, although that was an inevitable side effect along the way, or to find a better feel and respect for the tradition, another glorious side effect, but to predict horse races more accurately than the morning line odds, and find the probabilities of each horse coming in first. In other words, I approached horse racing with a gambler's eye, a microscope, a Daily Racing Form, and a calculator, to see just how close I could come to predicting the outcome of a horse race on a regular basis. I completely understand that succeeding in this endeavor could ruin horse racing as it exists. If the tracks cannot make money, then they will no longer hold races. The sport could collapse. Really though, it doesn't have much further to fall. Name the jockey that rode the winner of last year's Kentucky Derby. Name the Horse that won last year's Kentucky Derby. Precisely. I'm sure Street Sense doesn't care that you do not remember him, but Calvin Borel should be upset. Seriously, only the Triple Crown gets people talking, and only a terrible accident like Barbaro can get people to remember a horse anymore. On the other hand, if the betting public shows an interest in the sport......making money has a tendency to do that to people, and then the sport of horse racing will have a revival. Did the MIT blackjack team destroy cards? Absolutely not. In fact, the time following the MIT blackjack team saw resurgence in the game. Horse racing can have that resurgence too, and it won't take a Triple Crown winner to do it. People just need to think they are smarter than the game and believe they can win. The money can be made up to a degree in television ratings and advertising. If people think they have an edge over the house, they will pay very close attention. As soon as the system starts getting beaten, the people in charge of the track will change it. The house is always designed to win. Horse racing will be fine, especially after finding a new casual audience of supporters. They get their rake no matter what. All it takes is a formula that will produce winners with consistency. A formula that can pick horses better than just looking at the morning line odds would make people feel like they have a huge advantage. Now I have my task. The base of my research was academic journals. Curiously enough, there are more than a few scholars who have been enthralled enough by the sport and the math involved to have published there own works on the subject. In “Searching for Positive Returns at the Track: A Multinominal Logit Model for Handicapping Horse Races”, by Ruth N. Bolton and Randall G. Chapman, I found the information that would carry me through this project. Bolton and Chapman set out to find which variables would be most important to consider when evaluating the horses in a race, and predicting the outcome. Their research suggested that "average amount of money earned per race in the current year" and "average speed rating over the last four races" were the two most important factors. "Lifetime win percentage" was also considered a significant variable, but not so much as the first two. The shocker to me was that jockeys, post position, and weight were deemed inconsequential for the most part. The best jockeys were often put on the best horses, and their correlation nullified much of their value. Armed with this new information, it was time to make an equation of my own. I have the variables deemed most important by Bolton and Chapman, and needed to weigh them. In the case of betting on a Maiden race, where none of the competing horses has ever won a race in its life, I decided to change the "lifetime win percentage" to "lifetime in the money percentage", or how many times the horse has finished in the top three in the number of times the horse has competed. (Please note: All of the statistics that I use in this formula can be found in he Daily Racing Form, and you can use this the next time you go to the track.) Of my three important variables, "money earned per race in the current year", and "average speed rating over the last four races" were the most important, while "lifetime win percentage" was significant. To weigh them based on ten, the first two, which I will label "$/race" and "AVSPDRT" were given the value of four, while the last, "LifeWin%" is given the value of 2. 4+4+2=10, and all is right with the world. Each horse is then rated by these past performances in comparison to the other horses in the race. Given, in a three horse race, that horse #1 has an AVSPDRT of 64, horse #2 has an AVSPDRT of 61, and horse #3 has an AVSPDRT of 58. Horse #1 earns 3 points for having the highest AVSPDRT, while horse #2 would earn 2 points and horse #3 would earn 1 point. (If it were a four horse race, the top horse would earn 4 points, a five horse race, 5 points, etc.) This point-based ranking would be done for $/race and LifeWin%. Ok, are we all still together on this one? It's ok to go back and go over that again. It took me a few tries myself. I'd hate for someone to fall astray, get a bad ranking system, and then come back and yell at me because they lost a lot of money. We're good? Moving on then. Let us suggest that the equations were performed for all the horses in an upcoming five horse race. After each horse was given points based on its ranking in those variables, they stand as such: Horse Number__pts from $/race__pts from AVSPDRT___pts from LifeWin% 1________________1______________5_____________1 2________________4______________3_____________5 3________________3______________1_____________2 4________________5______________2_____________4 5________________2______________4_____________2 This is based on an actual race from the Aqueduct on April 24th. The #3 and #5 horses both have a 2 in the last column because they have the same LifeWin%. Now, remember how we weighted the values from before? I wasn't just screwing around with nonsense. Multiply their points in each category by the values they were given earlier. Pts from %/race is multiplied by 4. Pts. from AVSPDRT are multiplied by 4. Pts. From LifeWin% is multiplied by 2. Let us look at how they stack up now. Horse Number__________________New Point Total 1_________________________________26 2_________________________________38 3_________________________________20 4_________________________________36 5_________________________________28 Horse #2 is the favorite, with horse #4 being the second favorite, and the rest of the horses straggling behind. This is your own independent way to calculate the horses on your own. The best part is that now we can take it one step further. With the information you have in that last table, you can calculate what percentage of the total points each horse has, and have a rough estimate of what percentage each horse has of winning the race. In the case of horse #1, it has 26 of a possible 148 points, 17.5%. Should we have it in a table? I say yes. Horse Number________________% chance of winning 1______________________________17.5% 2______________________________25.6% 3______________________________13.5% 4______________________________24.3% 5______________________________18.9% In the case of a small race like this, every horse has a significant chance of winning.Important Note: Morning line odds can also be put into percentages like this. The equation is even easy to remember. Add 1, and then divide 100 by that number. (Example #1 3-1 odds: 3+1=4 100/4=25% chance example#2 (this one is tricky) 5-2 odds: since it’s a two, you add that to 5, then divide the new number by 2........5+2=7 7/2=3.5 100/3.5= 28.57) After all the odds have been converted to percentages, you must add them all together. They will always come out to more than 100%, because the track takes into account their own rake, plus about a one point margin of error per horse in the race. In order to get the percentage back to 100, divide 100 by the sum of the morning line odds percentages. (Example: if the sum of the morning line odds percentages is 125, then 100/125 =.8. Multiply all the morning line odds percentages by .8 to find their true value. (Example: 25% becomes 20%) Now you can compare the track percentages to our own, to see which horses you feel differently on. If you have a horse that you feel has a 35% chance to win, and the track is giving it a 25% chance to win, you will make more money betting on it correctly than you would if you were betting correctly on a horse that the track felt was better than your evaluation. Finally, when betting exotically, such as exactas, trifectas and superfectas, take into account each horse's "lifetime in the money percentage". A horse may not win many races, but often finish in the top 3. That horse, even if it ranks lowly on your list of winners, may need to be put in your exotic bet, and forgetting those horses could cost you. Also, if after all this analysis, you are still deadlocked on which horse is the favorite, and then go to the jockeys and trainers. In a close race, a better jockey could make the difference. Even if they had been an afterthought until now, you would be wise not to forget them when you need just one more variable. Now that I made you read the entire thing without telling you if it works, allow me to say.........kind of. I have only tested it over the course of nine races, and much more data needs to be collected. It is basically a lock that I will be running this strategy everyday that Saratoga is open, and a definitive answer should be ready by the beginning of September. Until then, I'll let you know that over the course of nine races at the Aqueduct, my strategy yielded more horses finishing in the money three times, the morning line odds yielded more horses finishing in the money four times, and we had the same number of horses finish in the money two times. My total number of horses finishing in the money over the course of the day was 14 of a possible 27, (one was a technicality, because I picked the 1A horse and the 1 horse placed, but since they are tied together, I would have still gotten the money), and the morning line odds had 14 1/2 of a possible 27 horses finish in the money, (they get a half point because in the second race, three horses scratched, leaving four to run. The morning line odds gave their bottom two horses the same odds. Both finished in the bottom two, but since one had to be third, they were right on a technicality.) So with a technicality on both sides, the track beat my number of in the money selections by 1/2. Only time and more races can really determine which system is really better, and since I have time to tweak mine before Saratoga, I am feeling pretty good about coming out on top. If this all works out, and people get wind of my system and start using it, racing could find the interest it has been losing slowly since Affirmed last won the Triple Crown in 1978. If I were you, I'd back this horse to win. Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 15, 2019 Share Posted January 15, 2019 Hilarious stuff again wee C So presumably you inserted the YELLOW text in reference to my Blue Print Their research suggested that "average amount of money earned per race in the current year" and "average speed rating over the last four races" were the two most important factors. "Lifetime win percentage" was also considered a significant variable, but not so much as the first two. The shocker to me was that jockeys, post position, and weight were deemed inconsequential for the most part. The best jockeys were often put on the best horses, and their correlation nullified much of their value. Its funny how my 'superior form in superior races' directly translates to better Stakemoney earned...and how Black Type superior form....usually always have better 'speed ratings' than normal rating races But you'd be too ignorant to pick that up... I also ignore Jockeys and post position...but not post race if caught 'without cover' scenarios as you well know So pretty much that ticks all the BP's boxes who the f knew? Not you Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 15, 2019 Author Share Posted January 15, 2019 1 hour ago, Thomass said: Hilarious stuff again wee C So presumably you inserted the YELLOW text in reference to my Blue Print Their research suggested that "average amount of money earned per race in the current year" and "average speed rating over the last four races" were the two most important factors. "Lifetime win percentage" was also considered a significant variable, but not so much as the first two. The shocker to me was that jockeys, post position, and weight were deemed inconsequential for the most part. The best jockeys were often put on the best horses, and their correlation nullified much of their value. Its funny how my 'superior form in superior races' directly translates to better Stakemoney earned...and how Black Type superior form....usually always have better 'speed ratings' than normal rating races But you'd be too ignorant to pick that up... I also ignore Jockeys and post position...but not post race if caught 'without cover' scenarios as you well know So pretty much that ticks all the BP's boxes who the f knew? Not you Except 'usually' means not always. And 'usually' is a massive exaggeration. The reality is they don't work that way 'usually'. But you just blindly believe that they 'always' do - since you don't use times, don't know what the class benchmarks are, are incapable of working out the difference between a useful performance in black type and one that isn't (Remember Firebird Flyer). And the blue print blindly operates that way meaning it can't work out a superior performance in lower grade. So you just back the black type horse, and as I have shown, they are poor performers from a punting perspective because of all the people that think just like you. Idiots. And then you wonder why you lose. Quote Link to comment Share on other sites More sharing options...
curious Posted January 15, 2019 Share Posted January 15, 2019 10 hours ago, Thomass said: I also ignore Jockeys and post position...but not post race if caught 'without cover' scenarios as you well know Yes, the variables you consider post race are always correlated with winners. Quote Link to comment Share on other sites More sharing options...
curious Posted January 15, 2019 Share Posted January 15, 2019 There's no doubt that your post race wisdom is outstanding Thommo. Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 16, 2019 Share Posted January 16, 2019 Do you two ever give up with your nonsense? Just think for a minute...your attention spans If my BP includes 'career best performances'...you know..that means superior Black Type/Premier form beats other form...almost every time ...rubber stamped by those stupid Breeders..who believe the Black Type effort warrants...Catalogued BLACK TYPE...wtf knew? And the VALUE component in moi's BP incrementally increases as the price lengthens... ...and taking into account stupid shit like 'without cover, slow out, unlucky, unsuitable conditions'.... ...and I use proven Benchmarked protocols wrt those... ...which you half wits can't even begin to contemplate And that's why yous two resonate with Magoo...the funny as f blind guy Quote Link to comment Share on other sites More sharing options...
barryb Posted January 16, 2019 Share Posted January 16, 2019 Hey dumb fark, do we back the 3yr olds now, it’s January. Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 16, 2019 Author Share Posted January 16, 2019 9 minutes ago, Thomass said: Do you two ever give up with your nonsense? Just think for a minute...your attention spans If my BP includes 'career best performances'...you know..that means superior Black Type/Premier form beats other form...almost every time ...rubber stamped by those stupid Breeders..who believe the Black Type effort warrants...Catalogued BLACK TYPE...wtf knew? And the VALUE component in moi's BP incrementally increases as the price lengthens... ...and taking into account stupid shit like 'without cover, slow out, unlucky, unsuitable conditions'.... ...and I use proven Benchmarked protocols wrt those... ...which you half wits can't even begin to contemplate And that's why yous two resonate with Magoo...the funny as f blind guy Simple question then, why do you not win overall. You don't, it is known. And yet I do. And can prove it. How is that possible for me to win given every single element of your blue print is ignored by me. In fact, I bet against it. Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 16, 2019 Share Posted January 16, 2019 11 hours ago, barryb said: Hey dumb fark, do we back the 3yr olds now, it’s January. Wtf...are you still here?? Every horseman....including bogan ones Know 3yo's are up against it racing older horses early in the season Rubber stamped by the fact they receive a sliding allowance as the season progresses... Then they mature...unlike bogans...who never do Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 16, 2019 Share Posted January 16, 2019 11 hours ago, mardigras said: Simple question then, why do you not win overall. You don't, it is known. And yet I do. And can prove it. How is that possible for me to win given every single element of your blue print is ignored by me. In fact, I bet against it. It's simply bizarre how you keep claiming you have access to my accounts Are you a hacker...but you've got the wrong account holder McFly? Ive provided actual evidence of my account...WINNING ...and then there was the recent TIPPING MASTERCLASS I spanked you with Trifecta, Quinella, winner....ALL IN ONE Then the elephant in the room YOU DONT HAVE THE INTELLIGENCE TO WIN IN NZ And you have the emotional intelligence of a 2yo... They keep repeating themselves as well Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 16, 2019 Author Share Posted January 16, 2019 (edited) I have never claimed to have access to your accounts. But I still know you don't win 'overall'. One day of winning after 9 months, a losing day on this site and 9 selections on race chat between $3 and $5 - all losers. Everyone knows you don't win. You just write fairytales. They're your life. Sad, but true. Edited January 16, 2019 by mardigras Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 16, 2019 Share Posted January 16, 2019 Imagine this scenario An up and comer.....produces a career best performance in a Black Type race Albeit in a slower time...due to the fact it was either slow out, blocked, or wide without cover I have that covered...you don't Its just that simple simpleton You Magoo...me x Ray vision Superman Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 16, 2019 Author Share Posted January 16, 2019 29 minutes ago, Thomass said: Imagine this scenario An up and comer.....produces a career best performance in a Black Type race Albeit in a slower time...due to the fact it was either slow out, blocked, or wide without cover I have that covered...you don't Its just that simple simpleton You Magoo...me x Ray vision Superman I don't need to. If it was its first start, all you've done is made 100% subjective decisions about what it would have done otherwise. Likely wrong. And the best part, all the others like you will punt it next time to massive unders allowing the rest to find value elsewhere, all because you think black type meant something. If it wasn't its first start, I already have performance data for the horse. I don't do subjective. Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 16, 2019 Share Posted January 16, 2019 Oh of course...most have their first starts in a BP race.... IDIOT Take yesterday...I had EASY M'LADY finishing within a length of MEDIA SENSATION in the G1 After her wide barrier, set weights, G1 and unsuitable track considerations Back to a small field...mid weak NEXT UP the same an excellent close 3rd on a Premier day to a 5 win horse...back to mid weak ...on its preferred track...and track condition Its incredible how some so called 'punters' dismiss a neddy's preference for a certain track "Track Specialist" they're called And you don't...Incredible DICKHEAD Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 16, 2019 Author Share Posted January 16, 2019 Still continuing with 'most', 'usually' etc etc. You love generalisations. Stop being such a loser and writer of fairytales. You're driving people away. Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 17, 2019 Share Posted January 17, 2019 I've seen you constantly use the same phrase Of course nothing is ever 100% Im on record many times using the Premier form back to mid weak ...naturally Black Type Both of those runners were well over the odds for mid weak... So you're not going to address the Elephant in the room? Your ignorance of "course specialist"... especially undulating tracks like HQ ignorance is bliss I guess Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 17, 2019 Author Share Posted January 17, 2019 What's a course specialist? Put up my post saying form on the track is useless. It's already included in my assessment of the horse's ability. There's little point discussing anything with you. You still don't even understand why your blue print is flawed. And as I stated, you're a loser not worth reading. Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 17, 2019 Share Posted January 17, 2019 I've a meme like a f in Mammouth... ...that's what you said Didnt have a f in clue how to apply a 'course specialist' into your 'value component' Princess Kereru is one...as opposed to Rodgys...who can't go a yard there I apply a max 50% upgrade in value units at times.... Its basic stuff in NZ.... Dunno about your Grundyguy Quote Link to comment Share on other sites More sharing options...
curious Posted January 17, 2019 Share Posted January 17, 2019 13 minutes ago, Thomass said: I've a meme like a f in Mammouth... ...that's what you said Didnt have a f in clue how to apply a 'course specialist' into your 'value component' Princess Kereru is one...as opposed to Rodgys...who can't go a yard there I apply a max 50% upgrade in value units at times.... Its basic stuff in NZ.... Dunno about your Grundyguy You seem to have had 2 or 3 successful punts in the last few years. Keep it up and see if you can add the 50% at the right times so you can buy some air for the Princess. Quote Link to comment Share on other sites More sharing options...
mardigras Posted January 17, 2019 Author Share Posted January 17, 2019 (edited) 27 minutes ago, Thomass said: I've a meme like a f in Mammouth... ...that's what you said Didnt have a f in clue how to apply a 'course specialist' into your 'value component' Put my post up loser. What's a course specialist? Edited January 17, 2019 by mardigras Quote Link to comment Share on other sites More sharing options...
Thomass Posted January 17, 2019 Share Posted January 17, 2019 Tell us what you think you said about it then... Quote Link to comment Share on other sites More sharing options...
curious Posted January 17, 2019 Share Posted January 17, 2019 (edited) 24 minutes ago, Thomass said: Tell us what you think you said about it then... Tell us what a "course specialist" is then. Is it another one of your gross generalisations and population statistics? Edited January 17, 2019 by curious Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.