Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Thoroughbred Horse Racing Discussion > General Handicapping Discussion


Reply
 
Thread Tools Rate Thread
Old 11-01-2022, 09:50 PM   #16
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Is it possible Class or anyone else give me a little help in using Solver

I just can't get the hang of it.....


Maybe a little example can help....


I know regression analysis but can't figure Solver out

thx

Mike
BroadwayJoe is offline   Reply With Quote Reply
Old 11-01-2022, 11:58 PM   #17
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 41,810
Quote:
Originally Posted by BroadwayJoe View Post
Is it possible Class or anyone else give me a little help in using Solver

I just can't get the hang of it.....


Maybe a little example can help....


I know regression analysis but can't figure Solver out

thx

Mike
never used it , but because you mentioned it i looked into it.

this may help.

https://www.bing.com/videos/search?q...0DDF&FORM=VIRE
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
formula_2002 is offline   Reply With Quote Reply
Old 11-02-2022, 01:43 PM   #18
Tom
The Voice of Reason!
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 109,299
If you use HTR and not a database, you are missing a lot.
All those export files chock full of data.....
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Old 11-02-2022, 02:14 PM   #19
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by Tom View Post
If you use HTR and not a database, you are missing a lot.
All those export files chock full of data.....
I do use it....but wanted to get Solver to work it
BroadwayJoe is offline   Reply With Quote Reply
Old 11-02-2022, 04:10 PM   #20
classhandicapper
Registered User
 
classhandicapper's Avatar
 
Join Date: Mar 2005
Location: Queens, NY
Posts: 19,137
Quote:
Originally Posted by BroadwayJoe View Post
Is it possible Class or anyone else give me a little help in using Solver

I just can't get the hang of it.....


Maybe a little example can help....


I know regression analysis but can't figure Solver out

thx

Mike
The last time I used it was when I was doing the studies I described above. At the time, I knew Excel fairly well but had no background in solver/regression analysis. I was able to find help videos on Youtube that got me through it. I still have my old spreadsheets, but it has been so long I'm not the guy to guide you through it now. I'd have to relearn what I did the last time. I will probably revisit it again eventually, but I already have to much on my plate.
__________________
"Unlearning is the highest form of learning"

Last edited by classhandicapper; 11-02-2022 at 04:11 PM.
classhandicapper is offline   Reply With Quote Reply
Old 11-02-2022, 07:31 PM   #21
MJC922
Registered User
 
Join Date: Nov 2012
Posts: 1,204
Quote:
Originally Posted by BroadwayJoe View Post
I do use it....but wanted to get Solver to work it
I'm not familiar with what you're using for files or a database. If you can post a csv file I might be able to look at it and then post some basic example. I can't post my own stuff because there's too much in it that I'd rather not bring visibility to. There are several ways of using solver and I highly doubt that I use it as elegantly as some do but might be able to get you thinking about various options. I find there's actually a lot data preparation that I need to make before I can even think about using solver on the data. Some of that can be done in excel, some in access. I don't know if you're familiar with the term discretization? Anything like rankings within the race itself or binary characteristics etc etc, there's truly a myriad number of ways to prepare the data that you have. Solver is all about optimization, not really regression, you're optimizing on win rate, or optimize on ROI, whatever your goal is for what you're looking at. The other thing you need is a big sample, split it, solve on the first sample and when it crushes the sample with a +50% ROI you can calm yourself down real quick when it loses more than takeout on the other sample. **Edit I'm not sure what type of file would be acceptable to post out here in the first place so disregard my request to post any type of CSV file if it violates the rules of the board.
__________________
North American Class Rankings

Last edited by MJC922; 11-02-2022 at 07:42 PM.
MJC922 is offline   Reply With Quote Reply
Old 11-02-2022, 08:43 PM   #22
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 41,810
per Microsoft.

"Put simply, you can use Solver to determine the maximum or minimum value of one cell by changing other cells."

Have I not been doing that for years??
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
formula_2002 is offline   Reply With Quote Reply
Old 11-02-2022, 08:58 PM   #23
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by MJC922 View Post
I'm not familiar with what you're using for files or a database. If you can post a csv file I might be able to look at it and then post some basic example. I can't post my own stuff because there's too much in it that I'd rather not bring visibility to. There are several ways of using solver and I highly doubt that I use it as elegantly as some do but might be able to get you thinking about various options. I find there's actually a lot data preparation that I need to make before I can even think about using solver on the data. Some of that can be done in excel, some in access. I don't know if you're familiar with the term discretization? Anything like rankings within the race itself or binary characteristics etc etc, there's truly a myriad number of ways to prepare the data that you have. Solver is all about optimization, not really regression, you're optimizing on win rate, or optimize on ROI, whatever your goal is for what you're looking at. The other thing you need is a big sample, split it, solve on the first sample and when it crushes the sample with a +50% ROI you can calm yourself down real quick when it loses more than takeout on the other sample. **Edit I'm not sure what type of file would be acceptable to post out here in the first place so disregard my request to post any type of CSV file if it violates the rules of the board.
thank you but what exactly you need....

say i have factor values for fr1 fr2 fr3 and finish position for 1000 horses

is that enough?
BroadwayJoe is offline   Reply With Quote Reply
Old 11-02-2022, 09:07 PM   #24
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,763
Quote:
Originally Posted by formula_2002 View Post
Have I not been doing that for years?
Damn. You are more arrogant and egocentric than a former president you hate so much. I'll write this again, slowly so you can understand: Your research is u-s-e-l-e-s-s. You haven't solved anything in 20 years. That might be a world handicapping record!
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
headhawg is offline   Reply With Quote Reply
Old 11-02-2022, 09:11 PM   #25
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,763
Quote:
Originally Posted by BroadwayJoe View Post
I do use it....but wanted to get Solver to work it
Not trying to be negative, but are you sure Solver is what you want to invest your time in? It doesn't seem like an appropriate analysis tool for handicapping.
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
headhawg is offline   Reply With Quote Reply
Old 11-02-2022, 09:35 PM   #26
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 41,810
Wink

Quote:
Originally Posted by headhawg View Post
Damn. You are more arrogant and egocentric than a former president you hate so much. I'll write this again, slowly so you can understand: Your research is u-s-e-l-e-s-s. You haven't solved anything in 20 years. That might be a world handicapping record!
" . "

words fail me
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
formula_2002 is offline   Reply With Quote Reply
Old 11-02-2022, 09:38 PM   #27
MJC922
Registered User
 
Join Date: Nov 2012
Posts: 1,204
Quote:
Originally Posted by BroadwayJoe View Post
thank you but what exactly you need....

say i have factor values for fr1 fr2 fr3 and finish position for 1000 horses

is that enough?
I guess I could try to do something with that. Just for an example.
__________________
North American Class Rankings
MJC922 is offline   Reply With Quote Reply
Old 11-02-2022, 09:40 PM   #28
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by headhawg View Post
Not trying to be negative, but are you sure Solver is what you want to invest your time in? It doesn't seem like an appropriate analysis tool for handicapping.
That is what I'm trying to find out Brian....

Maybe it doesn't work but I need to be sure and put it behind me ...

I have to check but in that book Precision by Wong mentions Solver

Last edited by BroadwayJoe; 11-02-2022 at 09:42 PM.
BroadwayJoe is offline   Reply With Quote Reply
Old 11-02-2022, 09:45 PM   #29
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by MJC922 View Post
I guess I could try to do something with that. Just for an example.
BroadwayJoe is offline   Reply With Quote Reply
Old 11-03-2022, 11:06 AM   #30
MJC922
Registered User
 
Join Date: Nov 2012
Posts: 1,204
Joe are you planning to provide a file for me to work with as an example?

I would say something like this would be sufficient just for kicks:
date,track,racenum,horse, then whatever ratings you have that represent your paceline for each horse for showing the F1,F2,F3, FinishPosition,Odds to $1

A decent number of races 200, 500? Doesn't matter much it's just an example.

I could probably throw something together with that data this weekend. No real plans except to take my son to do some driving, he finally got his permit.
__________________
North American Class Rankings

Last edited by MJC922; 11-03-2022 at 11:08 AM.
MJC922 is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 11:06 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2023, vBulletin Solutions, Inc.
Copyright 1999 - 2022 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.