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 8th March 2018, 07:22 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 728
Default Excel formula help

Lets say on my sheet I am recording results in column A which dont include commission. If I want the result after commission to be calculated into column B next to the result, What would be the formula to make it calculate a 5% commission on a positive result but leave a loss value as it is?

I'm guessing it will be some king of IF statement saying if positive multiply by 0.95, but IF negative value do not multiply and simply populate value with same figure.

ie
ColumnA/columnB
100/95
-100/-100
Reply With Quote
  #2  
Old 8th March 2018, 07:52 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,317
Default

=if(A1<0,A1,A1*.95)
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #3  
Old 8th March 2018, 07:56 PM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 3,711
Default

Quote:
Originally Posted by Shaun
=if(A1<0,A1,A1*.95)


Yep Shaun has it right there. If your using OpenOffice instead of Excel you would just use ; instead of ,

If you are doing it on Aus racing I suggest using the real commission per race which varies. If your not sure then default to 0.935 (6.5% commission) for testing.


To sightly improve it :

=if(A1<0,A1,ROUNDDOWN(A1*.95,2))
Reply With Quote
  #4  
Old 8th March 2018, 08:07 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 728
Default

perfect, thanks guys. Yeah planned on changing race state by state, but didnt want to make to confusing for a start.

Those formulas work perfect for what I am after though.

Cheers!
Reply With Quote
  #5  
Old 8th March 2018, 08:16 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,317
Default

When i am testing i prefer to use 8% if i don't have the exact percentage, If you use a whole number like 6 or 8 or 10 you can use this formula to covert it.
=1-(8/100) this will produce .92
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #6  
Old 8th March 2018, 08:21 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 728
Default

Its amazing seeing the difference even a small change in commission makes when you do a graph of the two lines.

Really makes me think twice now about playing in the NSW markets at 10% base rate.
Reply With Quote
  #7  
Old 8th March 2018, 08:38 PM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 3,711
Default

Quote:
Originally Posted by thorns
Its amazing seeing the difference even a small change in commission makes when you do a graph of the two lines.

Really makes me think twice now about playing in the NSW markets at 10% base rate.


Yes it can make a huge difference but make sure your doing the commission by market. Remember if you had 2 or more horses in the same race then your commission is only on the profit for the race. Makes it a lot harder to work out.
Reply With Quote
  #8  
Old 10th March 2018, 10:21 AM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,868
Default

Those formulae will work. The rise in commission has made Betfair very uncompetitive when you consider that bookies are offering *Goat, Odds boost, enhanced odds etc. Except for the longer end of the market.
__________________
RaceCensus - powerful system testing software.
Now with over 304,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2018
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 09:38 AM.


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