OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - some excel help please (http://forums.ozmium.com.au/showthread.php?t=6808)

Quote:

Originally Posted by makadollar

Hello Shaun, I get my selections based on ratings in the following format.Can you suggest a way or provide a worksheet that I could apply that wil lenable me to match them with actual bets results and profit/loss instead of all the typing out i do every day mate?IT would be fantastic. What I do at the moment is type along side each selection how it went what it paid and what I won lost, qui's etc.

By A Nose - Metro. Race 1, CHELTENHAM 2005, May 28

1st Tip: 1. Delabee

2nd Tip: 5. Jeune Royale

3rd Tip: 6. Pommery Princess

Best Each Way Tip: 1. Delabee

Long Shot tip: 2. Toast to Lenny

Maka

Well as you can see above, the ratings I use and with some settings I apply I come up with this for each race I rate.With the 3 selections and sometimes a longshot suggestion.What I want to do is have this info in a worksheet, add results, prices,bets and calculate whether or not I won on the race.

I also want to be able to search my data to see what a horse has previously done in my records.What are the chances of something like this???

Cheers

Sometimes when comparing the results of one system with the results of another system, it can be hard to say which system is really better. I wanted to find a way to compare system results which incorporates the number of selections, the number of winners and the prices of the selections.

I didn't want to just want to look at the strike rate and the profit on turnover of the system results at face value because (as we know) one system can be focused on just favourites and another can be focused on just longshots. So I have developed a spreadsheet for this purpose. It is an adaption of the USCF (United States Chess Federation) rating formula.

Spreadsheet modification

I have modified the spreadsheet above to allow for a correction.

Quote:

Originally Posted by Glenno

Quote:

Originally Posted by Glenno

I have modified the spreadsheet above to allow for a correction.

Here is another updated version of the spreadsheet I have done.