Bet Angel spreadsheet status returning ERROR

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
LetsGoAgain
Posts: 11
Joined: Thu Dec 30, 2010 4:59 am

In the BetAngel_1 spreadsheet i have a very simple Bet Rule of

Lay Kill_Fill:True Kill_Delay:4.5 with some small values in Stake & Odds while I am testing

BUT it consistently comes back immediately with a status of ERROR with no other explanation of what the error can be

Any assistance much appreciated
Nero Tulip
Posts: 708
Joined: Wed Apr 15, 2009 5:29 pm

The problem may be in your odds or stakes. Make sure you ROUND() them to 2 decimal places. And apologies for stating the obvious - they need to be above £2. Your odds will need to be exactly one of the Betfair accepted increments too, often either of these are easily overlooked if you have a spreadsheet doing things automatically. Your bet instructions look fine to me.
LetsGoAgain
Posts: 11
Joined: Thu Dec 30, 2010 4:59 am

Thanks for your reply
I am aware of rounding the odds to be in the ACCEPTABLE range which the spreadsheet calculates automatically and the minimum stake ($5 in Australia) but the problem appears to be with the KILL_FILL:TRUE

If I take that out and leave for example
Lay KillDelay:4.5 with odds of 1.01 and stake of $5
it sails straight through

But the biggest problem I then have is that the order is NOT killed, instead it is left in the queue as UNMATCHED which is highly dangerous, cost me $920 before I realised what was happening)

I have searched all of the forums without an answer so any more advice would be much appreciated
lhy
Posts: 3
Joined: Wed Feb 16, 2011 9:28 am

Try "FILL_KILL" instead of "Kill_Fill"
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”