Gruss Forum • View topic - How to tell when the offset bet has been matched?

by **danjuma** » Tue Jun 23, 2009 1:57 pm

There's no harm in Gary working on a spreadsheet to assist while we are waiting for the fix. Who says a man can't multitask. :wink:

by **danjuma** » Thu Jun 25, 2009 7:57 am

Gary,

Just thought I should update you with how I am getting on with this.

I did a workaround by checking the E column on the MyBets sheet for selections that have got no unmatched bets 'U' and getting the CLEAR trigger to fire if this was the case.

It seems to be working fine so far. Though, there have been the odd occassions when for some reason it's placed duplicate bets and corresponding unmatched off set bets (ie. two back bets for the same selection at the same odds at the same time and two off set lay bets at the same odds at the same and both unmatched, if you understand what I mean).

Like I said, it seems to be working fine apart from the above. I just wondered, since you know the bot in and out, do you forsee any problems or limitations with this logic, apart form the above, which at this stage I don't kown why this is happening.

Many thanks
Dan

by **GaryRussell** » Thu Jun 25, 2009 6:14 pm

Are you checking that the bet ref of your original bet is in the MyBets sheet before using CLEAR?. The problem is that there can sometimes be a delay before the bet appears in MyBets so there could be no unmatched bets after the bet is triggered and before the bet appears in MyBets.

I have been thinking about the logic I used in the net stake example and I think I have a simple solution which will cater for level profit triggers. I will upload an amended example as soon as I can.

by **danjuma** » Thu Jun 25, 2009 7:05 pm

GaryRussell wrote:Are you checking that the bet ref of your original bet is in the MyBets sheet before using CLEAR?. The problem is that there can sometimes be a delay before the bet appears in MyBets so there could be no unmatched bets after the bet is triggered and before the bet appears in MyBets.

I have been thinking about the logic I used in the net stake example and I think I have a simple solution which will cater for level profit triggers. I will upload an amended example as soon as I can.

Actually Gary, I am not checking this. I assumed the bet reference of the original bet will always appear in the MyBets in time. I shall have to wait for your amended example.

Thanks
Dan

by **GaryRussell** » Fri Jun 26, 2009 11:06 am

I have updated the example to work if you use level profit.
See http://gruss-software.co.uk/forum/viewtopic.php?t=3619

by **danjuma** » Fri Jun 26, 2009 8:48 pm

Gary,

Many thanks for you efforts.

I have tried out the new sheet. It is still not clearing the bet refs on some occassions after the off set bet has been matched.

I do appreciate that you have already spent time on this, so I will understand if you do want to spend any more time on it. I will just have to wait for the updated BA version.

Just to add, I amended my own logic to additionally check column A in MyBets to ensure the original bet ref was in there. It does clear the bet ref alright when the off set bet has been matched, but sometimes, like I mentioned before, for some reason it fires duplicate back bets.

Cheers
Dan

by **danjuma** » Fri Jun 26, 2009 8:56 pm

Something I have just noticed, yours is firing duplicate bets as well on the odd occassions

by **GaryRussell** » Sat Jun 27, 2009 6:32 am

It should be easy to spot why it hasn't cleared the bet as the criteria will not have been met. Can you take a copy of the spreadsheet at the time it hasn't cleared and send it to me so I can have a look?

I will investigate regarding duplicate bets.

by **GaryRussell** » Sat Jun 27, 2009 7:24 am

danjuma wrote:Something I have just noticed, yours is firing duplicate bets as well on the odd occassions

As provided without you making any alterations?

by **danjuma** » Sat Jun 27, 2009 4:45 pm

I have mailed you some screenshots Gary.

Thanks
Dan

by **throwmeadisc** » Fri Jul 31, 2009 7:46 pm

Hi Gary,

Have you had any progress with this one?

Many thanks.

Al

by **GaryRussell** » Sat Aug 01, 2009 11:04 am

Yes. danjuma has been testing a new flag I added. Maybe you could also give it a try.

Download the latest build of the pre-release version from http://www.gruss-software.co.uk/Betting ... _Beta1.msi

When setting up the link to Excel there is a new column available under "Additional columns" named "Offset bet matched flag". This column will show "Y" when the offset bet is fully matched.

by **throwmeadisc** » Sun Aug 02, 2009 2:31 pm

Awesome I will give it a go. Thanks.

Will there also be another column with the Betref of the offset bet so we can tell the result of the bet from the Log Bets Sheet? This would be a perfect solution for me.

cheers.

Al

by **throwmeadisc** » Mon Aug 03, 2009 12:00 pm

Additional Info:

I ask this as my offset bet would be quite a few ticks away from the original price and usually only matched In Play when I am no longer monitoring the market.

Cheers,

Al

by **GaryRussell** » Mon Aug 03, 2009 12:19 pm

Yes. I can add an extra column. Please bear in mind this new column will possibly contain multiple bet refs if the initial bet was matched in chunks which would create multiple offset bets.

How to tell when the offset bet has been matched?

Who is online

Sports betting software from Gruss Software