Gruss Forum • View topic - Setting a max liability per runner in excel

by **andak fedal** » Thu Aug 04, 2011 10:03 pm

Evening all! I am trying to set a max liability on each horse so that I can prevent some of the huge liabilities I'm racking up!

I have got as far as this to make sure the next liability of the next bet + the existing liability isn't greater than £20 but it still goes above this figure. I think it's because I'm not including unmatched bets. Could anyone help me with calculating this per runner and adding this to my existing formula which is...

=IF((X5-((R5-1)*S5))>=-20,"LAY","")

Thanks!

by **andak fedal** » Fri Aug 05, 2011 2:39 pm

Anyone able to help me calculate total liability per horse using excel or maybe direct me to a thread that might help me?

Pretty please?!

by **2020vision** » Fri Aug 05, 2011 3:48 pm

Does this do it for you...
http://www.gruss-software.co.uk/forum/viewtopic.php?t=1565

Ttfn - Michael :wink:

by **andak fedal** » Fri Aug 05, 2011 4:39 pm

Thanks but it's more complicated than this...

I need to be able to calculate the total liability I currently have in unmatched bets (could bemroe than 1) and add that to the proposed bet I might be making to see if it goes over my limit per horse.

I can calculate the proposed liability but don't know how to go about working out the total in unmatched bets?

by **Captain Sensible** » Fri Aug 05, 2011 5:35 pm

You'll need to be using the MyBets sheet so you can aggregate any total liability of unmatched bets on each selection

by **Captain Sensible** » Fri Aug 05, 2011 5:38 pm

I think garys greenup spreadsheet currently displays the stakes etc for matched bets shouldn't be too hard to tweak it to display unmatched bets

by **andak fedal** » Fri Aug 05, 2011 6:35 pm

Thanks Captain, I'll start with this and have a go at tweaking then.

Cheers

Setting a max liability per runner in excel

Setting a max liability per runner in excel

Who is online

Sports betting software from Gruss Software