Author Topic: formula to add commissions  (Read 468 times)

Tags:
  • All members
  • Posts: 47
formula to add commissions
« on: 30 Jun 2020, 14:21 »
hi all, what formula should I use to get commission included in loss recovery plan ?

So in the trigger amount I have (bet_size*IF(test_mode=1, test_funds, total_funds)/100 + (last_lost/(back_price-1))) 

which works but when we get a bigger losing run, the commission 5% means it does quite return the full profit

  • Administrator
  • Posts: 8818
  • Gender: Female
*
Re: formula to add commissions
« Reply #1 on: 03 Jul 2020, 07:30 »
Hello!

So in the trigger amount I have (bet_size*IF(test_mode=1, test_funds, total_funds)/100 + (last_lost/(back_price-1)))
Divide by (1-commission):

(bet_size*IF(test_mode=1, test_funds, total_funds)/100 + (last_lost/((1-commission)*(back_price-1)))) 

By the way, starting from the latest version, the formula can be simplified to:

(bet_size*my_funds/100 + (last_lost/((1-commission)*(back_price-1)))) 
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE