Hi, Can anyone tell me how I can obtain Fields in Excel Format?.

I would like to place the fields in excel and apply a formula that will allocate points for each part of the Horses form etc.

If anyone could help me with this please let me know.

__________________
"It's a Great Life if you don't weaken"

Anyone able to direct me where I may be able to find fields in excel format ?.

__________________
"It's a Great Life if you don't weaken"

What you ask is not as simple as that, you can use web query to get the information in to excel but then you need to use formulas to extract the relevant information before you can use your formulas to allocate points.

If you had asked me a month ago i could have provided a sheet to do exactly this but the webpage that i used for this decided to make changes the screwed up my code and i have had no time to fix.

Do you know much about web queries or macros in excel?

Thanks for your reply Shaun, I dont know much about web queries or macros in excel, but I will ask someone who may.

I have just found bestform.com.au which is betselector I believe, maybe I can punch my formula into that and test my rating system, apparently you can place your own formula settings also and test your own system (will see what I find).

I do my own ratings where I manually punch the info into the excel sheet, this is where I was interested in obtaining all the race field info - recent form-course-distance- hometrack etc in excel to reduce the time consuming task of manual input.

If you have any ideas of where we may be able to obtain this I would be keen to know.

__________________
"It's a Great Life if you don't weaken"

There are heaps of freebie fields / form sites now:

RISA - http://www.risa.com.au/

Cyberhorse - http://formguide.cyberhorse.com.au/.../view-form.html

Racenet - http://www.racenet.com.au/racing-form-guide/

Racing and Sports - http://www.racingandsports.com.au/form-guide/


It is possible to write scripts to automagically download a day's form, parse it and save wanted data to a database or directly to an Excel spreadsheet using COM

But... most websites will evolve over time and this can play havoc with your script(s), so you need to be prepared to adapt if necessary.

I use (and highly recommend) Python myself.

aidleo, if you post up an example spreadsheet that details exactly what you want, I'll have a look see what I can come up with. You'd need to install Python on your 'puter.

Cheers

Thanks very much for your reply jazzy,

If you could send me an email to aidleo@yahoo.com I will send you the precise excel sheet I use with the criteria formula.

greatly appreciated

aidleo

__________________
"It's a Great Life if you don't weaken"