Q's re excel odds/stakes + bets placed without trigger?

[aubweaver]

Hi,
I have two Q's. The first was brought to my attention by another member as something that shouldn't happen. This is all 'In Play'
1. I'm using excel worksheets 'linked' . The main sheet (sheet1) is the BACK sheet and if theire's a matched bet it will link to another sheet. On that sheet (sheet 2or 3) I have tried using formulas either multiplying*, dividing/ or % for the LAY odds/stakes and therefore can end up with some weird odds or stakes. i.e. matched BACK odds of 7.68 *2 =15.36 and I've ended up with INVALID_PRICE...and no bet being placed. Is this correct ? As I've had to make some rather long convoluted formulas to overcome the problem and it would be great to simply put in * / or %. Maybe I'm blaming the wrong thing and need to check further.
Q2. This has happened at least twice this week and unfortunately has only occurred when I'm looking at another sheet while in play.
When after 2 or 3 secs I return to the main sheet, the"BACK" sheet, I have found that one or two bets have been placed, so far only the fav's, but the ,Q, Trigger, 'R'Odds and 'S' Stake cells are all blank plus the fav's are not even part of my selected criteria, all BSP's above 10 or 12, yet the BSP on the fav's have been 2 - 4. It may ony happen once or twice in 20 races. Any ideas what can be causing it. I screen record everything therefore I can look in slowmo and pause but as I said It's when I've returned to that sheet consequently the point when the bet was made is missed just the couple of secs later showing the match and the blank cells.???
Cheers,
Peter

[GaryRussell]

1. I'm using excel worksheets 'linked' . The main sheet (sheet1) is the BACK sheet and if theire's a matched bet it will link to another sheet. On that sheet (sheet 2or 3) I have tried using formulas either multiplying*, dividing/ or % for the LAY odds/stakes and therefore can end up with some weird odds or stakes. i.e. matched BACK odds of 7.68 *2 =15.36 and I've ended up with INVALID_PRICE...and no bet being placed. Is this correct ? As I've had to make some rather long convoluted formulas to overcome the problem and it would be great to simply put in * / or %. Maybe I'm blaming the wrong thing and need to check further.

BA rounds the odds to the nearest valid odds so you shouldn't get this error if the odds supplied are between 1.01 and 1000. You could get this error if the odds are zero or blank so you should check for this.

Q2. This has happened at least twice this week and unfortunately has only occurred when I'm looking at another sheet while in play.
When after 2 or 3 secs I return to the main sheet, the"BACK" sheet, I have found that one or two bets have been placed, so far only the fav's, but the ,Q, Trigger, 'R'Odds and 'S' Stake cells are all blank plus the fav's are not even part of my selected criteria, all BSP's above 10 or 12, yet the BSP on the fav's have been 2 - 4. It may ony happen once or twice in 20 races. Any ideas what can be causing it. I screen record everything therefore I can look in slowmo and pause but as I said It's when I've returned to that sheet consequently the point when the bet was made is missed just the couple of secs later showing the match and the blank cells.???

There is not a bug causing it to trigger bets when the trigger cells are blank. They must have contained something. You should double check how these cells are populated, maybe you missed something.

[aubweaver]

Thanks Gary,
I will definitely check the odds/stakes issue now.
I will monitor the situation re 'bet without trigger'. I'm sure you're right, I may already have inadvertently corrected and it may never happen again.
Thanks Peter.