Quote:
Originally Posted by Murph
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!