Kelly Criterion Calculator in excel?

[ImNew]

http://www.smartcapper.com/tool_kell...alculator.html

Is it possible to code that into an excel file? I'm using quarter kelly now, would be of less hassle if I have it in my spreadsheet.

Thanks in advance.

[jelly]

[ QUOTE ]
http://www.smartcapper.com/tool_kell...alculator.html

Is it possible to code that into an excel file? I'm using quarter kelly now, would be of less hassle if I have it in my spreadsheet.

Thanks in advance.

[/ QUOTE ]

Kelly in Excel

Fill in the grey parts only. In "Kelly Type", Full Kelly is 1, fractional Kelly is 0.5, 0.25 and so on.

I am using Open Office so I am not 100% sure it works, feedback welcome.

[ImNew]

Thanks a lot [img]/images/graemlins/smile.gif[/img]

[Ganchrow]

[ QUOTE ]
http://www.smartcapper.com/tool_kell...alculator.html

[/ QUOTE ]A much better Kelly calculator is the one I wrote here: http://www.sbrforum.com/Betting+Tool...alculator.aspx

[rjp]

Ganchrow, I wrote that, and yes, yours is much better, seeing as how I rarely make just one bet. [img]/images/graemlins/wink.gif[/img]

Oh, and if you read this, consider adding an option to put in a $ amount for your bankroll. This way I don't have to calculate this by hand! It's a pain in the ass.

[ImStillBen]

[ QUOTE ]
Oh, and if you read this, consider adding an option to put in a $ amount for your bankroll. This way I don't have to calculate this by hand! It's a pain in the ass.

[/ QUOTE ]

There is.

[Ganchrow]

[ QUOTE ]
Ganchrow, I wrote that, and yes, yours is much better, seeing as how I rarely make just one bet. [img]/images/graemlins/wink.gif[/img]

Oh, and if you read this, consider adding an option to put in a $ amount for your bankroll. This way I don't have to calculate this by hand! It's a pain in the ass.

[/ QUOTE ]Yep, just as the Big, Bad Benster said.

Where it says "Starting Bankroll:" just enter in the dollar value. The number of places after the decimal point will dictate the precision of the solution. So if you enter a starting bankroll of "10,000.0000", the output will go to 4 decmimal places.

[rjp]

Amazing. I'm a retard. Thanks. [img]/images/graemlins/smile.gif[/img]

I guess what I was also looking for is a way to see the percentages and dollar amounts at the same time, although I can just go to 100% if I want to do that.

[Thremp]

[ QUOTE ]
Amazing. I'm a retard. Thanks. [img]/images/graemlins/smile.gif[/img]

I guess what I was also looking for is a way to see the percentages and dollar amounts at the same time, although I can just go to 100% if I want to do that.

[/ QUOTE ]

See, its hard to use other people's tools. I'm not the only one who can't figure basic things out [img]/images/graemlins/wink.gif[/img]