Gruss Forum • View topic

by **alrodopial** » Mon Dec 27, 2010 8:59 pm

Did you place the formulas:

3. Insert the following formula into cell R5.
=((Y5-1)/2)+1 (This is for the first runner)

by **john_boyuk** » Tue Dec 28, 2010 2:18 am

GaryRussell wrote:What exactly are you trying to do? Are you trying to back at SP and then lay at half that price?

The easiest thing to do would be to use the trigger BACKSP-P50 which will place a back bet at SP and lay bet at 50% of the matched odds. Also there are two ways of calculating 50% odds. You need to install the latest Beta version, see http://www.gruss-software.co.uk/forum/v ... php?t=5669

Once you have installed the latest Beta version it is important that you tick "Calculate tick % on decimal odds" in general preferences. This will ensure the odds are calculated how you expect. If you use this trigger then you don't need the VBA code to calculate the elapsed time from start of race. You also don't need to output the SP column.

Yes I am trying to back at SP and lay at half that price. Thanks for the info I'll look at the beta version

by **john_boyuk** » Tue Dec 28, 2010 2:19 am

alrodopial wrote:Did you place the formulas:

3. Insert the following formula into cell R5.
=((Y5-1)/2)+1 (This is for the first runner)

Yes I did

by **brumbie** » Tue Dec 28, 2010 6:10 am

If you are chasing a "green up" or "auto level profit" on the laybet then would it be:

BACKSP-PL50
or
BACK-SP-PL50
or
BACKSP-PL50-IP
or
BACK-SP-PL50-IP

thanks guys..
oh and also,do you still have to put a back price in high enough not to get matched and,if so,does the lay bet automatically adjust to half the SP price?

THANKS GUYS
:roll:

by **GaryRussell** » Tue Dec 28, 2010 8:31 am

brumbie wrote:If you are chasing a "green up" or "auto level profit" on the laybet then would it be:

BACKSP-PL50
or
BACK-SP-PL50
or
BACKSP-PL50-IP
or
BACK-SP-PL50-IP

thanks guys..
oh and also,do you still have to put a back price in high enough not to get matched and,if so,does the lay bet automatically adjust to half the SP price?

THANKS GUYS

You can either use BACKSP-PL50 and specify the minimum odds you will accept or BACK-PL50-SP and specify odds high enough to prevent getting matched. You cannot have -IP and -SP in the same trigger. They are mutually exclusive, the bet is either converted to SP at the off (-SP) or just retained (-IP).

by **brumbie** » Tue Dec 28, 2010 9:03 am

Thanks Gary for a quick reply

by **brumbie** » Tue Dec 28, 2010 9:22 am

So with BACKSP-PL50 I would have to specify odds that would be low enough for SP to be given (as in taking SP normally with BF)and

BACK-PL50-SP would act the same as long as I used a high enough price.
Either way the tick offset would still go into play without adding anything else?The reason i ask is I thought maybe the offset would simply cancel at SP or would be given as SP..A bit long winded I guess Gary.

by **GaryRussell** » Tue Dec 28, 2010 9:30 am

So with BACKSP-PL50 I would have to specify odds that would be low enough for SP to be given (as in taking SP normally with BF)and

BACK-PL50-SP would act the same as long as I used a high enough price.

Correct.

The offset bet is placed when the bet is matched which will happen after Betfair calculate the SP just after the off. The offset bet is always based on the matched price.

by **brumbie** » Tue Dec 28, 2010 9:41 am

Thanks again Gary,I had a quick try earlier but it said "invalid stake" in thebet ref cell but i'm sure thats because i was trying small stakes.

by **GaryRussell** » Tue Dec 28, 2010 9:50 am

brumbie wrote:Thanks again Gary,I had a quick try earlier but it said "invalid stake" in thebet ref cell but i'm sure thats because i was trying small stakes.

Yes, it will say invalid stake if you use BACKSP. You can use below minimum stakes if you use BACK-SP, this does not work however with LAY-SP.

by **brumbie** » Tue Dec 28, 2010 10:05 am

Thought as much,will try at southwell later on,thanks again Gary.

by **brumbie** » Tue Dec 28, 2010 1:43 pm

Yup,worked perfectly using BACK-SP with small stake :lol:

by **john_boyuk** » Tue Dec 28, 2010 11:57 pm

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?

by **john_boyuk** » Tue Dec 28, 2010 11:59 pm

john_boyuk wrote: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?

by **Captain Sensible** » Wed Dec 29, 2010 12:39 am

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

Laying at half sp

how do i place the lay stake?

Re: how do i place the lay stake?

Who is online

Sports betting software from Gruss Software