Trigger betting

[domjoly]

How to take the bet partially in excel trigger betting if the full stake*odds amount gives an error that stake exceeds the Betfair balance?

Thanks

[domjoly]

How to take the bet partially in excel trigger betting if the full stake*odds amount gives an error that exposure exceeds the Betfair balance?

Thanks

[domjoly]

Does anyone support this software?

[Captain Sensible]

I'm sure if someone had a clue what you meant they'd have helped.

Maybe try to re write it as it's not clear what you want or are asking - If your stake * Odds exceeds your Betfair balance you need to reduce the odds or the stake because Betfair won't allow you to bet with money not in the account

[Yorkie]

I'm guessing this is for lay bets and at times the stake value set when multiplied by the odds exceeds the Betfair available balance and so the stake needs to be decreased to make the total liability less.

If you have your stake set at a specific amount in the Stake column of your link sheet then move it to an empty cell somewhere else on the sheet and then reference it

Lets say you have moved your fixed stake value to cell Z1 and lets assume you are using A1 as the reference cell when loading your sheet.

In cell S5 you need something like this.

=IF(A5="","",IF($Z$1*(H5-1)>$I$2,$I$2/(H5-1),$Z$1))

=IF(A5 is blank then blank cell, if not then If Fixed Stake Value multiplied by the liability of your Lay Odds, which is Lay Odds minus 1, is greater than Betfair Available Balance then stake is Betfair Available Balance divided by Lay Odds minus 1, if not then stake is Fixed Stake Value.

It's probably a good idea to put a small buffer in so you are never on the total limit of your account so something like

=IF(A5="","",IF($Z$1*(H5-1)>$I$2-10,($I$2-10)/(H5-1),$Z$1))

That would leave £10 or whatever your currency is in your Betfair account. You can change that figure to suit.

Copy the formula down the S column to about row 50 to be certain you cover all runners.

The =IF(A5="","", at the beginning is just to stop you getting an error in rows where there are no runners.

Without seeing your worksheet it's not possible to give specific answers, you may not be asking for available odds for example, but hopefully the above will point you in the right direction. Others on here may have a much better option for doing it too

If I've guessed wrong on what you are trying to do then follow the Captains advise and ask again with more explanation of what you need.

Keith

[rourkem]

Hi domjoly, have you tried Yorkie's suggestion yet?