Auto trade during the day

[Zenyatta]

Hi Tub,

As an example, say I have $100 in my Betfair account and I place a $100 BACK bet. My Betfair account balance is now $0.

Greening Up normally (manually with BetAngel) is no problem, provided total liability is less than total profit. However, try to use the spreadsheet to do the same thing -GREEN_ALL and then you get the balance exceeded error (it thinks I can't green up because my account balance is 0 and it thinks I can't cover the liabilities of the lay bet?).

P.S You may be right the error message is generated by Betfair. But this is an illustration of the perils of automation. If you don't have sufficient funds to cover the liabilities when trying to green-up, the spreadsheet does the exact opposite of what you want- when the 'error, balance exceeded' message comes through, instead of greening it simply cancels the other side of the bets, leaving you completly exposed.

[ODPaul82]

Cheers TheTub, I never use the stop triggers myself, hence why I got it wrong!

[Morph]

That is an interesting point.

In trying to lay multiple selections, I occasionally get a bet FAILED message of @ exposure calculation in progress, bet not placed @.

Although I have enough deposited to cover the biggest bet, I wonder if there is an exposure size issue.

Has anyone else had the above failure message?

Any theories greatly appreciated.

[LeTiss]

Do you use set stakes, or are you asking Excel to calculate stakes? If so, do you have a rounddown, or roundup command in place? This can lead to bet error/failed messages if it can't calculate stakes correctly

[Morph]

Le Tiss,

Thank You. I think you have hit the nail on the head.

I thought that simply formatting the cell would suffice but I can see that the calculation of stake is returning some very long number strings. However, I am struggling to use the ROUND function within my formulas. If I insert =ROUND(a2,2 at the start of the formula, it keeps telling me I am using a circular reference.

I have tried help searches and I know I am probably being very thick but I can't seem to be able to instruct my formulas to calculate to only 2 decimal places.

Any suggestions or help gratefully received.

Regards,

Morph

[Photon]

I think the main reason why you get 'bet exceed available balance' message when using Excel but not using BA directly is that Betfair calculatess each bets in turn and with Excel execution is delayed by split second means the balance doesn't get updated quickly enough. You may find that your bank balance needs to be about 6 times the maximum p&l exposure to be on safe side.

[Morph]

Thank You Photon. Your theory makes a lot of sense. I will up my balance to see if your suggestion works.