Bets getting stuck at £2 @ 1.01

[excelhasey]

I have some bets that will result in a stake of less than £2, via triggers in Excel, but in BA it is getting stuck at £2 @ 1.01 unmatched it is not automatically updating to say 0.25p @ 3.50 - why ??

[GaryRussell]

Check the transaction log in the account menu. Are there any error codes in the API response column?

[excelhasey]

Here is one example it says :-

Below minimum stake, lay 2 @ odds 1.01 (Excel LAY Triggered: Odds:3.55 Stake:0.1249 Tick offset:0 Fill or kill:3)

API Response OK

But Column "R" = appropriate Colum "F" figure not 1.01

[excelhasey]

Some other horses in the race, that I have not put a Stake value in column "S",results in an error "BETWEEN_1_AND_60_BETS_REQUIRED" which is fine but I think this is screwing up the other bets because when I delete the Trigger for the above horses and delete the previous unmatched bets it then matches at say 5.5 @ 30p etc on the horses I expected it to work on

[GaryRussell]

There's more than one transaction involved. Each bet should have 4 entries in the log similar to the following.

1 23/08/2010 18:56:45 11889845317 Below minimum stake, lay 2 @ odds 1.01 OK 166
2 23/08/2010 18:56:45 11889845346 Below minimum stake, update stake from 2 to 2.2 NEW_BET_SUBMITTED_SUCCESSFULLY 190
3 23/08/2010 18:56:46 11889845317 Below minimum stake, cancel lay of 2 @ odds 1.01 REMAINING_CANCELLED 149
4 23/08/2010 18:56:46 11889845424 Layed Nave @ odds:1.1, stake:0.2 (Standard grid clicked) OK_REMAINING_CANCELLED 90

I would expect to see an error against one of the other transactions. If you are not seeing anything like this then can you try the Beta version which is more reliable at logging any errors encountered by below minimum stake bets. You can install it using the following link.
http://www.gruss-software.co.uk/Betting ... _Beta2.msi

[GaryRussell]

Some other horses in the race, that I have not put a Stake value in column "S",results in an error "BETWEEN_1_AND_60_BETS_REQUIRED" which is fine but I think this is screwing up the other bets because when I delete the Trigger for the above horses and delete the previous unmatched bets it then matches at say 5.5 @ 30p etc on the horses I expected it to work on

It will prevent the other bets working. You should change your spreadsheet to avoid triggering a bet without the stake and odds columns populated correctly.

[excelhasey]

Tweaked Trigger / Stake thanks Gary

[excelhasey]

If you want to vary your "n" value instead of BACK-TL5 so horse ranked 1 maybe BACK-TL1, horse ranked 5 maybe BACK-TL5, horse ranked 12 maybe BACK-TL12 etc how do I write that I tried horse ranked 1 maybe BACK-TL&BA5 (i.e. cell BA5) but that doesn't work

Any ideas ??

[excelhasey]

I have done variable TL now thanks

[excelhasey]

No I haven't sorted it because I don't know how to add "F5-IP" onto "BACK-TL" &DK5

[GaryRussell]

No I haven't sorted it because I don't know how to add "F5-IP" onto "BACK-TL" &DK5

You do it in the same way, using &

Code: Select all

="BACK-TL" & DK5 & "-F5-IP"