OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   Excel Formula Help (http://forums.ozmium.com.au/showthread.php?t=15977)

Shaun 19th May 2009 11:21 AM

Are you only able to get information from Unitab site, i know a few people that would like it from a couple of others.

kennedy22384 19th May 2009 11:22 AM

Yeah, Unitab is the one stable website I can get the information from. I cant seem to get it elsewhere. tabcorp has made life difficult for everyone else.

Shaun 19th May 2009 11:31 AM

How about some of the bookie sites, i can list a couple maybe you could see if it is possible to get some info, i know the main thing that is needed is the opening prices.

International All Sports
Betchoice

Brendon 19th May 2009 12:19 PM

Sparky12,

post the link and I will have a go.

kennedy22384 19th May 2009 12:47 PM

I can get opening prices from IAS bet but the page does not provide me with enough data to do the ratings method. I can set something up which will simply grab the next race from each meeting and present it in their own tab. Check back with me in a few hours. :)

Brendon 19th May 2009 01:01 PM

Quote:
Originally Posted by kennedy22384
I can get opening prices from IAS bet but the page does not provide me with enough data to do the ratings method. I can set something up which will simply grab the next race from each meeting and present it in their own tab. Check back with me in a few hours. :)
'K.

When you say "opening prices" you mean prices from a particular time, say 10.30 am on the day, right?

BTW, tried your excel program. Superb!

Pauls123 19th May 2009 04:15 PM

Hi Kennedy

What am I doing wrong here. I cant see anywhere to insert the date. Or maybe mine didnt open up correctly,...hmmm?

Paul

Shaun 19th May 2009 04:26 PM

You mayneed to activate macros,


after you have saved the excel file open it then click on "Tools" then "Options" go to the tab "Security" then look for "Macro Security" set it to "Medium"

When you are back on the sheet hit
Press Alt-F8 to bring up the macros window
Select Method260 and press run
Enter the date in YYYY/MM/DD format ie. Today will be 2009/05/19

Pauls123 19th May 2009 08:30 PM

Help..! I have done all that and it works, but how do I get the fields up again..?
They seem to have all vanished somewhere.

Paul

Shaun 19th May 2009 09:02 PM

Do you see the Tabs at the bottom of the excel doc, each one is a race.


All times are GMT +10. The time now is 03:08 AM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.