LAYR

[Kentucky]

Hi All

Could someone explain how the LAYR trigger works?

What I want to do is use LAYR-F5

The way I see it is using the above trigger if the the bet is not matched after 5 seconds it will be cancelled and then resubmitted is this correct?

What happens if the bet is partially matched?

What happens if the bet is fully matched?

Thanks in advance

[2020vision]

Hi Kentucky, hope this helps?

The way I see it is using the above trigger if the the bet is not matched after 5 seconds it will be cancelled and then resubmitted is this correct?

This will be CANCELLED after 5 seconds and not resubmitted - you need to clear the
bet ref cell afterwards to enable another bet.

If you use the BACKR or LAYR triggers the bet reference will have N as the suffix (e.g 3230882684N)
which prevents the software from looping endlessly replacing your bet.

What happens if the bet is partially matched?

If a bet is partially matched and the unmatched portion has not been cancelled then the
bet reference will have P as the suffix (eg. 3230882684P). If the remainder of the stake is
subsequently matched then the P will be removed from the bet ref. If the unmatched portion
is cancelled (either manually or using CANCEL trigger) then the P will be removed.

What happens if the bet is fully matched?

From the above I hope I am right in assuming that the bet ref will be suffixed with N?

Regards - Michael

[GaryRussell]

LAYR is for replacing a bet at different stake and odds. It will cancel the unmatched bet and place it again. I provided it because Betfair do not allow you to update the odds and stake in one request. The new bet will have N appended to the reference to prevent it doing this over and over again.

What happens if the bet is partially matched?

LAYR will not trigger at all against partially matched bets.

What happens if the bet is fully matched?

Fill or kill applied to LAYR doesn't really have a use. LAYR is expecting to find a bet reference in column T, but this won't be there if the bet was fully cancelled.

[Kentucky]

I'm a little confused now

2020 says
This will be CANCELLED after 5 seconds and not resubmitted - you need to clear the
bet ref cell afterwards to enable another bet.

yet Gary says
It will cancel the unmatched bet and place it again. I provided it because Betfair do not allow you to update the odds and stake in one request. The new bet will have N appended to the reference to prevent it doing this over and over again.

I understand that if it is partially matched then nothing will happen
and if it is fully matched before the 5 second then nothing will happen

Its just the LAYR-F5 not being matched within 5 seconds

the stake will not change but the odds will change Will I have to clear the T column? If so what is there a TRIGGER I can use?

Thanks
Ken

[2020vision]

Hi Kentucky

hope this is ok to say but I actually opened BA and placed bets using LAYR-F5.
The bet is indeed placed and bet ref generated...

The result was after 5 seconds the bet ref showed CANCELLED and did not
change or remove itself. After about a minute I simply deleted CANCELLED
and guess what? Another bet was placed and that in turn went CANCELLED.

That's hands on experience to me, hope Gary is ok with me being so precise?
Hence I said if you want a repeat get CANCELLED removed. Seems to work
when used like this exactly the same as LAY-F5 - unless I have missed something?

Thanks again - Michael

P.S. Try it for yourself using £2 stake and very low unmatchable odds?
Looks to me like LAYR should be used to overwrite an already existing bet?

[GaryRussell]

Hi Kentucky

hope this is ok to say but I actually opened BA and placed bets using LAYR-F5.
The bet is indeed placed and bet ref generated...

The result was after 5 seconds the bet ref showed CANCELLED and did not
change or remove itself. After about a minute I simply deleted CANCELLED
and guess what? Another bet was placed and that in turn went CANCELLED.

That's hands on experience to me, hope Gary is ok with me being so precise?
Hence I said if you want a repeat get CANCELLED removed. Seems to work
when used like this exactly the same as LAY-F5 - unless I have missed something?

Thanks again - Michael

P.S. Try it for yourself using £2 stake and very low unmatchable odds?
Looks to me like LAYR should be used to overwrite an already existing bet?

I think that's the point. He thought LAYR-F5 would automatically allow another bet to be placed after fill or kill cancelled the bet. It is as you say no different to LAY-F5 when used like this.

[GaryRussell]

I'm a little confused now

2020 says
This will be CANCELLED after 5 seconds and not resubmitted - you need to clear the
bet ref cell afterwards to enable another bet.

yet Gary says
It will cancel the unmatched bet and place it again. I provided it because Betfair do not allow you to update the odds and stake in one request. The new bet will have N appended to the reference to prevent it doing this over and over again.

I understand that if it is partially matched then nothing will happen
and if it is fully matched before the 5 second then nothing will happen

Its just the LAYR-F5 not being matched within 5 seconds

the stake will not change but the odds will change Will I have to clear the T column? If so what is there a TRIGGER I can use?

Thanks
Ken

You can just use LAY-F5 and use the CLEAR trigger to clear column T to allow another bet to be placed. Your formula should check for "CANCELLED" appearing in column T and then use the CLEAR trigger.

[Kentucky]

I think I get this now

If I Use LAYR-F5-CLEAR

will that work?

or should I include another formula

If (T5="CANCELLED","CLEAR","")

Thanks

Ken

[2020vision]

If I Use LAYR-F5-CLEAR

will that work?

or should I include another formula

If (T5="CANCELLED","CLEAR","")

Kentucky - neither of those triggers will work for you...

If you place the following trigger in Q5 then it will do what you seem to be asking?
It will place a lay bet at odds in column R for stakes in column S, if not filled
it will then be killed after 5 seconds, then it will be resubmitted - during which
time the odds available may have changed?

=IF(T5="CANCELLED","CLEAR",(IF(T5="","LAYR-F5")))

However in my tests it appeared to keep going around in a loop - is this what
you wanted? Also using standard LAY-F5 does exactly the same thing as LAYR-F5.
To gain more control over this you would have to add more conditions.

Hope this is informative and helps you to grasp things?

Ttfn - Michael

P.S. If more experienced users read this and want to join in, be my guest
because to be honest I am just starting to try and get my head around
this interesting aspect of using BA after many months of manual trading.

[Kentucky]

Thanks for that will try it today

Kentucky

[2020vision]

Quick update Kentucky...

On reflection I noticed False kept appearing - trigger below
should correct this? Makes no difference how it works - just tidier.

=IF(T5="CANCELLED","CLEAR",(IF(T5="","LAYR-F5","")))

Ttfn - Michael

[Kentucky]

Everything seems to be working fine now
Thanks for all your help

Kentucky

[eclipse]

Will LAYR replace a stop loss bet that hasn't been matched?

[GaryRussell]

Will LAYR replace a stop loss bet that hasn't been matched?

No. It is equivalent to using CANCEL and then using LAY.

[Drunkenight]

=IF(T5="CANCELLED","CLEAR",(IF(T5="","LAYR-F5","")))

This will clear the bet and place a new bet only if the bet is unmatched. Which I am sure is what Ken wants. I was just wondering if you know a good way of placing a new bet regardless of whether the bet is matched or not.