Placing a tick off set with Excel

[vanbuuts]

Hi, I have been developing and Excel sheet which places a lay bet after 30 minutes.

I then want to place either a back Fixed odds tick offset, or a back stop loss modifier (depending on which way the odds move).

So say for example I place my initial lay at odds of 4.00 for £10 - meaning liability of £30

If I want to "green up" when the odds reach 8 how would I do that? I tried using the command BACK-TLF8 (to back to fixed odds of 8 with auto level profit) but it is asking me to enter a stake.

I thought the purpose of this bet is that it would calculate the stake for me to allow even profit? I could use just a basic BACK bet and enter the odds and calculate the stake myself but that contradicts the point of the Tick offset command.

Visa versa for the stop loss.

Anyone who has successfully used these commands in Excel I'd be grateful for some assistance

[brumbie]

When submitting your original lay bet you would include your tick offset so:

LAY-TLF8 would do it I think for an auto greenup at 8's

any stop loss is added on afterwards so:

LAY-TLF8-SLF2-L should give you a level stop loss if the odds creep down to 2's...I hope

[vanbuuts]

Thank you, I have today tried this and the tick off set bet works fine.

I'm not sure if the stop loss bet is submitted however?

I want to apply a fixed odds level loss stop loss with chase option.

So using the scenario the odds for the lay bet are 4.00 I want to set a tick off set to green up evenly if they reach 8 (which you have already done) and also a fixed odds level stop loss if they dip too 1.80

[MarkRussell]

Hi,

To add the chase Stop Loss to kick in at 1.80 use:-

LAY-TLF8-SLF1.8-L-SLC1

This assumes a 1 second wait before chasing (just change the SLC number to use a different wait)

Regards,
Mark

[vanbuuts]

Hi Mark. Many thanks. I did that but the bet wasn't visible in open bets (where as the off set ticks was).

Does this just automatically trigger when the odds reach 1.80?

[MarkRussell]

Hi Mark. Many thanks. I did that but the bet wasn't visible in open bets (where as the off set ticks was).

Does this just automatically trigger when the odds reach 1.80?

Hi,

That is correct, it can't place the Stop Loss bet until the odds reach where it is set as trying to place it before then would just result in you getting matched at higher odds because of Betfair's "Best Execution" policy.
That is the whole problem with Stop Loss bets and why we introduced a chase option but even if with that there is no guarantee of getting matched.

Regards,
Mark

[vanbuuts]

Thanks Mark, one more question, would it be possible to impose 2 separate tick off sets ?

So for instance one to break even if the odds returned to 4.0 and one if they jumped up to 8.0?

Would something like the below work, or is there another way of doing it?

LAY-TLF8-TLF4-SLF1.8-L-SLC1

[MarkRussell]

Hi,

Sorry no you can't do that.
You would have to make a custom trigger yourself to fire in the offset bet based on the criteria that you want.
Probably would require using VBA to determine when the offset should be triggered and at what odds.

Regards,
Mark

[vanbuuts]

No problem Mark. Understood

[vanbuuts]

Just noticed with the code below - if the market suspends (a goal is scored) the off set tick bet is cancelled. Is that correct? Is there additional code that prevents this happening as its pretty crucial to the criteria

[doncht]

if the market suspends (a goal is scored) the off set tick bet is cancelled.

Hi. has this been confirmed to be correct?

[Captain Sensible]

I think it's all down to when you place a bet as to whether it retains the "Keep in play" persistence. If you place a bet prior to the off any keep inplay persistence should be retained and the bet won't get cancelled regardless of any suspensions, if however you place the bet after the event has started you cannot attach any keep options to that bet as the event is now running, therefore any bets placed after the will be cancelled upon suspension of a goal/sending off as normal.

[vanbuuts]

Hi, thanks for the replies, unfortunately it makes the software un-usable for what I wish to do, as the suspended market is generally an indicator of a goal being scored and therefore changes in the odds

[Captain Sensible]

The way the "Keep" persistence works is down to Betfair's API not Gruss, every other API software out there will work with exactly the same API constraints.

Using a suspension to determine a goal is probably not the wisest of moves as Betfair outsource that side of things and they do seem to err on the side of caution and flick that suspension at the slightest sniff of a goal.

[vanbuuts]

My formula didn't use the suspension to trigger the bet, the odds determined that - but if unmatched bets are wiped out when markets suspend (using Gruss or any other type of BOT) I am best placing bets manually.

Was worth a go with this software, and its an interesting piece of kit, but unfortunately just not practical enough for my needs