BACKR/UPDATE Triggers for Offset Bets

[lindemann]

Could some kind soul please explain how the BACKR and/or UPDATE triggers work in relation to offset bets. I can get the triggers to fire under my chosen conditions but nothing seems to happen which I think is because the original Bet Ref is in Column T not the Offset. I can get the Offset Ref into an additional column but do I now have to get that reference into Column T and if so how?

Hopefully I'm missing something obvious and this can be solved in Excel. If it involves VBA then I reserve the right to ask further numpty questions!

I can simulate what I want to do manually using the "Close All Positions" button. Can this be done in Excel yet?

[lindemann]

Gary/Mark/Anyone,

Is there any help available on this topic as I'm stuck trying to find a solution or a workaround?

[GaryRussell]

I'm not sure from your post what you are trying to achieve. You want to do something with the offset bet, but it's not clear. Can you explain exactly what you are trying to do and then I can explain how BACKR and UPDATE work in relation to that.

I can simulate what I want to do manually using the "Close All Positions" button. Can this be done in Excel yet?

There aren't any green up triggers yet, but we have provided a sample worksheet which does the calculations required using VBA. See http://www.gruss-software.co.uk/forum/v ... php?t=4659

[lindemann]

Thanks for the reply Gary.

I have a strategy which is modestly profitable so far of laying 3 selected runners per race with an offset and a stop-loss. When two of the offsets are matched I want to update or replace the third offset to zero out the original bet e.g. I layed at 5 with an offset request to back at 6 but I'm now happy to back at 5 because the other bets are matched.

How can I do this avoiding any kind of bet cancellation because it seems like the API is very slow to respond and update cancellations?

[lindemann]

Sorry, I should have made it clear that I'm laying at SP and trading in-running so speed of execution is important.

[lindemann]

Gary, Any further information on this topic? I'm still interested.

[GaryRussell]

I am looking into this. Please bear with me.

[lindemann]

No problem Gary, I'm looking into an Excel version of the green-up calculations which looks promising (by my standards). We can exchange notes in due course.

[GaryRussell]

The most suitable suitable triggers for your situation are CANCEL-ALL followed by BACK with the appropriate stake to green up which can be calculated with the code in the example spreadsheet we have supplied.

BACKR will not cancel the offset bet before placing the new back bet so the offset bet getting matched later will spoil the green up.

After CANCEL-ALL has triggered you can trigger BACK on the next refresh. CANCEL-ALL will cancel all unmatched bets for the selection including offset bets. It will also deactivate the stop loss so it cannot fire. You are then safe to trigger BACK on the next refresh.

[lindemann]

Thanks Gary. I'm working on this but I have one question (for now). If I want to trigger the CANCEL-ALL and BACK triggers on the same event but successive refreshes, how do I write my Excel trigger? Or do I have to use something like T5="" to confirm the cancellation of the earlier bet?

[GaryRussell]

Thanks Gary. I'm working on this but I have one question (for now). If I want to trigger the CANCEL-ALL and BACK triggers on the same event but successive refreshes, how do I write my Excel trigger? Or do I have to use something like T5="" to confirm the cancellation of the earlier bet?

You got it. CANCEL-ALL clears T5 so t5="" on the next refresh is the right time to use the BACK trigger.

[lindemann]

Blimey, am I finally getting the hang of this?

I've recently solved another self-inflicted problem as well (see other thread on Cancel remaining etc).

Onwards and upwards. Thanks again.