Offset/Stop Loss delay?

[gizzard]

Hi Gary
I'm using MyBets to identify if all Stop-Loss/Offset bets have been matched. I'm assuming that if there are no "U" entries under "Matched" then they have all been matched.

I'm hitting the odd problem and was wondering if it's possible that when an original bet (let's say a Lay) is matched, there's a small delay before the offset bet (Back) is triggered. During that small delay, the status on the Lay bet is set to "F" fully matched but the Back bet does not yet exist.

For my checking, there would be no unmatched Back bets (Back bet not yet triggered) so I'd be assuming that the offset had been matched whereas it doesn't actually exist.

If the delay can happen then how can I "truly" identify that all offset (Back) bets have been triggered and matched?

Thanks

[GaryRussell]

Yes that could happen. In the Beta version you have the option to add an additional column named "Offset bet matched flag". This column will contain "Y" when all offset back bets have been triggered and matched. Additional columns start at column Y.

[gizzard]

Ah, that could be handy.

I'm not sure that the flag will completely resolve my problem which is complicated by the fact I have 2 worksheets active for the one market. I want to check whether the offset for the original place bet on that particular worksheet has been fully matched. I don't think that the flag that you mention will distinguish between the two worksheets and their bets.

[GaryRussell]

It should work. The flag is based on the bet from the bet ref column, not on the selection.

[gizzard]

This is sounding even better.

Can I now check, if the flag is based on the Bet Ref column, if my code clears the Bet Ref, does that impact the way the flag works or is the original Bet Ref still held internally within BA?

[GaryRussell]

It will only work if the bet ref is present. It doesn't matter however if it is removed and then repopulated so your spreadsheet could record it and repopulate if necessary.