Multiple bets, different odds

[813615]

Morning guys, been searching the forum but unable to find if it's possible to place a number of bets on the same horse but different odds using formula rather than VBA as never used that? I've done the clear ref cell following the first bet being matched but not sure on how to specify different odds for the next bet? For example, I want to lay a horse whose SP is 10 at 8.0,5.0 & 3.0 is this possible?
Many thanks
Lee

[alrodopial]

something like this:
1. in AA column: AA5=If (T5<>"" ,AA5=AA5+1,0) ' bet placed counter
2. in odds column: R5=If(AA5=1,"first odds here",if(AA5=2,"second odds here" .....etc
3. circular reference should be enabled
4. at market change formula in AA5 should become the initial with counter = 0

[GaryRussell]

There is a little known feature where you specify multiple odds and stakes delimited by a pipe.
For example to lay £2 at 1.1, 1.2 and 1.3 put 1.1|1.2|1.3 in odds column and 2|2|2 in stake column

[alrodopial]

what is returned in bet reff column?

[813615]

Brilliant thank you guys, Gary that sounds the easiest of options for my limited skills on excel so will try that first, would I have to use the clear bet ref command for this to work?
Thank you all
Lee

[GaryRussell]

Brilliant thank you guys, Gary that sounds the easiest of options for my limited skills on excel so will try that first, would I have to use the clear bet ref command for this to work?
Thank you all
Lee

Yes. You always need to clear the bet ref column to allow more bets to be placed.

[GaryRussell]

what is returned in bet reff column?

Just the first bet reference. So in my example the odds were 1.1|1.2|1.3. The bet reference for the lay bet at 1.1 would be returned.

[813615]

Brilliant thank you guys, Gary that sounds the easiest of options for my limited skills on excel so will try that first, would I have to use the clear bet ref command for this to work?
Thank you all
Lee

Yes. You always need to clear the bet ref column to allow more bets to be placed.

Ok thanks all for a speedy reply
Lee

[813615]

Brilliant thank you guys, Gary that sounds the easiest of options for my limited skills on excel so will try that first, would I have to use the clear bet ref command for this to work?
Thank you all
Lee

Hi Gary and sorry for this. I've tried adding the pipe in the odds column and it won't accept it as I'm guessing it not in the right formula, I've googled how to do and found some info about adding like so '=AddDelimiter(AG5,AH5,AI5))' in the odds column (AG5, AH5, AI5 being the specified odds value) but all I get now is '#NAME' so guessing that's not right, any help please?
Thanks
Lee

[alrodopial]

Hi Gary and sorry for this. I've tried adding the pipe in the odds column and it won't accept it as I'm guessing it not in the right formula, I've googled how to do and found some info about adding like so '=AddDelimiter(AG5,AH5,AI5))' in the odds column (AG5, AH5, AI5 being the specified odds value) but all I get now is '#NAME' so guessing that's not right, any help please?
Thanks
Lee

R5 = AG5 & "|" & AH5 & "|" & AI5

[Captain Sensible]

There is a little known feature where you specify multiple odds and stakes delimited by a pipe.
For example to lay £2 at 1.1, 1.2 and 1.3 put 1.1|1.2|1.3 in odds column and 2|2|2 in stake column

Never knew about that, you should advertise it more as it's probably something a lot would use. Do the bets all go in the same place bets submission?

[813615]

Hi Gary and sorry for this. I've tried adding the pipe in the odds column and it won't accept it as I'm guessing it not in the right formula, I've googled how to do and found some info about adding like so '=AddDelimiter(AG5,AH5,AI5))' in the odds column (AG5, AH5, AI5 being the specified odds value) but all I get now is '#NAME' so guessing that's not right, any help please?
Thanks
Lee

R5 = AG5 & "|" & AH5 & "|" & AI5

Thank you

[GaryRussell]

There is a little known feature where you specify multiple odds and stakes delimited by a pipe.
For example to lay £2 at 1.1, 1.2 and 1.3 put 1.1|1.2|1.3 in odds column and 2|2|2 in stake column

Never knew about that, you should advertise it more as it's probably something a lot would use. Do the bets all go in the same place bets submission?

Yes they do.

[Captain Sensible]

Thanks, is it possible to place back and lay bets in the same submission with excel or would I need to code that using the COM

[GaryRussell]

Thanks, is it possible to place back and lay bets in the same submission with excel or would I need to code that using the COM

Sorry you will still need to use COM for this. It's something I can consider for a future version.