Using a tick offset from excel

[markg]

Hi,

I'm looking to try and hedge out all my bets in-play at a percentage of the odds I back at, e.g. if I back at 10 I want to trade out at 50% of the odds (5) and if I back at 4 then at 2 etc. I noticed in the user guide that the tick offset function only applies to bets that are placed either from the Grid interface or the Ladder interface and not from excel. Also, I need to specify that the bet only needs to be placed if the first one is matched and needs to go in-play. How do I go about implementing this?

Thanks,

Mark

[markg]

Note, I'm currently using the Place_bets excel sheet if there's an easy way to do this from modification of this sheet.

[kiint]

Mark,

For your backing at 10.0 example, you would need to set the odds column to 10.0 and then put in a trigger: BACK-TF5-IPC

Then, if your back at 10.0 is matched, an offset lay at 5.0 would be placed and it would be set to keep in play.

I haven't looked at the spreadsheet you mention so you will have to work out how to calculate the offset odds and form the trigger text.

Cheers,
Kiint

[markg]

Ah, I've now found the page in the manual with those sorts of commands and I think BACK-PL(insert percentage here)-IPC is what I'm looking for. However I'm unclear on how the % works. The example given in the text is "50% at odds of 3 would put in a bet at odds of 2" - does this mean the odds are a percentage of the tick offset? I.e. 2 x 150% = 3 ? So if I wanted my tickoffset bet to be at half of the odds I'd need to put in 100% as 1.5 x 200% = 3 ?

Also, using the default Place_bets sheet (http://www.gruss-software.co.uk/Betting ... p/help.htm Using excel -> sample sheets) I see I can put in -PL50-IPC in the Trigger modifier section. Is there a simple change I can make so the trigger modifier only affects back bets but leaves my lay bets alone?

Thanks,

Mark

[GaryRussell]

Ah, I've now found the page in the manual with those sorts of commands and I think BACK-PL(insert percentage here)-IPC is what I'm looking for. However I'm unclear on how the % works. The example given in the text is "50% at odds of 3 would put in a bet at odds of 2" - does this mean the odds are a percentage of the tick offset? I.e. 2 x 150% = 3 ? So if I wanted my tickoffset bet to be at half of the odds I'd need to put in 100% as 1.5 x 200% = 3 ?

The value you specify for tick offset is the percentage, but it's calculated on fractional odds, not decimal odds. eg. if the back odds are 10.0 with a 50% offset then the lay odds will be 5.5. (5.5 = (9/2)+1)

Also, using the default Place_bets sheet (http://www.gruss-software.co.uk/Betting ... p/help.htm Using excel -> sample sheets) I see I can put in -PL50-IPC in the Trigger modifier section. Is there a simple change I can make so the trigger modifier only affects back bets but leaves my lay bets alone?

You could change the formula in the trigger column so it does not append the trigger modifier.
eg. in cell Q5 you could change the formula to read as follows then copy the formula to Q6:Q55

Code: Select all

=IF(AND(E$2="Not In Play",F$2<>"Suspended"),IF(AA5="BACK",IF(AND(Z5=A5,AG5="N",$AJ$5="Y"),AA5 & AA$2,""),IF(AND(Z5=A5,AF5="N",$AJ$5="Y"),AA5,"")),"")

[markg]

Ah, I've now found the page in the manual with those sorts of commands and I think BACK-PL(insert percentage here)-IPC is what I'm looking for. However I'm unclear on how the % works. The example given in the text is "50% at odds of 3 would put in a bet at odds of 2" - does this mean the odds are a percentage of the tick offset? I.e. 2 x 150% = 3 ? So if I wanted my tickoffset bet to be at half of the odds I'd need to put in 100% as 1.5 x 200% = 3 ?

The value you specify for tick offset is the percentage, but it's calculated on fractional odds, not decimal odds. eg. if the back odds are 10.0 with a 50% offset then the lay odds will be 5.5. (5.5 = (9/2)+1)

Also, using the default Place_bets sheet (http://www.gruss-software.co.uk/Betting ... p/help.htm Using excel -> sample sheets) I see I can put in -PL50-IPC in the Trigger modifier section. Is there a simple change I can make so the trigger modifier only affects back bets but leaves my lay bets alone?

You could change the formula in the trigger column so it does not append the trigger modifier.
eg. in cell Q5 you could change the formula to read as follows then copy the formula to Q6:Q55

Code: Select all

=IF(AND(E$2="Not In Play",F$2<>"Suspended"),IF(AA5="BACK",IF(AND(Z5=A5,AG5="N",$AJ$5="Y"),AA5 & AA$2,""),IF(AND(Z5=A5,AF5="N",$AJ$5="Y"),AA5,"")),"")

OK, so for the percentages if I put in PL70 and I backed at 10 I'd get (9*0.3 + 1) as my lay bet, so 3.7?

Does that code remove trigger modifying completely or just for LAY bets? I want the -PL70-IPC modifier for my BACK bets but not for my LAY bets but that code looks like it just leaves out modifiers all together?

Thanks very much for your help again.

[GaryRussell]

OK, so for the percentages if I put in PL70 and I backed at 10 I'd get (9*0.3 + 1) as my lay bet, so 3.7?

That is correct.

Does that code remove trigger modifying completely or just for LAY bets? I want the -PL70-IPC modifier for my BACK bets but not for my LAY bets but that code looks like it just leaves out modifiers all together?

It only excludes the modifier for lay bets.
See "AA5 & AA$2" below. This is where the modifier is appended and I only removed it from the part of the formula which appends it to the LAY trigger.

Code: Select all

IF(AA5="BACK",IF(AND(Z5=A5,AG5="N",$AJ$5="Y"),AA5 & AA$2,

[markg]

Brilliant, thank you very much!