Best method to check the status of a submitted bet?

[barnov]

Hi,

I'm in the process of writing some code to submit a Dutch Back Bet, and have got as far as being able to submit the bet having met all my entry criteria and bet calculations, and I'm seeking some advice as to what method is best suited to checking if the bets have been matched or not.

If they are matched, then I'll sit back and let the race run, if not matched, then I'll need to tweak odds (perhaps stake) etc.

Would members advise:

a) using single GetBet COM utility against each Betref
b) using multiple GetBets COM and calculating how many F's (or Us) from the resultant object
c) using a Lookup function against the MyBets tab
d) any other method

And if there is some sample code here in the forum somewhere, perhaps someone could paste a link (or code)

Thanks in advance

Paul (aka BarNov)

[GaryRussell]

The matched stake column is sufficient. It is updated on every Excel refresh.

[barnov]

Gary - thanks for the reply.

Excellent s/w and full marks for the prompt service/support you provide, not just for this query but across the board.

Should also thank other contributors as well, as I've managed to pick out many of the salient points I need for my own code from posts on the various forums, and have now run this in live mode for 1st time today (and acheived my profit target).

Thanks

Paul

[barnov]

Gary (et al),

As per previous reply, I can now write some simple code to check that the 'stake' & 'matched stake' are equal for each runner that I'm backing, but if there is a difference, I just can't seem to get my head round what to do next.

What I'm trying to do is : -
1) identify how much hasn't been matched
2) update the appropriate trigger cells to re-submit the Back bet for
unmatched portion

I'm assuming that to identify the unmatched amount, I could scan the MyBets sheet for any entries with U in the matched column. But I'm stuck from there.

Any help with the logical steps or sample code would be appreciated.

Thanks in advance

Paul (aka Barnov)

[GaryRussell]

It would be better to use the UPDATE trigger to get the remaining portion matched. When you have identified that there is a partial match and you want to get the rest matched then change the odds column to the required odds and insert UPDATE in the trigger column.

[GaryRussell]

Please be aware when you update a bet a new reference is created so it could still look like the bet is partially matched as the new reference will have a matched stake less than your requested stake column. It is better to determine if the bet is partially matched by checking the bet reference, it will always have P appended if it is partially matched.

[barnov]

Thanks for quick reply Gary.

Keeping it simple, would this mean that the following would be the simplest way to resolve the unmatched portion

1) run a 'For each cell' routine against the Q5:X? array
2) check that 'stake' & 'matched stake' are the same
3) if not the same
calculate difference (stake - matched)
enter difference in appropriate S? cell
enter UPDATE in appropriate Q? cell

Am I right in assuming that the BetRef remains the same and that I can totally ignore the MyBets sheet altogether

Apologies for being a pain, but hopefully some other newbies are also benefitting from these questions/answers

Paul (aka Barnov)

[GaryRussell]

1) Run a 'For each cell' routine against the T5:X? array (the bet reference)
2) Check if the reference contains "P" eg. instr(ref,"P")<>0
3) If contains "P" then enter appropriate reduced odds in R? cell and enter UPDATE in Q? cell. There is no need to calculate the unmatched stake.

The bet reference does not remain the same when you use the UPDATE trigger. It's the same as submitting bets through the website, if you update a partially matched bet a new bet reference will be created.