(Excel Web Queries - Racing)

I use Excel web queries to get constant dividend updates from racing websites, that bit is easy. The hardest part was working out how not to lose the previous dividends in the Excel cells when the dividends refreshed/updated.

This is where I have succeeded. I have created some formulas so each time the win/place pools update the previous dividends move across to the next column to allow for the new dividends, this continues until the race is closed. By this time you may have 12 columns of dividends from the time the race opened.

By doing this you can add some simple formulas to these columns of dividends to calculate:
- how much money (win or place) was put on each runner each time the dividend or win/place pools updated.
- The percentage up/down movement between the dividend updates.
- The total win/place pool amount for each runner.
- What percentage of the win/place pool each runner has.
And if you wish you can apply the results from these formulas to Excel graphs to make it look pretty.

This same method is used in these $1,000 - $20,000 programs from the Gold Coast and NSW. Instead of Excel they generally use Visual Basic.

By having Microsoft Office 97/2000 and an understanding of Excel formulas you can save yourself $1,000 - $20,000.

Yes, one day I'll pass on the formulas, but I still want to work out some other formulas and add them to the Excel project.
If anyone can tell me how 'unders' and 'overs' are calculated/formulated it would be much appreciated, I'm only new to racing.

* For webiste copyright reasons I use Excel web queries for personal use only.

Hello VB,

Could you clarify what you mean by "how 'unders' and 'overs' are calculated/formulated".
Do you mean that you want to know the formula, or you want to be able to identify what's an overlay or underlay?

If it's the latter, I don't think you'll get a sufficient answer, as value and the way it is worked out is the crux of any person's betting strategy, and one which you'll find hard to get people to share.
If anyone has calculation of the "TRUE ODDS" correct, I doubt they'd share that information too readily.

Best of luck with you're method.

__________________
Treat your selection and staking methods not with optimism, nor with pessimism, but with realism.

Thanks Equine Investor.

That explains why I couldn't find any answers on the internet.

Regards,
VB

can u please help, i wish to use excel to get current tab pricing so i can scan them i min before race but cannot get page on excel i have tried web query

Most TABs have changed the format of there websites to stop this type of action i only know of one TAB that you can still get this from.... ACT TAB go to the page with the race information on it copy the link then open up an excel page go to Data at the top then get external data then new web query if you are just interested in the prices and not the other junk copy the page link to the top then select "one or more specific tables on page" now this some times changes and i am not sure why but if you put in a 7 on the next line then no formating then hit ok if you get the prices on the page great if you don't go back and change the 7 to a 6 it will work then.....thats all there is....you will get 2 sets of prices the first set not the the ones in [ ] are the prices you want...these are Supa TAB prices so hope that helps

>

[ This Message was edited by: Shaun on 2004-10-22 20:30 ]

Hi Guys,

I have been trying to use web queries in Excel to obtain Sports Betting Prices direct from the web, but, I am struggling to get it to work.

Does anyone have any first hand advice on how to get this process to work?

Are there any other software programs that will do this for me?

Any advice is greatly appreciated.

Cheers,

thebookie

You can download the software that does it all anyway.
This will save you time.
Go to http://www.propun.com.au/racetext.html

Can anyone tell me how I can import the TAB prices from RaceTab into an Excel speadsheet?

Thanks
ATC

Can this program be used for downloading Sports prices though?