Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 9th October 2011, 08:39 PM
aidleo aidleo is offline
Member
 
Join Date: Feb 2010
Posts: 142
Default Fields in Excel Format?

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"
Reply With Quote
  #2  
Old 11th October 2011, 08:24 AM
aidleo aidleo is offline
Member
 
Join Date: Feb 2010
Posts: 142
Default

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"
Reply With Quote
  #3  
Old 11th October 2011, 10:41 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

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?
Reply With Quote
  #4  
Old 11th October 2011, 11:28 AM
aidleo aidleo is offline
Member
 
Join Date: Feb 2010
Posts: 142
Default

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"
Reply With Quote
  #5  
Old 11th October 2011, 01:08 PM
jazzy jazzy is offline
Member
 
Join Date: Nov 2010
Posts: 49
Default

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
Reply With Quote
  #6  
Old 12th October 2011, 07:53 AM
aidleo aidleo is offline
Member
 
Join Date: Feb 2010
Posts: 142
Default

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"
Reply With Quote
  #7  
Old 12th October 2011, 10:38 AM
Robot Robot is offline
Member
 
Join Date: Jan 2011
Posts: 27
Default JAZZY

I am very interested in your PYTHON programming. Tried it unsuccessfully from a previous post of yours. Would it be possible for you to email me at bailyhoo@yahoo.com.au so that I may be able to contact you and ask a few questions.Thanks in anticipation ROBOT
Reply With Quote
  #8  
Old 12th October 2011, 09:02 PM
jazzy jazzy is offline
Member
 
Join Date: Nov 2010
Posts: 49
Default

Or you could post the questions to the other thread, perhaps the answers would be useful to others as well?

Cheers
Reply With Quote
  #9  
Old 13th October 2011, 09:56 AM
Robot Robot is offline
Member
 
Join Date: Jan 2011
Posts: 27
Default JAZZY

Thanks for your reply.From memory the previous thread is sometime ago and being a relative new member I have seen posts that bring ones attention to the date of the threads and refrain from replying to the older threads.My question is to open your file and run it in python.I downloaded the python programs you recommended but have trouble opening and running it doing something wrong obviously .

ROBOT

Last edited by Robot : 13th October 2011 at 09:58 AM. Reason: WRONG TITLE
Reply With Quote
  #10  
Old 13th October 2011, 10:42 AM
jazzy jazzy is offline
Member
 
Join Date: Nov 2010
Posts: 49
Default

OK, This might be a longish post -

The Python setup/install programme doesn't seem to set the 'path' environment variable.. I dunno why not, it seems silly to me, and it always catches me out - I keep forgetting to tell new users that they have to set the path manually.

The Path environment variable is a ";" separated list of directories (folders) where the shell will search for an executable (Python.exe in this case)

So....With XP (Win 7 should be the same or similar at least)

Start -> Control Panel -> System
Advanced Tab
Environment Variables button ( near the bottom)

Select Path in the System Variables Scroll box (bottom one)
Click on Edit
Append ;C:\python27 to the value


To test it:

Open a command prompt
type python
you should get something like this:

Python 2.7.? (etc................)
Type "help", "copyright" etc....
>>>

Now test to make sure that the win32 extensions are installed correctly:

Type import win32com

You should get no error


Bingo! you're good to go. Type quit() to exit

Now, to run the script you can double click on the .py file and it should open a command prompt and run,,, but if there's an error it will stop and the command prompt will disappear before you can read what the error was.

Better to open a command prompt, change to the directory where the script is and run it from the command line.


-----------------

As an aside: I _think_ that the Python3.x installs now update the Path environment variable - but Python 3 is NOT backwardly compatible with 2, I'm starting to use 3 - but some of the 3rd party libraries I use haven't been ported over yet.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 12:13 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655