That didn't quite work, but you got me experimenting Shaun.

I have to do 2 functions, but it works now.

=IF($M1 <> 0, REPLACE($M1, 4, 1, "."), 0)

this converts (34:41) into (34.41), then in the next column i use:

=IF($N1 <> 0, MID($N1, 2, 5), 0)

thus, giving me 34.41.
This will save me a lot of time, thx mate.

Shaun - have you had any chance to look at the Retirement Plan spreadsheet improvements that were discussed?

No sorry been a little busy......will check it out as soon as i can.....i am not sure of the code i need to use so will post on excel forum to see what they suggest

Hi,

I'm been following this thread with particular interest regarding the retirement staking plan.

Can anyone who uses the plan let me know if it works best with selections that have a high strike rate or lower strike rate eg. S/R 40% and Av Divi $3.00 or S/R 20% and Av Divi $5.50.



Regards

Schooner

Investment manager Update
 

When using this today for the first time i found a formating proble...easy to fix in the original if you know how but a bit of a pain...so i have fixed and updates it

aussieincanada
 

Thank you Shaun for the Investment Manager, I have had a good selection and staking system for some time now, but needed some good book keeping.

Strike Rate. 28.57%
Average Div. $4.99 (dont know how to round it off)
Return on Investment 46.62%

I found a little glitch in it which I rectified with my little knowledge of Excel. It was giving the wrong average dividend.(I just divided it by 2) which probably accounts for the odd dividend.

It is perfect for me, so thank you for sharing, and hope you back many a winner.

It is the perfect Manager.

aussieincanada.

Impressed
 

Every Month I am an Aussie in Somewhere.... sometimes 'Aussie in Nigeria', 'Aussie in Brazil', 'Aussie in Congo', you get my drift...

What I'm really impressed with is the 46% strike rate that an 'Aussie in Canada' can get.

I wonder if he would care to share?

OOOoops, sorry mate, have just reread the post amd it was 46.62% ROI. (Which is still impressive.)

Hi there,I have been using Cyberhorse data for a while now do an aweful lot of typing results and other data.Do you have something that might reduce that? It would be fantastic,I can email you the format it comes in if need be...

Ta

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

shaun 2166 @ hotmail.com


send me some info to look at and a description of what you need

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

System ratings
 

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 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.

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.