[Homer]

For us non-mathematicians, could someone please tell us how to create an excel spreadshhet formula for B = -(sigma^2/2u)ln(r) ?

Go to cell A1, type <font color="blue">Bankroll</font>
Go to cell A2, type <font color="blue">Standard Deviation</font>
Go to cell A3, type <font color="blue">Win Rate</font>
Go to cell A4, type <font color="blue">Risk of Ruin</font>

(Double-click on the vertical line between Column A and Column B to widen Column A)

Go to cell B1, type <font color="blue">=-(B2^2/(2*B3))*ln(B4)</font>
Go to cell B4, then click on Format -&gt; Cells -&gt; Number (Tab) -&gt; Percentage, and click OK

Then, you can mess around with it by entering different numbers for SD, WR and ROR in cells B2 through B4.

To verify that it's working, enter an SD of 11 in B2, a WR of 1 in B3 and an ROR of 1 (this should show up as 1.00%) in B4. Bankroll should then automatically compute and read out as 278.6128.

If you can't get it working, send me a PM and I can make a spreadsheet for you.

-- Homer