VB
19th December 2002, 09:29 PM
(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.
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.