Kelly Criterion

[valueman]

Does anyone have a link for a free download of the kelly criterion staking plan for windows XP?

 

[TheGeneral+]

I don't, but should be able to find one online. I did a search on and some good topics came up.



http://forum.therx.com/search.php?searchid=7172

 

[valueman]

thanks for that - if someone could find it for me it would be great. I had a chart derived from the plan on my hard drive but a damn virus has corrupted evrything.

 

[Faceless]

I don't know exactly what you mean, but it's not difficult to make your own Kelly calculator. I am using Excel and that's fine for me

Optimal stake percent = (p*k-1)/(k-1)

Optimal stake percent = percentage from total funds
p = probability for event to happen (0-1)
k = decimal odds for event to win

 

[valueman]

Hi Faceless - not being a mathmetician - could you e-mail me the spreadshhet please?

dhingli@telus.net

 

[Faceless]

I am not a mathematician either, just using other people formulas. I'm using odds only in decimal formats, because it's simple that way. If you would like, I can make a calculator where you can input odds in American format, but i'll make it tomorrow. It's 11PM here and I'm heading to bed. I can use my time at the office to make it tomorrow

 

[valueman]

decimal format is best for me - if you could send me that it would be great

 

[Faceless]

Well, I made new one in both formats. This is just a very simple calculator. If you would like to use American format sheet and it seems like it doesn't work, you probably have to change all: , to ; from column B4

=IF(B3<0,ROUND(1+100/ABS(B3),2),(B3+100)/100)

to

=IF(B3<0;ROUND(1+100/ABS(B3);2);(B3+100)/100)

Lets see does this attachment option work

 

[valueman]

many thanksthe values i had before looked slightly different - so i guess i had an adjusted form

 

[Faceless]

Sorry guys. I should have done this Kelly calculator after I have had slept for a while. Formula is incorrect.

Corrected version here: