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 Rate Thread
Old 04-10-2023, 06:07 PM   #1
wiretowire68
Registered User
 
Join Date: Jan 2020
Posts: 366
A Python code

I was given a python code for inserting brisnet past performance into google sheets without doing manually. I am having issues understanding how it works, any programmers willing to help.
wiretowire68 is offline   Reply With Quote Reply
Old 04-10-2023, 06:18 PM   #2
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,944
To understand the code you need to learn Python. If you just want it to work then you need to convert the code into an executable file. Google "auto-py-to-exe" or "PyInstaller".
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
headhawg is offline   Reply With Quote Reply
Old 04-10-2023, 07:33 PM   #3
wiretowire68
Registered User
 
Join Date: Jan 2020
Posts: 366
well the code gets inserted into command prompt and to insert into google sheets, the pdf brisnet file has been saved as a csv file.
wiretowire68 is offline   Reply With Quote Reply
Old 04-10-2023, 08:12 PM   #4
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,944
From your posts, I am not clear as to what the exact problem is. Perhaps someone else can make sense of it.
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
headhawg is offline   Reply With Quote Reply
Old 04-10-2023, 08:32 PM   #5
ranchwest
Registered User
 
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,154
Quote:
Originally Posted by headhawg View Post
From your posts, I am not clear as to what the exact problem is. Perhaps someone else can make sense of it.
I don't understand how the pdf got to be a csv.
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
ranchwest is offline   Reply With Quote Reply
Old 04-10-2023, 09:38 PM   #6
fast4522
Registered User
 
fast4522's Avatar
 
Join Date: May 2004
Location: New Hampshire
Posts: 14,525
Quote:
Originally Posted by wiretowire68 View Post
I was given a python code for inserting brisnet past performance into google sheets without doing manually. I am having issues understanding how it works, any programmers willing to help.
Is it a custom program that a engineer gave you?

Last edited by fast4522; 04-10-2023 at 09:40 PM.
fast4522 is offline   Reply With Quote Reply
Old 04-10-2023, 10:40 PM   #7
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,944
Quote:
Originally Posted by ranchwest View Post
I don't understand how the pdf got to be a csv.
In 2019 a guy wrote a parser for Equibase charts. Apparently it worked too well as Equibase sent him a cease-and-desist order. They even made a change to the pdf files but he made changes to the code to get around the change. I had the parser at one time but not the version that had the fix for whatever changes Equibase made. I can't seem to find the thread in which this was discussed. Maybe it was deleted, I don't remember. Bottom line is that it's possible to do, but requires some software tools and excellent coding skills to pull it off.

Maybe @w2w has some kind of connection. He did write one time that he knew a programmer.
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
headhawg is offline   Reply With Quote Reply
Old 04-10-2023, 10:59 PM   #8
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,943
Quote:
Originally Posted by ranchwest View Post
I don't understand how the pdf got to be a csv.
It sounds like the pdf is converted to a CSV which can then be imported into something else.
Dave Schwartz is online now   Reply With Quote Reply
Old 04-11-2023, 12:13 AM   #9
ranchwest
Registered User
 
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,154
Quote:
Originally Posted by headhawg View Post
In 2019 a guy wrote a parser for Equibase charts. Apparently it worked too well as Equibase sent him a cease-and-desist order. They even made a change to the pdf files but he made changes to the code to get around the change. I had the parser at one time but not the version that had the fix for whatever changes Equibase made. I can't seem to find the thread in which this was discussed. Maybe it was deleted, I don't remember. Bottom line is that it's possible to do, but requires some software tools and excellent coding skills to pull it off.

Maybe @w2w has some kind of connection. He did write one time that he knew a programmer.
I guess I shouldn't assume how much time someone is willing to waste.
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
ranchwest is offline   Reply With Quote Reply
Old 04-11-2023, 10:37 AM   #10
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,944
I don't have the skills, patience, or desire to take on a pdf-to-csv project. And I certainly wouldn't do it out of the kindness of my heart either.

If someone is interested in the tools used and the basic process of how to do the conversion here are links to the chart-parser programmer's page and also to an article outlining the story between the coder and Equibase.

Parsing pdf documents

Cease and Desist
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
headhawg is offline   Reply With Quote Reply
Old 04-11-2023, 06:19 PM   #11
fast4522
Registered User
 
fast4522's Avatar
 
Join Date: May 2004
Location: New Hampshire
Posts: 14,525
Quote:
Originally Posted by headhawg View Post
I don't have the skills, patience, or desire to take on a pdf-to-csv project. And I certainly wouldn't do it out of the kindness of my heart either.

If someone is interested in the tools used and the basic process of how to do the conversion here are links to the chart-parser programmer's page and also to an article outlining the story between the coder and Equibase.

Parsing pdf documents

Cease and Desist
Certainly not on what someone thinks might help them get winners, what the current value in a race is with a selection is more important. Yes I do homework the evening before so anything and everything is ready in a go bag should I decide to go to the casino. Nothing is more important than skipping the right races because of lack of value. How you get there is on you, if you can read the form like a pro software can help spotting value or lack of it. The game is to find weakness and exploit it.
fast4522 is offline   Reply With Quote Reply
Old 04-11-2023, 07:11 PM   #12
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,943
Quote:
Originally Posted by headhawg View Post
I don't have the skills, patience, or desire to take on a pdf-to-csv project. And I certainly wouldn't do it out of the kindness of my heart either.

If someone is interested in the tools used and the basic process of how to do the conversion here are links to the chart-parser programmer's page and also to an article outlining the story between the coder and Equibase.

Parsing pdf documents

Cease and Desist
Great articles.

Amazing code, too.
Dave Schwartz is online now   Reply With Quote Reply
Reply





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
» Current Polls
Which horse do you like most
Dornoch - 67.74%
42 Votes
Track Phantom - 32.26%
20 Votes
Total Votes: 62
This poll is closed.
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 01:29 PM.


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.