Clearing Bet Ref

[U.F.O]

For the last few days i have been having a few problems clearing the bet ref on a spreadsheet i have been using without any problems before.

sometimes the bet ref keeps coming back no matter how many times i clear it.

the only way i can continue is by disconnecting excel, deleting the ref and then re-reconnecting.

Any idea what could be happening

thanks

[GaryRussell]

Are you clearing the ref using VBA? Sounds like it's being cleared after BA has read the cell and before it next writes it. The best placed to clear the ref is in the worksheet_change event when the column count is 16, ie. when the odds are written. The odds are written just before the bet ref column is read.

[U.F.O]

The bet ref is cleared by a simple macro triggerd by the press of a button .

But when the problem has occured i have also tried going to bet ref and clearing the cell manually and it's the same result.
bizarrely you can even change it to the another market intirely and the same thing happens the bet same bet ref reappears .

it only happens a few times a day so it's no big deal and i guess if no one else has had this problem it must be something specific to me.

[GaryRussell]

That's probably where the problem is. The button can be clicked at any time which does not fit well with how BA updates Excel. I'll have a look tomorrow and try to explain more fully why this will cause a problem. I recommend that instead of clearing the ref on the button click that you set a flag which will clear the ref next time the odds are updated. ie. in the market change event when Target.Columns.Count=16.

[danjuma]

That's probably where the problem is. The button can be clicked at any time which does not fit well with how BA updates Excel. I'll have a look tomorrow and try to explain more fully why this will cause a problem. I recommend that instead of clearing the ref on the button click that you set a flag which will clear the ref next time the odds are updated. ie. in the market change event when Target.Columns.Count=16.

I am having similar problem, and I am not using any VBA code. What I have got is two simple radio buttons, 1 for place bet, and 2 for clear bet ref, with a simple formula in column T =IF(AM5="","",IF(AM5=1,"LAY",IF(AM5=2,"CLEAR",""))). I am using this in-play at 0.5 refresh rate. What I am basically doing is when I want a lay bet placed, I click the radio button 1, and when I want to place another bet, I click radio button 2 to clear the bet ref and then click radio button 1. However, the placing of the bets and clearing of the bet ref has been erratic. Sometimes when I click to clear the bet ref and then click to place another bet, it will place more than the one bet for the selection (of same full stake, not part stakes), and there has even been the odd occasion when when I placed the first lay bet even before clearing, it has placed more than one bet instead. Can't work out why???

Thanks

[GaryRussell]

That's probably where the problem is. The button can be clicked at any time which does not fit well with how BA updates Excel. I'll have a look tomorrow and try to explain more fully why this will cause a problem. I recommend that instead of clearing the ref on the button click that you set a flag which will clear the ref next time the odds are updated. ie. in the market change event when Target.Columns.Count=16.

I am having similar problem, and I am not using any VBA code. What I have got is two simple radio buttons, 1 for place bet, and 2 for clear bet ref, with a simple formula in column T =IF(AM5="","",IF(AM5=1,"LAY",IF(AM5=2,"CLEAR",""))). I am using this in-play at 0.5 refresh rate. What I am basically doing is when I want a lay bet placed, I click the radio button 1, and when I want to place another bet, I click radio button 2 to clear the bet ref and then click radio button 1. However, the placing of the bets and clearing of the bet ref has been erratic. Sometimes when I click to clear the bet ref and then click to place another bet, it will place more than the one bet for the selection (of same full stake, not part stakes), and there has even been the odd occasion when when I placed the first lay bet even before clearing, it has placed more than one bet instead. Can't work out why???

Thanks

I don't think it's BA causing the problem. It's more likely to be the design of the spreadsheet. Can you send a copy of the spreadsheet to admin@gruss-software.co.uk so I can have a look? I could try to reproduce it from the info in your post, but there might be something in the spreadsheet I am anaware of.

[GaryRussell]

The bet ref is cleared by a simple macro triggerd by the press of a button .

But when the problem has occured i have also tried going to bet ref and clearing the cell manually and it's the same result.
bizarrely you can even change it to the another market intirely and the same thing happens the bet same bet ref reappears .

it only happens a few times a day so it's no big deal and i guess if no one else has had this problem it must be something specific to me.

It's as I thought. The bet ref is read then BA does some processing including looking up the current matched odds and stake so that it can write it back to the spreadsheet. If during this processing time (usually only a few milliseconds) the ref is cleared either by your code or even manually the old bet ref will be written back to the worksheet.

The are only two safe ways to clear the bet ref.
1. Using the CLEAR trigger.
2. In VBA code inside the Worksheet_Change event when Target.Columns.Count=16.

My suggestion to set a flag and clear it as per the second option should solve your problem.

[danjuma]

That's probably where the problem is. The button can be clicked at any time which does not fit well with how BA updates Excel. I'll have a look tomorrow and try to explain more fully why this will cause a problem. I recommend that instead of clearing the ref on the button click that you set a flag which will clear the ref next time the odds are updated. ie. in the market change event when Target.Columns.Count=16.

I am having similar problem, and I am not using any VBA code. What I have got is two simple radio buttons, 1 for place bet, and 2 for clear bet ref, with a simple formula in column T =IF(AM5="","",IF(AM5=1,"LAY",IF(AM5=2,"CLEAR",""))). I am using this in-play at 0.5 refresh rate. What I am basically doing is when I want a lay bet placed, I click the radio button 1, and when I want to place another bet, I click radio button 2 to clear the bet ref and then click radio button 1. However, the placing of the bets and clearing of the bet ref has been erratic. Sometimes when I click to clear the bet ref and then click to place another bet, it will place more than the one bet for the selection (of same full stake, not part stakes), and there has even been the odd occasion when when I placed the first lay bet even before clearing, it has placed more than one bet instead. Can't work out why???

Thanks

I don't think it's BA causing the problem. It's more likely to be the design of the spreadsheet. Can you send a copy of the spreadsheet to admin@gruss-software.co.uk so I can have a look? I could try to reproduce it from the info in your post, but there might be something in the spreadsheet I am anaware of.

Spreadsheet sent. Thanks

[U.F.O]

The bet ref is cleared by a simple macro triggerd by the press of a button .

But when the problem has occured i have also tried going to bet ref and clearing the cell manually and it's the same result.
bizarrely you can even change it to the another market intirely and the same thing happens the bet same bet ref reappears .

it only happens a few times a day so it's no big deal and i guess if no one else has had this problem it must be something specific to me.

It's as I thought. The bet ref is read then BA does some processing including looking up the current matched odds and stake so that it can write it back to the spreadsheet. If during this processing time (usually only a few milliseconds) the ref is cleared either by your code or even manually the old bet ref will be written back to the worksheet.

The are only two safe ways to clear the bet ref.
1. Using the CLEAR trigger.
2. In VBA code inside the Worksheet_Change event when Target.Columns.Count=16.

My suggestion to set a flag and clear it as per the second option should solve your problem.

Ok thanks, i will have a go at changing the way i clear the bet ref and see if that helps.

[GaryRussell]

danjuma: I have replied to your email with a possible solution. I don't think BA is at fault, it looked like a logical error in the spreadsheet.

[danjuma]

danjuma: I have replied to your email with a possible solution. I don't think BA is at fault, it looked like a logical error in the spreadsheet.

Yes Gary, I think you are right, it would appear to be a logical error in myspreadsheet. I will amend it as per your suggestion and see how it goes. Many thanks and sorry for hassling you.