I think you'll find the StatArb'ers out there consider maths to be a pretty important part of their trading environment. As for be *the* key, well.... there is no *one* key, even the best black boxes have a bloke sitting there with a coffee and a danish checking the lights are on in the morning.
Looking at your spreadsheet, there are two hidden columns, C and D. These must contain other formulae which give the values C2 and D2 from A2 and B2.
So the formula C = Ln(X)/-Ln(Y) is not the whole picture.
The use of -Ln(Y) suggests that Y is always less than 1 in order to give a positive answer, so Y clearly isn't either of the two input values.
If you highlight the whole spreadsheet and then adjust one column width a small amount then columns C and D will appear and are only used to convert percentage wins to a convertable formula between 0 and 1. The reason they are hidden is because there is no input to be placed in them and to prevent confusion for users and that is all.
As said previously the formula does not return a negative result because the - LN is always calculating a number between 0 and 1 which is a converted percentage. If it was greater than 1 then as you say it would give a negative number.
PS I take your point on only 10 trades. It is a while since I did this, in fact many years ago and I think it requires a minimum of 100 trades to be truly effective and also bear in mind that statistical analysis only works effectively on larger numbers. I found it useful for what I did and only put it on the boards to help people as I have nothing to sell.
All I was pointing out was that the formula published by Scrip was not the whole formula.
e.g. To calculate Consecutive Losing Trades, the formula is
C = Ln(A2) / -Ln((100-B2)/100)
"As said previously the formula does not return a negative result because the - LN is always calculating a number between 0 and 1 which is a converted percentage"
Erm, you didn't say this previously and anyway what you say is not the case. The reason for using -Ln is that Column D2 (1-C2) creates a negative result, which has to be reversed to positive in order to give a sensible answer.
And for Scrip, the Priority method of dealing with a formula does not work as you think for division, no matter where you put the brackets.
Without intent I've probably got up everyones noses now, but I think it's important to be clear on the facts. No offence intended.