Percentage Offset

[Yorkie]

Hi all

Can anyone come up with a way to do this.

I want to place a percentage offset bet thru excel. Normally this is very simple with a "BACK-PL10-IP" trigger.
The trouble is i want the percentage value to be variable depending on the race and odds. The percentage drop i want is calculated by the spreadsheet and placed into cell AS6.
So in theory what i need is "BACK-PL(AS6)-IP" but obviously this isn't valid.

Anyone any ideas?

btw the reason for the variable percentage is to try and get a fixed percentage of stake profit regardless of odds, something i know Gary has mentioned adding in the past but as far as i'm aware hasn't yet.

Yorkie

[MarkRussell]

Hi,

You can concatenate strings with the variable value from AS6, e.g.

="BACK-PL"&AS6&"-IP"

Regards,
Mark

[Yorkie]

Cheers Mark, works perfect