OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   Excel Help with Lay Betting (http://forums.ozmium.com.au/showthread.php?t=32269)

Chrome Prince 30th December 2023 10:10 PM

Excel Help with Lay Betting
 
Does anyone have a lay only betting spreadsheet, where you can adjust the commission and stake please?

I've run into trouble and searched everywhere, but there's only back and lay type spreadsheets.

Here's what I've got so far:
J4 = Stake
J5 = Commission
I7 = Either blank (horse did not win) or BFSP odds (horse won)

Current formula is =IF(I7="",$J$4*(100%-$J$5),(-I7-$J$4)+$J$4*2)
Works fine on 7% commission and $1 stake

BUT if I change either the stake or commission% everything goes haywire.

Any help or suggestions gratefully accepted!

evajb001 22nd January 2024 03:36 PM

I think I can do this easy but I usually do the equation for liability as if you're betting BFSP.

Sorry don't check the forum often so not sure if anyone helped you with this already or not. Should be easy enough to solve for a stake amount instead though.

If you haven't solved it yet let me know and ill work it out shouldn't take me long.

Chrome Prince 7th February 2024 08:40 PM

Thanks mate, I didn't even see your post for the last month.
I have it sorted, just had to break it all down and with a little help from Mr Excel got it sorted. Thanks for the offer, much appreciated.

Chrome Prince 7th February 2024 08:42 PM

I should post the formula for others:

=IF(K16="",$L$6*(100%-$L$7),(-K16*$L$6)+($L$6*1))


All times are GMT +10. The time now is 09:50 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.