liability/stake

[knot]

anyone know it is possible to set your stake by your max. liability using a excel formula?

[alrodopial]

Hi,

Stake=Liability*(layodds/(layodds-1))-Liab

or

Stake=Liability*(layodds/(layodds-1)-1)

[Bezza]

Hi alrodopial,If i wanted to lay a horse for a total liability of 5% of my bank how would I fire that in excel.

[Mitch]

Isn't.....

Stake = liability / (odds - 1)

... simpler ?

Bezza...

Stake = (bank * 0.05) / (odds - 1)

I think.......

[alrodopial]

Isn't.....

Stake = liability / (odds - 1)

... simpler ?

Bezza...

Stake = (bank * 0.05) / (odds - 1)

I think.......

You're right.

[pau16ixx]

=Liability*(layodds/(layodds-1))-Liab

i post that in the stake column, #NAME? pops up do i need to define Liability? plz help thx.

Paul

[GeorgeUK]

For Mitch's example

Stake = liability / (odds - 1)

Stake = 10 / (6-1)
Stake = 10 / 5
Stake = 2


So if your liability (the amount you are willing to risk) is 10, and the odds are 6
Your stake should be 2

[pau16ixx]

your gonna have to help me a bit here,

iam a newbie with excel ........= liability / (odds - 1), so just say i wanted = 10.00 / (odds - 1), which is a liab of £10 right, where i put that?
into the stake coloumn or? iam confused!

[GeorgeUK]

Yes - into the stake column.

You're working out the stake. the Liability and odds you need to either enter into the formula or have them looking at another cell that has a value. (so odds may be J9 or something, if j9 is a cell with the odds that you want).

[pau16ixx]

i getcha

thx for ya help!

Paul

[warriorfullights]

Nice tip. Thanks for the code. It is really helpful.