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-03-2022, 04:11 PM   #31
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by MJC922 View Post
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.
Email it?

or

you can do it?

no rush...
BroadwayJoe is offline   Reply With Quote Reply
Old 11-03-2022, 07:10 PM   #32
MJC922
Registered User
 
Join Date: Nov 2012
Posts: 1,204
Email it if it's allowed. I don't know what restrictions are in play tbh. What I outlined in the handful of 'fields' for a csv doesn't seem as if it goes beyond the realm of basic historical info; however if the moderators see it differently we'll have to do things some other way.

I would actually like to post said spreadsheet somewhere afterward so the board members who may be interested in playing around with solver can explore it on their own with more relevant data they may have at hand.
__________________
North American Class Rankings
MJC922 is offline   Reply With Quote Reply
Old 11-03-2022, 07:30 PM   #33
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by MJC922 View Post
Email it if it's allowed. I don't know what restrictions are in play tbh. What I outlined in the handful of 'fields' for a csv doesn't seem as if it goes beyond the realm of basic historical info; however if the moderators see it differently we'll have to do things some other way.

I would actually like to post said spreadsheet somewhere afterward so the board members who may be interested in playing around with solver can explore it on their own with more relevant data they may have at hand.
PM your email please
BroadwayJoe is offline   Reply With Quote Reply
Old 11-04-2022, 10:24 AM   #34
classhandicapper
Registered User
 
classhandicapper's Avatar
 
Join Date: Mar 2005
Location: Queens, NY
Posts: 19,137
Quote:
Originally Posted by MJC922 View Post
I would actually like to post said spreadsheet somewhere afterward so the board members who may be interested in playing around with solver can explore it on their own with more relevant data they may have at hand.
Please do.

That might motivate me to revisit some of the things I was testing a few years back and try to improve on it.
__________________
"Unlearning is the highest form of learning"
classhandicapper is offline   Reply With Quote Reply
Old 11-04-2022, 01:09 PM   #35
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by classhandicapper View Post
Please do.

That might motivate me to revisit some of the things I was testing a few years back and try to improve on it.
Agree!!!
BroadwayJoe is offline   Reply With Quote Reply
Old 11-04-2022, 05:30 PM   #36
Tom
The Voice of Reason!
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 109,299
Quote:
Originally Posted by classhandicapper View Post
Please do.

That might motivate me to revisit some of the things I was testing a few years back and try to improve on it.
+1
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Old 11-04-2022, 05:43 PM   #37
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
This is the file I supplied to MJC..

its derived from my HTR

hope I'm ok putting this up

if not , please take off
Attached Files
File Type: xlsx AQU 2022 Fall.xlsx (204.2 KB, 50 views)
BroadwayJoe is offline   Reply With Quote Reply
Old 11-04-2022, 09:49 PM   #38
MJC922
Registered User
 
Join Date: Nov 2012
Posts: 1,204
I have an example all set to upload based upon your data. Are the moderators ok with it? Mike, CJ? Let me know, I don't want to violate any rules by doing it.
__________________
North American Class Rankings
MJC922 is offline   Reply With Quote Reply
Old 11-05-2022, 08:12 AM   #39
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by MJC922 View Post
I have an example all set to upload based upon your data. Are the moderators ok with it? Mike, CJ? Let me know, I don't want to violate any rules by doing it.
Send it back to me and I'll put it up...

Since mine is still up...if not

I have a new name all set up


"IDONTGIVEUP"

BroadwayJoe is offline   Reply With Quote Reply
Old 11-05-2022, 11:54 AM   #40
Tom
The Voice of Reason!
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 109,299
LOL..remember DEREK2U?
His retred name was PLAN B!
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Old 11-06-2022, 08:34 AM   #41
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Gonna put this up now since Mods have no comment...

It took me some time to grasp it ......

Its more complicated to set up than regression


The key here starts with Solvers "Target"

Once you understand this it's ....Ahhhhhhhh. I get it

The one thing I need to dwell more on is the "constraints" decisions

Once you D/L this ...Go to Solver and let it rip...



Just save a copy of the original if you try things with it


Any comments , please do....maybe some "constraints" talk

Thxs again MJC
Attached Files
File Type: xlsx AQU 2022 Fall - Solver.xlsx (370.2 KB, 53 views)
BroadwayJoe is offline   Reply With Quote Reply
Old 11-06-2022, 09:26 AM   #42
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
There's one thing I see as an issue using this as a template....


Starting with V17 and down....

If you input your own data and the race has a different amount of entries than inputted here

this wont work...I believe
BroadwayJoe is offline   Reply With Quote Reply
Old 11-06-2022, 10:20 AM   #43
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 41,810
Quote:
Originally Posted by BroadwayJoe View Post
There's one thing I see as an issue using this as a template....


Starting with V17 and down....

If you input your own data and the race has a different amount of entries than inputted here

this wont work...I believe
thanks for the file. I was curious how close Solver was to what I have been doing for years. Pretty, pretty, pretty close..I find a few 0f the formula constructs interesting and will try them out.
I use many formula's and macros. Given all of that I still stumble along looking for the ultimate "What IF"

Good Luck

most interesting

v17 =RANK(U17,$U$17:$U$22,0) v17 formula
t17 =IF($P17=1,$J$2,IF($P17=2,$J$3,IF($P17=3,$J$4,IF($ P17=4,$J$5,$J$6))))

thats it.
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
formula_2002 is offline   Reply With Quote Reply
Old 11-06-2022, 10:56 AM   #44
BroadwayJoe
Registered User
 
Join Date: Aug 2022
Posts: 322
Quote:
Originally Posted by formula_2002 View Post
thanks for the file. I was curious how close Solver was to what I have been doing for years. Pretty, pretty, pretty close..I find a few 0f the formula constructs interesting and will try them out.
I use many formula's and macros. Given all of that I still stumble along looking for the ultimate "What IF"

Good Luck

most interesting

v17 =RANK(U17,$U$17:$U$22,0) v17 formula
t17 =IF($P17=1,$J$2,IF($P17=2,$J$3,IF($P17=3,$J$4,IF($ P17=4,$J$5,$J$6))))

thats it.
MJ did add rMLO to this sheet ....

Along with this and V column I mentioned looks like he did stuff outside of this

sheet making it not quite a template but its seems doable to fix ..

Just need time and quiet thoughts to write all the formulas

I plan on adding something like 20 factors to make a template that I can go

forward with...

Mike
BroadwayJoe is offline   Reply With Quote Reply
Old 11-06-2022, 11:16 AM   #45
MJC922
Registered User
 
Join Date: Nov 2012
Posts: 1,204
Correct, this is not a template that you can just import your data into. This is only a simple demonstration of how solver can be setup to do some things with handicapping data.
__________________
North American Class Rankings
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 10:25 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.