Multiple betting rules on a single contender/runner

[leshi86]

Hi Guys,

I'm looking to start building my own betting bot and just had a question about BA's excel functionality.

From my understanding of reading the BA guide, in each market, each outcome/runner only has 1 cell in which you can edit the betting rule (in the case of the first outcome in each market, that is cell L9).

What I was wondering is if I want to have 2 or more separate rules for when to place a back/lay on a single outcome, is multiple nested ifs the only way? Or is there a command I can use in the bet rules fields to tell BA which outcome I want the rule to apply to?

Thanks

[Euler]

Just create a seperate sheet and create your conditions in that sheet. Then have a final result cell in that sheet that outputs a true or false. Use that on the main Excel sheet to fire bets.

[leshi86]

Thanks for your reply Euler but I think either you've misunderstood what I was trying to say or what you've described is still a form of "nested if". Perhaps I should say I want simultaneous multiple conditions.

What I want to do, just as an an example, is:

If the back price becomes 3 AND the lay price is 3.2 then
put in a back at 3.2 and a lay at 3 simultaneously.

From my understanding according to your suggestion this would only be possible in conjunction with VBA, or, without VBA there would need to be many if statements everywhere. Perhaps you could give an example of how you might do the above example?

Thanks.