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)

michael gorman 21st September 2010 10:00 AM

Hi Shaun , im having trouble finding the last 3 starts in TVF .
Quote:
Originally Posted by Shaun
This should provide all the formulas you need, depemds where you get your form from i get all of mine from TVF free form with last 3 starts this is all added with copy and past, the fields are copied from the webpage and pasted in, the form is copied from the page then pasted to a text document then i import this.

I then use the ratings listed on the page to automaticly rate the runners.

Shaun 21st September 2010 10:01 AM

You can copy paste the full race information in to a text document then import that to excel, once you have done that you can use formulas to extract the information you need.

At one point i uploaded a sheet to this forum that containd most of the formulas you need, it was an old ratings sheet i was using.

michael gorman 21st September 2010 01:34 PM

Hi Shaun , do you include the weights in your formulas, if so how do you use weights in an effective way.



Quote:
Originally Posted by Shaun
You can copy paste the full race information in to a text document then import that to excel, once you have done that you can use formulas to extract the information you need.

At one point i uploaded a sheet to this forum that containd most of the formulas you need, it was an old ratings sheet i was using.

Shaun 21st September 2010 05:04 PM

I use to include weights but when they increased the minimum weight i found them less effective.

aussielongboat 28th November 2010 10:24 AM

hi all, i cant get this or the unitab grabber to work. with the form ratings cyberhorse wont open up
and with unitab i get this message - even though i have an account:

UNiTAB
Why am I seeing this page?
You have clicked a Runner name and you either,
do not have a UNiTAB Telebet Account; or,
you have not logged into your account for the past 30 days on this computer.
As a free information service available to account holders, UNiTAB.com provides a detailed Form Guide for each runner in each race.
The Form Guide contains in-depth statistics to assist you with your betting decision, including last three starts, historical performance at the track, distance and in the wet plus breeding.
If you have an account and would like to access the Form Guide, login to your account now. That's all it takes.
You are given a 30-day pass to view the guide, whether you are logged in or not. Every time you login, your Form Guide pass is automatically renewed, so, unless you don't login for 30 days, the service is always available.
Don’t have a UNiTAB Telebet Account
If you don't have a UNiTAB Telebet Account, visit the Create a New Account page.
You can be up and running (and viewing the Form Guide) in a matter of minutes.




any hints/guidelines from anyone would be appreciated :)

thank you
aussie



Puntz 9th December 2013 11:19 AM

On post 65 of this thread there is a spreadsheet. It may require by now some tweaking. Hope the original "author" of this excel spreadsheet is around to update it with the current Tatts web site.

It still works, but there are some columns that don't figure.
The VBA coding is a bit advance for me, but the final output is great.
The only other thing that may be considered to add is some sort of variable to include ALL_RACES, or races with CODES_ONLY, such as,
AR, SR, BR, MR, ....ETC.
That way it may not take as long to load up.

Thanks.


All times are GMT +10. The time now is 11:28 AM.

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