Laying at half sp

[john_boyuk]

Think your trigger should be BACKSP-PL50 not BACKSP-P50 , using PL should mean the stake will be adjusted as a level profit stake and therefore be double the original stake. If you have £2 in the stake column it'll then trigger any offset once the bet is reported as matched i.e on SP reconciliation. Might be an idea to avoid having a quick refresh set as there shouldn't be any need for it using SP and you don't want any offset being caught in the reconciliation process

Thanks Capt.... I tried the formula BACKSP-PL50 and it came up with ERROR on the excel sheet in the Bet Ref cell. I'll try and give it another go tomorrow

[Captain Sensible]

Possible the offset got triggered whilst the market was in that twilight zone between reconciliation and the market suspension being lifted, that's why I suggested a slower refresh rate or maybe even use the setting in the tick offset to add a delay to the offset bet

[GaryRussell]

Think your trigger should be BACKSP-PL50 not BACKSP-P50 , using PL should mean the stake will be adjusted as a level profit stake and therefore be double the original stake. If you have £2 in the stake column it'll then trigger any offset once the bet is reported as matched i.e on SP reconciliation. Might be an idea to avoid having a quick refresh set as there shouldn't be any need for it using SP and you don't want any offset being caught in the reconciliation process

Thanks Capt.... I tried the formula BACKSP-PL50 and it came up with ERROR on the excel sheet in the Bet Ref cell. I'll try and give it another go tomorrow

ERROR would have related to the original back bet. Did you trigger it in play? BACKSP can only be used before the off.

[GaryRussell]

Also are you sure it just read "ERROR"? I made the error messages more meangingful in the version you are using and it should have had something appended to "ERROR".

[GaryRussell]

Ok so I used the formula BACKSP-P50 and then put in minimum back odds of 4.1 in the R cell and £4 in the S (Stake column) thinking this was my lay stake and I would have to put in an SP back bet seperately. However it placed an unmatched SP back for £4. How can I program it to double the lay price (£8) at half the SP odds? I did want to try this with a £2 back and a £4 lay at half the odds but I can't cancel the £4 SP back now. Not a problem but what have I done wrong? Can anybody help?

As Captain Sensible said it is BACKSP-PL50. As soon as this trigger is processed you will have an unmatched BACK SP bet. This is correct, it has not gone wrong at this point. It is now waiting for Betfair to reconcile the SP just after the off when this bet will be matched. As soon as BA detects it is matched it will place the lay bet.

You do not have to place a separate SP bet. BACKSP-PL50 is all you need. The stake you are specifying in column S is the back stake. The lay stake will be calculated by BA when the back bet is matched.

[john_boyuk]

Think your trigger should be BACKSP-PL50 not BACKSP-P50 , using PL should mean the stake will be adjusted as a level profit stake and therefore be double the original stake. If you have £2 in the stake column it'll then trigger any offset once the bet is reported as matched i.e on SP reconciliation. Might be an idea to avoid having a quick refresh set as there shouldn't be any need for it using SP and you don't want any offset being caught in the reconciliation process

Thanks Capt.... I tried the formula BACKSP-PL50 and it came up with ERROR on the excel sheet in the Bet Ref cell. I'll try and give it another go tomorrow

ERROR would have related to the original back bet. Did you trigger it in play? BACKSP can only be used before the off.

No I didn't trigger in in play Garry. I tried it last night for the 11.30 race today. I saw ERROR in the bet ref cell. I didn't see anything other than ERROR but I didn't double click on the cell to allow it to expand so there could have been more possibly. I then tried BACKSP-P50 which has placed an unmatched SP back bet which I can't cancel. Will I need to place my own lay for this one at the off or will this formula also place a lay bet?

[GaryRussell]

No I didn't trigger in in play Garry. I tried it last night for the 11.30 race today. I saw ERROR in the bet ref cell. I didn't see anything other than ERROR but I didn't double click on the cell to allow it to expand so there could have been more possibly. I then tried BACKSP-P50 which has placed an unmatched SP back bet which I can't cancel. Will I need to place my own lay for this one at the off or will this formula also place a lay bet?

You cannot cancel it because it is an SP bet, Betfair do not allow you to cancel SP bets. You will need to place your own lay for this after the off because BA "forgets" about offset settings when the program is closed or the market is changed which you probably have done since.

[john_boyuk]

No I didn't trigger in in play Garry. I tried it last night for the 11.30 race today. I saw ERROR in the bet ref cell. I didn't see anything other than ERROR but I didn't double click on the cell to allow it to expand so there could have been more possibly. I then tried BACKSP-P50 which has placed an unmatched SP back bet which I can't cancel. Will I need to place my own lay for this one at the off or will this formula also place a lay bet?

You cannot cancel it because it is an SP bet, Betfair do not allow you to cancel SP bets. You will need to place your own lay for this after the off because BA "forgets" about offset settings when the program is closed or the market is changed which you probably have done since.

I haven't closed the program actually so we'll see what happens. I'll let you know

[john_boyuk]

No I didn't trigger in in play Garry. I tried it last night for the 11.30 race today. I saw ERROR in the bet ref cell. I didn't see anything other than ERROR but I didn't double click on the cell to allow it to expand so there could have been more possibly. I then tried BACKSP-P50 which has placed an unmatched SP back bet which I can't cancel. Will I need to place my own lay for this one at the off or will this formula also place a lay bet?

You cannot cancel it because it is an SP bet, Betfair do not allow you to cancel SP bets. You will need to place your own lay for this after the off because BA "forgets" about offset settings when the program is closed or the market is changed which you probably have done since.

I haven't closed the program actually so we'll see what happens. I'll let you know

Ok it placed the SP back bet and then the lay bet but the lay bet was at the same £4 stake as the back bet. I have just tried BACKSP-PL50 and it worked. I used a £2 stake and it placed the back bet at SP of 19.84 and a lay bet of 10.0 at a stake of £3.97 and it dobbed!! Excellent thanks for all your help Garry and Captain Sensible...Really appreciated

[Ian]

Are you using patternform, johnboy ?

[brumbie]

I think the "dobbed" bit gave it away

[brumbie]

""because BA "forgets" about offset settings when the program is closed or the market is changed which you probably have done since.""



Talking about the market changing Gary,do you mean if the market gets suspended then the offset will cancel but the back bet would still go ahead?

[john_boyuk]

Are you using patternform, johnboy ?

Yes but just for the fancied ones from a shortlist. About 4 or 5 a day usually. Those just now were just to test out the excel formula and it worked a treat! The problem is when working all day the back price taken in the morning can drift quite a bit so by the time of the off you may need a lot more than half the odds to get the dob in!! This excel program will be great. i can set up my backs to take Sp and the lay will be automatically placed. been looking for something like this for a while.

[john_boyuk]

I think the "dobbed" bit gave it away

Lol.... yes i suppose it did really!!

[brumbie]

Good luck with those John,you can also use the BACK-PL50-SP trigger but you have to keep ur odds up to say around 900 on the back so the SP gets taken.Although you wont be able to stop the SP being taken if its below 2.02,and it will effectively be ajust a back bet therein afterwards,you can play with stakes below the minimum this way until you feel comfortable.