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 Racing Discussion


Reply
 
Thread Tools Rate Thread
Old 01-21-2019, 07:11 AM   #1
OverlayHunter
Registered User
 
Join Date: Oct 2003
Location: Columbus, Ohio
Posts: 396
Wager Menu

$1 Daily Double / $1 Exacta / $.50 Trifecta / $.10 Superfecta /
$1 Super Hi 5 / $.50 Bet 3 (Races 1-2-3) / $.50 Pick 5 (Races 1-2-3-4-5)

Listed above are the wagers that were available for a recent GP card.

Is there any source, preferably in csv or text format, for ALL of the wagers on ALL of the cards for each day of racing PRIOR to the races being run?
OverlayHunter is offline   Reply With Quote Reply
Old 01-21-2019, 12:34 PM   #2
ScullyDog
Registered User
 
Join Date: May 2009
Posts: 21
I'm interested in that too.
ScullyDog is offline   Reply With Quote Reply
Old 01-21-2019, 01:33 PM   #3
Jeff P
Registered User
 
Jeff P's Avatar
 
Join Date: Dec 2001
Location: JCapper Platinum: Kind of like Deep Blue... but for horses.
Posts: 5,257
I'm guessing other software programs have something like this too --

If you're operating JCapper in SQL Mode, after running your first Calc Races for the day, you can bring up the SQL Mode UDM Reports Module, and generate one of two canned reports designed just for this.

One of the reports is called Races by Post Time and the other is called Races by Track.

Below is a screenshot showing the Races by Track report for Mon 01-21-2019 where I've scrolled down past the Golden Gate Races to get to R1 for Gulfstream:

Attached Images
File Type: jpg SQLModeRacesByTrack.JPG (147.8 KB, 16 views)
__________________
Team JCapper: 2011 PAIHL Regular Season ROI Leader after 15 weeks
www.JCapper.com
Jeff P is offline   Reply With Quote Reply
Old 01-21-2019, 03:17 PM   #4
Jeff P
Registered User
 
Jeff P's Avatar
 
Join Date: Dec 2001
Location: JCapper Platinum: Kind of like Deep Blue... but for horses.
Posts: 5,257
Quote:
Originally Posted by OverlayHunter View Post
preferably in csv or text format

If you know a little sql, and you know your way around JCapper, it's not terribly difficult to save a sql expression that can be reused to drive an export that creates a .CSV file with the desired info on your hard drive.

The first screenshot shows the SQL Expression Tool in the JCX File Exports Module where I've keyed and saved a sql expression that can be pulled up and reused to create a .CSV file that contains columns for date, track, race, posttime, and wagerlist sorted by date, track, race.

Basically, if you are operating JCapper in SQL Mode, after running your first Calc Races for the day, you'd bring up the SQL Expression Tool in the JCX File Exports Module, pull up the saved sql expression from a drop down (the one in the screenshot is named __WagerList) and hit the Apply button:
WagerListSQLExport1.JPG


The second screenshot shows the JCX File Exports Module after keying a filename for the .CSV file and clicking the Create Export button.

Note that you only need key the filename once. After that, use the Browse button to open up a dialog box (not shown) and select the previously used .CSV file - which gets overwritten with new data each time you hit the Create Export button:
WagerListSQLExport2.JPG



The third screenshot shows the .CSV file itself after opening it in Excel:
WagerListSQLExport3.JPG


If you know what you are doing the whole process only takes a few seconds from start to finish.



-jp

.
__________________
Team JCapper: 2011 PAIHL Regular Season ROI Leader after 15 weeks
www.JCapper.com
Jeff P is offline   Reply With Quote Reply
Old 01-21-2019, 07:08 PM   #5
OverlayHunter
Registered User
 
Join Date: Oct 2003
Location: Columbus, Ohio
Posts: 396
Thanks, Jeff, it gives me food for thought.
OverlayHunter 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 06:03 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.