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

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


Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average.
Old 01-11-2009, 01:23 PM   #1
Dan H
Registered User
 
Join Date: Dec 2004
Location: San Diego
Posts: 232
Wanted: Microsoft Excel Formula - Quirin Speed Points

Looking for formula(e) to help me automate the calculations of Running Styles and Quirin Speed Points.

Assumptions:

1. Formulae for paper and pencil methods are in the public domain.
2. Data is already imported into Excel from ITS – (no BRIS CSV available).
3. Microsoft Excel 2007 – beginner to intermediate skill level.

No luck with PA search for this info,

Thanks, Dan H
Dan H is offline   Reply With Quote Reply
Old 01-11-2009, 06:42 PM   #2
raybo
EXCEL with SUPERFECTAS
 
raybo's Avatar
 
Join Date: Mar 2004
Posts: 10,206
Quote:
Originally Posted by Dan H
Looking for formula(e) to help me automate the calculations of Running Styles and Quirin Speed Points.

Assumptions:

1. Formulae for paper and pencil methods are in the public domain.
2. Data is already imported into Excel from ITS – (no BRIS CSV available).
3. Microsoft Excel 2007 – beginner to intermediate skill level.

No luck with PA search for this info,

Thanks, Dan H
Do you have the paper and pencil methods?
Do you have the ITS data structure?
How familiar are you with Excel and writing formulas?

I don't use Quirin speed points but if you know how you want them calculated/manipulated there are many here who can write the formulas/macros for you.

To calculate running styles you need to decide how you want to do that before you ask for Excel formulas.
__________________
Ray
Horseracing's like the stock market except you don't have to wait as long to go broke.

Excel Spreadsheet Handicapping Forum

Charter Member: Horseplayers Association of North America
raybo is offline   Reply With Quote Reply
Old 01-11-2009, 07:05 PM   #3
CincyHorseplayer
Registered User
 
CincyHorseplayer's Avatar
 
Join Date: Jan 2008
Location: Cincinnati,Ohio
Posts: 5,289
I don't think it's something that you really want automated.

There are enough things to be noticed looking through a horses running lines that would get glossed over by an objective selection method.Sometimes a single running line clues you into a horse's capabilities.Or looking through 5-10 lines you get to know the running style personality of a horse when you were simply trying to place him at the 1st call.

Just my 2 cents.I have always adhered to Davidowitz's advice to scan the lines bottom to top,top to bottom and be able to absorb that history at a glance.Most times it's all you need to know.
CincyHorseplayer is offline   Reply With Quote Reply
Old 01-11-2009, 08:43 PM   #4
BIG49010
Registered User
 
BIG49010's Avatar
 
Join Date: Sep 2005
Posts: 1,827
If someone can come up with formula, it would be interesting to check it against the Bris Files which put the data in.
__________________
Every time you are tempted to react in the same old way, ask if you want to be a prisoner of the past or a pioneer of the future.
BIG49010 is offline   Reply With Quote Reply
Old 01-11-2009, 09:51 PM   #5
Dan H
Registered User
 
Join Date: Dec 2004
Location: San Diego
Posts: 232
Quote:
Originally Posted by raybo
Do you have the paper and pencil methods?
Do you have the ITS data structure?
How familiar are you with Excel and writing formulas?
.
QSP rules can be found at:

http://www.free-horseracing-info.com/universalbias.html (Calibration Handicapping site)

The ITS Data Structure can be found at:

http://www.itsdata.com/tech_info/ptd...df_format.html (Post Time Solutions site)

I can write IF, SUM, and other basic formulae. No Visual Basic.

Here's the formula I created to identify a Z-Pattern in a running line:

=IF(AND(AK11>=AL11,AL11<=AM11,AM11>AN11),"ZPAT","" )

Thanks for the responses so far.

Dan H
Dan H is offline   Reply With Quote Reply
Old 01-12-2009, 01:24 AM   #6
LottaKash
Registered User
 
LottaKash's Avatar
 
Join Date: Apr 2008
Posts: 6,843
Quote:
Originally Posted by CincyHorseplayer
Just my 2 cents.I have always adhered to Davidowitz's advice to scan the lines bottom to top,top to bottom and be able to absorb that history at a glance.Most times it's all you need to know.
That would be me......There are many additive and bonus things that have signifcant value, but Bottom/Topping each line is the heart and soul of it for me...... Superior Pace numbers combined with Good Form tells the relevant story.......Making mountains out of mole hills is a great waster of time, in my opinion....Sure you can get those extra few wins, but overall, at what cost ?..Simplicity works best for me, as well.....

best,
__________________
.
"Cursed be the man who puts his trust in man" - Jer 17:5 (KJV)
LottaKash is offline   Reply With Quote Reply
Old 01-12-2009, 02:08 AM   #7
CincyHorseplayer
Registered User
 
CincyHorseplayer's Avatar
 
Join Date: Jan 2008
Location: Cincinnati,Ohio
Posts: 5,289
Quote:
Originally Posted by LottaKash
That would be me......There are many additive and bonus things that have signifcant value, but Bottom/Topping each line is the heart and soul of it for me...... Superior Pace numbers combined with Good Form tells the relevant story.......Making mountains out of mole hills is a great waster of time, in my opinion....Sure you can get those extra few wins, but overall, at what cost ?..Simplicity works best for me, as well.....

best,
Maybe we think alike because we have the same birthday?

I noticed your name above mine on Jan 9

Must say your approach is eerily similar to how I approach the game too.
CincyHorseplayer is offline   Reply With Quote Reply
Old 01-12-2009, 02:15 AM   #8
LottaKash
Registered User
 
LottaKash's Avatar
 
Join Date: Apr 2008
Posts: 6,843
Quote:
Originally Posted by CincyHorseplayer
Maybe we think alike because we have the same birthday?

I noticed your name above mine on Jan 9

Must say your approach is eerily similar to how I approach the game too.
It must be a Capricorn thing........You know dem goats.....Mark Martin also shares that great day as well.....

But, getting back to the original thing, I believe that when you stay focused and are adept at deciphering the running lines and the companion pace's of those races, well then, most everthing else is less, and yet there are those who accomplish the same results but with a mountain of work and scads of numbers to get the same........yeesh, I am too old for the all that drudgery.....

best,
__________________
.
"Cursed be the man who puts his trust in man" - Jer 17:5 (KJV)
LottaKash is offline   Reply With Quote Reply
Old 01-12-2009, 07:00 AM   #9
raybo
EXCEL with SUPERFECTAS
 
raybo's Avatar
 
Join Date: Mar 2004
Posts: 10,206
Quote:
Originally Posted by Dan H
QSP rules can be found at:

http://www.free-horseracing-info.com/universalbias.html (Calibration Handicapping site)

The ITS Data Structure can be found at:

http://www.itsdata.com/tech_info/ptd...df_format.html (Post Time Solutions site)

I can write IF, SUM, and other basic formulae. No Visual Basic.

Here's the formula I created to identify a Z-Pattern in a running line:

=IF(AND(AK11>=AL11,AL11<=AM11,AM11>AN11),"ZPAT","" )

Thanks for the responses so far.

Dan H
I'll see what I can do this evening.

Are the different files in separate locations in Excel? Are the fields already in separate cells in Excel or are they still in comma-delimited format? (I'm assuming, at this point, that you simply "opened" the files in Excel 2007 without using a parsing program to select and order the comma-delimited data)

It might help if you send me a sample file so I can open it in Excel 2007 and then go from there.
__________________
Ray
Horseracing's like the stock market except you don't have to wait as long to go broke.

Excel Spreadsheet Handicapping Forum

Charter Member: Horseplayers Association of North America
raybo is offline   Reply With Quote Reply
Old 01-14-2009, 07:12 AM   #10
raybo
EXCEL with SUPERFECTAS
 
raybo's Avatar
 
Join Date: Mar 2004
Posts: 10,206
I started working out the Quirin speed numbers using a Bris data file and it is quite complicated, but I'll figure it out before long.

You'll have to modify it to work with your ITS data files, but that shouldn't be a problem for you. At first I had thought of putting it all in one huge formula, since you have Excel 2007 and that version allows such a huge formula, but doing it that way was way too complicated so I decided to use several columns to separate some of the "IF" statements to allow a more efficient way of getting all the variables taken care of.
__________________
Ray
Horseracing's like the stock market except you don't have to wait as long to go broke.

Excel Spreadsheet Handicapping Forum

Charter Member: Horseplayers Association of North America
raybo is offline   Reply With Quote Reply
Old 01-14-2009, 12:37 PM   #11
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
Okay... I have been playing with this.

I have the sprints thus far.

Please note that this is just the calculation AFTER you have what you need from the pacelines loaded into a 10-race grid.

http://www.horsestreet.com/BBSImages/QuirinEsPts.xlsx
Dave Schwartz is online now   Reply With Quote Reply
Old 01-14-2009, 12:39 PM   #12
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
Oops... penalty needs work.
Dave Schwartz is online now   Reply With Quote Reply
Old 01-14-2009, 12:46 PM   #13
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
Okay. I think I have it now. Sprints look good. Give it a test.
Dave Schwartz is online now   Reply With Quote Reply
Old 01-14-2009, 07:34 PM   #14
Dan H
Registered User
 
Join Date: Dec 2004
Location: San Diego
Posts: 232
Dave,

Thanks for the help, the link you offer saves to my computer as a zip file that extracts to xml folders and files. If that's by design, then you're miles ahead of me on this.

Dan H
Dan H is offline   Reply With Quote Reply
Old 01-14-2009, 11:36 PM   #15
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
Dan,

Alll I did was save the file. (Excel 2007) I did not zip it.

Were you able to open it? If not, let me know and I will save it in an older version of Excel.

Dave


PS: Let me just put it up as a 2003 file:
http://www.horsestreet.com/BBSImages/QuirinEsPts.xls

I fthis doesn't work for you, I WILL zip it and put it up again.

Last edited by Dave Schwartz; 01-14-2009 at 11:39 PM.
Dave Schwartz is online now   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 08:36 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- 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.