Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Compound Magic
01 Feb 11 05:51
Joined:
Date Joined: 27 May 06
| Topic/replies: 764 | Blogger: Compound Magic's blog
Not many would do this ~

Lays , 50% of float
Back to win 6.00 and under, a combination of  'Kelly Criterion' and average edge on float.
Back to win over 6.00, Bets are overlay type, chance of winning times 50% of float.

Have been experimenting with excel , using solver and what if scenarios to come up with a Super Staking plan.

My current betting, lays and win bets have only been overlay betting to  10% of float which has been very profitable. However this new super staking,  if applied
to the past ratings that I have supported would have almost trebled my profits.(for the whole of last year)

I decided to put together a spreadsheet to illustrate what happens.

If interested in the Spreadsheet it can be downloaded at ~
http://www.megaupload.com/?d=C2SIPRT6

The file is excel 2007.  If your version of excel is earlier than that,  Formulas and conditional formatting will not work.

Results are from beginning of year 2011.

Would be interested to hear if the download worked.
Click on regular download and when the seconds have ticked by click OK.
Nothing seems to happen but look in your documents and it should be there.
Pause • Switch to Standard View Different Strokes For Different Folks
Show More
Loading...
Report TheSnapper • February 1, 2011 7:31 AM GMT
No doubt...it is rather complex and dubious that it would perform better than Mr. Kelly would. I prefer to keep things simple .... there is a kind of elegance in simplicity.
Report Compound Magic • February 1, 2011 8:04 AM GMT
TheSnapper

As all my bets and lays are at BSP it is not possible to use 'Kelly'. On top of that using 'Kelly' on an average of 7 selections in an event is impracticable.

If there was only one bet per event then 'Kelly' would be the preferred staking if taking a price that is offered.
Report FINE AS FROG HAIR • February 1, 2011 9:47 AM GMT
Complexity rules eh Compound ?
Report Compound Magic • February 1, 2011 9:58 AM GMT
Just another way of skinning a cat!

If nothing else the spreadsheet can show what can be done with a few simple formulas, how to lay out a spreadsheet, how
to keep tabs on performance and as a database for further study.

Party on.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com