Author Topic: If Formula  (Read 1407 times)

Tags:
  • All members
  • Posts: 57
If Formula
« on: 30 Sep 2014, 05:47 »
Is it possible to use an IF to calculate a bet size?

Im currently using a dutching trigger with recoup, and should the cost of the next wager be greater than balance, I want to spend the balance.

Im trying to use the below, but no luck in the "Amount to Win" variable, where Wager is the amount to win plus the previous loss



if((Wager/Match_b_book)>balance,(balance/Match_b_book),Wager)

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: If Formula
« Reply #1 on: 30 Sep 2014, 06:20 »
hi
when using any excel formula you must use capitals.
also it is better to use the total_funds , this will then cover you if you have an unsettled bet.
set the dutch to  amount to lose, then use this formula.
IF(wager>total_funds,total_funds,wager)

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

 

Please note, BetFair is seems to be currently OFFLINE