Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 30th December 2023, 11:10 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,423
Unhappy 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!
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #2  
Old 22nd January 2024, 04:36 PM
evajb001 evajb001 is offline
Member
 
Join Date: Oct 2009
Posts: 463
Default

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.
Reply With Quote
  #3  
Old 7th February 2024, 09:40 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,423
Default

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.
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #4  
Old 7th February 2024, 09:42 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,423
Default

I should post the formula for others:

=IF(K16="",$L$6*(100%-$L$7),(-K16*$L$6)+($L$6*1))
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 11:05 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655