Hi All, and specifically Kennedy 22384

I have been following with interest your conversations with regards to using an excel spreadsheet for obtaining racing data from the unitab site. I have the same situation. I was given 2 spreadsheets from a member of this forum also – (I think his name was Peter – don’t know his alias). I have the same spreadsheet that has been outlined, however that spreadsheet actually pertains to gathering historical data for form analysis and trend following. The spreadsheet I have attached (Tomorrow racing today) actually allows you to input the day’s racing date and the venue code (example: MR for Melbourne Races etc). It downloads all the detailed form for the venue you have nominated.

I have been using this spreadsheet, in concert with a spreadsheet I have created (2nd attachment) to analyse each horses current form and rate, sort and price them according to the rating figures derived from this analysis. I can rate a race in 1 minute.

Unfortunately, about 12 months ago, I upgraded to Microsoft Office 7 suite, and at the same time upgraded my PC. My PCs operating system is now Windows 7.

I thought this transition to office 7 and windows 7 was the reason for my spreadsheets not functioning. Maybe not.

Could you possibly have a look, in the first instance the first attached spreadsheet (tomorrow racing today) and see if you can get it to download the detailed form from the unitab site. Currently, the spreadsheet works in a limited way. It downloads the abbreviated form available but not the detailed form.(the spreadsheet should also be populated to the right of column ‘Z’ also). Obviously the ‘Get external Date’ functions are working, however it seems that there is some sort of limiting factor (maybe with the unitab site) that is precluding the detailed form to be downloaded in it’s entirety.

Normally, when this spreadsheet obtains all the detailed form, I minimise it and open my other spreadsheet (KwikPick Form Analysis). All I have to do then is input all the day and race data on the main page (including the race date), then go to the race I want to rate (hyperlinked to the relevant worksheet). Here I only need to input the following in the ‘red’ area: YYYY/MM/DD/XRXX for example: 2010/07/MR05 and press the ‘Get Data’ Button. All the form is then downloaded into this spreadsheet and assessed. I then press the ‘sort and Price the Selections’ button. The horses are sorted in highest rated order and priced accordingly. Too easy!

This aspect has an error in it also (I think it’s a syntax error. I maybe wrong). Can you see if you can fix this also. The macro that pulls the data from the ‘tomorrow racing today’ spreadsheet into each race sheet is called ‘Get Data’, attached to the button with the same name.
I will be very thankful if you can assist me in getting these spreadsheets functioning correctly.

Kind Regards.

gsdanger

Attached Files

	Tomorrow Racing Today.xls (1.05 MB, 3446 views)
	Kwikpick Form Analyser.xls (3.81 MB, 3495 views)

__________________
Garry D.