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

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


View Single Post
Old 04-29-2017, 05:38 AM   #7
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Quote:
Originally Posted by Murph View Post
Can you parse the USTA charts?
I did this a few years back but it's a big pain in the ***
I never found a way to collect the charts, which are available for the current 2 weeks, automatically.
Had to get them manually one by one daily,

The Canadian charts are saved when the robot gets the wager results.

If the charts are saved as Excel file types "xls" then the macro in the attached file can parse the info to an Excel worksheet.
I have a version for Canada if wanted.

The macro in this workbook is sloppy at best, never cleaned it up.
It's just an example of parsing the charts. If you want to try it you'll need to change the file type to "xlsm"

Self interest use only!
Attached Files
File Type: xls MinetheCharts.xls (47.5 KB, 13 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
 
» Advertisement
» Current Polls
Wh deserves to be the favorite? (last 4 figures)
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 05:41 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.