Double backing

[eclipse]

Hi all, I'm firing in some back bets in play with a fill/kill of 4 seconds in Excel. If it's not fully matched then then it clears the bet ref and fires in a new back bet. It uses the My_bets sheet to work out how much has been matched but occationally this is not showing the matched amount quickly enough so it's firing in a full bet again. Is there anyway to know that the My_bets sheet has been updated before firing in a new bet? Many thanks for any help.

[alrodopial]

I would also like to have a way with this as I also use the BACK-F1 trigger , (not using the My_bets sheet) and check if my bet was matched 1,5secs after the end of 1 sec but still there was one or two occations that I got that my bet was partially matched but it was actually fully matched.

Garry can you post how the bet reff changes ( number, number with P in end) when a back-f4 is triggered and when is partially matched,then partially matched again, then fully matced , partially matched at the end etc, ?

And of course how the my_bets sheet can be used for this as ecliple asked

Thanks

[alrodopial]

Garry/Mark, your help is needed here

[GaryRussell]

Hi all, I'm firing in some back bets in play with a fill/kill of 4 seconds in Excel. If it's not fully matched then then it clears the bet ref and fires in a new back bet. It uses the My_bets sheet to work out how much has been matched but occationally this is not showing the matched amount quickly enough so it's firing in a full bet again. Is there anyway to know that the My_bets sheet has been updated before firing in a new bet? Many thanks for any help.

Are you checking the status column in MyBets? If the bet appears with status U then fill or kill hasn't completed. If it appears twice: once with status U and again with status F then it's too soon to check. If it only appears once with status F then it has completed and the matched amount has to be up to date, it cannot change after that. If it does not appear at all then it was completely killed. Therefore you should be checking for it not being present at all or once with status F to trigger your next bet.

[GaryRussell]

I would also like to have a way with this as I also use the BACK-F1 trigger , (not using the My_bets sheet) and check if my bet was matched 1,5secs after the end of 1 sec but still there was one or two occations that I got that my bet was partially matched but it was actually fully matched.

Garry can you post how the bet reff changes ( number, number with P in end) when a back-f4 is triggered and when is partially matched,then partially matched again, then fully matced , partially matched at the end etc, ?

And of course how the my_bets sheet can be used for this as ecliple asked

Thanks

Unmatched, but not killed: bet ref without P appended and matched stake column is 0

Unmatched and killed: bet ref contains "CANCELLED"

Partially matched, but not killed: bet ref with P appended and stake column not 0

Partially matched and killed: bet ref without P and stake not 0, but less than requested stake

Fully matched: bet ref without P and stake equal to requested stake

Therefore you should only trigger another bet if "unmatched and killed" or "partially matched and killed"

but still there was one or two occations that I got that my bet was partially matched but it was actually fully matched

Were these bets triggered while the bet ref still had P appended?

[eclipse]

I've been getting situations where the bet is fully matched but My_Bets is not updated fast enough to reflect this (I work out how much to back again based on the the amount matched in the My_Bets sheet), so my program is triggering another full back bet. Wondering if the 1 second delay in play is causing me problems.

[GaryRussell]

I've been getting situations where the bet is fully matched but My_Bets is not updated fast enough to reflect this (I work out how much to back again based on the the amount matched in the My_Bets sheet), so my program is triggering another full back bet. Wondering if the 1 second delay in play is causing me problems.

How are you checking MyBets? With a formula or with VBA? I think it would be better if a provided an example of how to check it.

[eclipse]

I'm using an array formula to check the matched back bets, each area on the My_bets sheet being named.
{=IF($A5<>"",SUM(IF((SelectionP=$A5)*(MatchedP="F")*(TypeP="B"),StakeP*OddsP,0)),0)}

Normally works very well.

[GaryRussell]

Is the formula in a cell on the MyBets worksheet or the trigger worksheet?

[eclipse]

It's on the trigger worksheet.

[alrodopial]

Unmatched, but not killed: bet ref without P appended and matched stake column is 0

Unmatched and killed: bet ref contains "CANCELLED"

Partially matched, but not killed: bet ref with P appended and stake column not 0

Partially matched and killed: bet ref without P and stake not 0, but less than requested stake

Fully matched: bet ref without P and stake equal to requested stake

Thanks , exactly what I wanted

[GaryRussell]

I'm using an array formula to check the matched back bets, each area on the My_bets sheet being named.
{=IF($A5<>"",SUM(IF((SelectionP=$A5)*(MatchedP="F")*(TypeP="B"),StakeP*OddsP,0)),0)}

Normally works very well.

Am I missing something? If the bet is unmatched on the next refresh, but before the fill or kill has executed won't your formula indicate nothing is matched and trigger another bet?

For example.

Code: Select all

Seconds elapsed         Action
0                               BACK-F4
1                               New bet triggered because formula indicates unmatched
2                               First bet matched
4                               Fill or kill executes, but bet matched


Does your spreadsheet's logic assume that BACK-F4 (including waiting for 4 seconds and then attempting to cancel the bet) will complete before the next refresh?

[eclipse]

My trigger formula won't fire in a new bet until a 'CLEAR' has been fired first. It fires a CLEAR if bet fef indicates CANCELLED (killed) or if there is a bet ref but unmatched amount =0, it checks for amount unmatched too. If the amount matched is less than original stake then it fires a back bet in again. Sometimes it seems the MyBets sheet is lagging behind on showing the actual amount matched so it's firing in another bet before the true figure matched is appearing. Hope that makes sense lol.

[GaryRussell]

My trigger formula won't fire in a new bet until a 'CLEAR' has been fired first. It fires a CLEAR if bet fef indicates CANCELLED (killed) or if there is a bet ref but unmatched amount =0, it checks for amount unmatched too. If the amount matched is less than original stake then it fires a back bet in again. Sometimes it seems the MyBets sheet is lagging behind on showing the actual amount matched so it's firing in another bet before the true figure matched is appearing. Hope that makes sense lol.

Yes, that gives me a better picture of what you are doing. Please leave it with me.

[GaryRussell]

If the amount matched is less than original stake then it fires a back bet in again

Are you using the following logic?

If amount matched is greater than zero but less than original stake fire new bet. Determine the amount to place from MyBets.

There can be a lag due to the order that BA updates the spreadsheet. This is the order.

1. Update MyBets
2. Update odds and amounts offered.
3. Update matched odds and stakes on trigger worksheet.

It's possible that between updates 1 and 3 that more of the bet is matched. Checking that the amount matched is greater than zero does not guarantee that fill or kill has executed. You can safely use the amount from MyBets if there no entries present with status U. It cannot be wrong then.