Offset bet not placing

[vanbuuts]

My Excel sheet places pre off back bets with a PL25-IPC modifier based on specific criteria. However SOME of the offset (lay bets) don't place when the back bet has been matched!!

There doesn't seem to be any logical reason these bets do not fire. Sometimes I have more than one horse in the same race, one of which the lay bet triggers, the other does not??

Anyone encountered the same, is it a bug, is there a reason why an offset lay bet would not trigger once the back bet is matched??

[Captain Sensible]

Does your sheet continually stay on the market after the bets have been placed?

[vanbuuts]

Hi CS, no it flicks through each market at midday and places the bets. I have a timer set to change to the next market after 30 seconds.

Is this the cause?

[Captain Sensible]

Yes you need to stay on the market for any offsets to be monitored and fire. As soon as the program leaves a market it'll also clear it's memory of any offset settings. That's why it probably only fired offsets to the bets that were matched when they hit the market and not the others

If you want to loop thru markets you'd need to program in your own offset routine using matched bet data etc

[vanbuuts]

Hi, thanks for the reply. I need to keep each individual market all the time for the off sets to fire? That doesn't sound a practical option to me.

So regarding your second paragraph - not quite sure what you mean by this? Do you mean place the offset manually after the initial bet?

[Captain Sensible]

Hi, thanks for the reply. I need to keep each individual market all the time for the off sets to fire? That doesn't sound a practical option to me.
?

Afraid so, as soon as you leave the market tab from where you sent the bet all the offset data regarding that bet is lost to, so unless you match the original bet before leaving the market the offset info is lost. Most people don't have any problems and just use the settings available in gruss to move between markets but it all depends on what your bot needs to do. At the end of the day if the program doesn't have the market open it's not retreiving the data to know when to place an offset.

So regarding your second paragraph - not quite sure what you mean by this? Do you mean place the offset manually after the initial bet?

No you'd still do it via excel but excel would still have to be stepping thru the markets to find when you had a match from the matched bet data sent to excel you can't just place the bets then shut down the app.

[vanbuuts]

Thanks for the reply - so I'm thinking maybe having a separate tab for each race would work?

Basically my Bot looks for horses at midday that meet a certain criteria. When found it places a back bet at specific odds with a 25% offset lay. Now as you mention if the original back odds are met or better - the offset is triggered, if the back odds aren't met straight away - but met 2 hours later, the offset bet does not fire.

I don't want to place the lay bet at the same time, as that may get matched and the back bet doesn't.

[Captain Sensible]

Yep a separate tab for each would work, it's easy enough to slow down and speed up the refresh rates in Q2 for when they're needed if you worry about the data you're downloading.

You just need to make it as efficient as possible depending on how good you are with excel and what your system is actually doing I guess.

So you'd consider things like if the criteria for your bet is not met at 12 what happens? Does it give up? If so you'd delete that market from the quickpick list if looping or just set the refresh rate to 1000 so it's effectively shut down and not gathering data.

[vanbuuts]

Thanks CS, I'll see if I can work it using separate tabs. What do you mean about the amount of data I'm downloading? Do you mean the amount of markets open at once?

[Captain Sensible]

Yes just simply having 6 or so tabs open each downloading data can soon rack up a few gigabytes of data and might be a problem if your ISP has caps on the data.

Most of us just use one tab and move thru the markets adjusting the refresh rates to speed up when they're needed, the market data is generally more reliable closer to the off for various reasons. Unless there's a good reason (I can't think of any) for picking all your choices at some arbitary time such as 12 it's usually better just to fire bets in closer to the off when markets are more formed and settled. Obviously if you've some good reason and you contnually get better odds at 12 then you just work round that.

[vanbuuts]

Ok thanks again for the reply. The reason I back at 12 is purely to try and capture the offset before the off and green up before the horses are anywhere near the stalls. The fact the offset won't trigger if the market isn't displayed is a huge negative and I'm still trying to think of ways around it. VBA code isn't my strong point so any pointers appreciated

[Captain Sensible]

You don't neccessarily need VBA , gruss can export all bet data like matched unmatched bets etc to a separate sheet call MyBets if you want to use formulas to write your own closing bet routines, otherwise your easiest option is just using separate sheets.