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

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

Attached Files

Investment Manager.xls (24.0 KB, 535 views)

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.

__________________
If at first you don't succeed skydiving is not for you.

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