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)

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

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.

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

Quote:

Originally Posted by Chrome Prince

Wow Shaun, you're obviously far more advanced than me at this.

My codes are very basic and you have got a much better grasp at getting the info "parsed".

Well done and thanks for the code.

I'll email you a workaround for Cyberhorse as well that may not require code.

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

Quote:

Originally Posted by Shaun

Any formulas that i have or can get for people to extract information or to do what they need in excel i will provide np......i could even create a file that would extract the information you need and show you where you imput your info to creat ratings with out you giving away any information that is private....if anyone needs help let me know.

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