How to tell when the offset bet has been matched?

[danjuma]

Hope someone could help me with this, or if it's already been answered somewhere in the forum, point me to the thread.

I have written a trigger which submits a back or lay bet when certain conditions are met, and after being matched, immediately submits a tick offset bet.

My problem is how to clear the bet reference for the original bet after the tick offset bet has been matched, so that a new bet can been placed.

I can write an excel statement to in put "CLEAR" in the trigger column against a selection that's got its tick offset bet matched, but how can I tell excel that the tick offset bet has been matched?

The bet reference column 'T' logs just the bet reference for the original bet, and not the bet reference for the tick offset bet.

Thanks
Dan

[throwmeadisc]

Hi Dan,

This has been discussed

here - http://www.gruss-software.co.uk/forum/v ... 7891#17891

and here - http://gruss-software.co.uk/forum/viewtopic.php?p=18005

I think Gary is working on a solution....

Cheers,

Al

[danjuma]

Thanks throwmeadisc.

Gary, any solution yet? If not, got any suggestions for a workaround at present?

Cheers
Dan

[GaryRussell]

It's on my list to provide functionality to display the offset bet, but in the meantime I have created an example spreadsheet which uses MyBets to calculate the net stake and therefore if the offset bet is matched. See http://gruss-software.co.uk/forum/viewtopic.php?t=3619

[danjuma]

Brilliant Gary! Many thanks

[danjuma]

Hello Gary,

Firstly, many thanks for taking the time to come up with this spreadsheet (Calculate net matched stake from MyBets).

I have tried it with my trggers and a few things came to light.

1. It would appear it does not clear the bet ref column when "CANCELLED" is it, which appears when a bet is cancelled before being matched using fill or kill.
I think I managed to find a solution to this by adding a line to clear the bet ref column when it contains "CANCELLED". I mentioned 'I think' because though this seems to work, but there were the odd occassions when it did not. Dont' know why.

2. The spreadsheet seems to work ok (clearing the bet ref column when the off set bet is matched) when using just the one worksheet and 'MyBets' for all races.
However, it does not seem to work when the different venues are loaded into different tabs, and each venue logged to seperate worksheets in the same workbook. I did create seperate 'MyBets' sheets for the different worksheets (appropriately labelled Sheet1_MyBets, Sheet2_MyBets etc)

The bets were recorded correctly to the correct 'MyBets' sheet, but the bet ref was just not being cleared after the offset bet has been matched.

3. Sometimes, the bet ref does not get cleared after a new race has been loaded. So you have a new race, having the previous race bet ref in the bet ref column.
I got round this by ticking the clear bet ref option when market automatically loads in the log to excel pop-up box. However, I don't know what effect, if any this might have on any outstanding unmatched bet in the previous market, especially those set to be kept in-play

Cheers
Dan

[danjuma]

Gary,

Just wondered, got any answers or solution?

Cheers
Dan

[GaryRussell]

I only provided the spreadsheet as an example so I would expect it to need modification to suit your requirements. Please bear with me, I will try to have a look later.

[danjuma]

Thanks Gary.

I do appreciate you are a very busy man.

[danjuma]

Gary,

Just to add, I have tried it again with just the one worksheet and 'MyBets' sheet in the one workbook, and for some reason it sometimes does not clear the bet ref after the off set bet has been matched.
I am using a 1sec refresh rate and trading before the start of a race (Not in play) and trading the top 3 favs.

Cheers
Dan

[GaryRussell]

Gary,

Just to add, I have tried it again with just the one worksheet and 'MyBets' sheet in the one workbook, and for some reason it sometimes does not clear the bet ref after the off set bet has been matched.
I am using a 1sec refresh rate and trading before the start of a race (Not in play) and trading the top 3 favs.

Cheers
Dan

If you are using fill or kill it will affect the logic as the trigger formula checks for the bet being fully matched by comparing the matched stake to the requested stake. You probably had some partial matches which will trip the logic up. I will be uploading a new example which will address this limitation and also demonstrate how to get it working with multiple worksheets.

[danjuma]

Thanks for looking at this Gary, much appreciated.

I have been looking at a way round this myself, and was thinking of checking the MyBets sheet for selections without a 'U' in the E column, and trigger the CLEAR to clear the bet ref for that selection. Do you forsee any problems or limitations with this logic?

Cheers
Dan

[danjuma]

Just to add, I am also using the auto level trigger 'TLn' to spread my loss/profit. Don't know whether this will have any negative effect.

Cheers
Dan

[GaryRussell]

Just to add, I am also using the auto level trigger 'TLn' to spread my loss/profit. Don't know whether this will have any negative effect.

Cheers
Dan

It definitely will, it destroys the logic completely as it relies on the net stake being zero which will never be the case. I'll have to give this some thought.

[throwmeadisc]

I don't mean to butt in, but would it not be better for Gary to spend his time implementing the actual change in the software. This would then resolve all issues. Whilst I apreciate the sample sheets, the full change is much more useful.

Cheers,

Al