Formula for excell

[aelara]

Couple of things I need to find out if anyone would be so kind:
1. How can I (if possible) use the software/triggered betting to, for example, lay a horse when the race goes in play, say at 5.00 (up to here I know the formula for excel) and then have another lay go in if it goes to 4.00, another one at 3.00, etc.

2. How could I do the above but also have a back lay taken after any of the lay odds have been taken. For example, lay a horse for 4.00 after the race has gone in play, have a lay also for 3.00 and 2.00 but also have a back lay of say 10.00 set up if the horse drifts, regardless whether the 3.00 or 2.00 has been taken?

Hope anyone can understand what I'm looking for.
Tony

[Ian]

You can put the same market in multiple tabs and then into multiple sheets .... so you could have, say, the first sheet trigger a lay of 4.0, two and three do the same but at lower odds, and sheet 4 could read sheet 1 to decide whether to do the back bet.

[aelara]

Thanks for the reply. That works alright but I'm not sure I follow the back bit of the bet that you suggested. Would that need some new formula in excel?

[Spud]

Something along the lines of:

IF ('your first worksheet name'$T$5<=enter your stake/liability as a number,"BACK","") - where T5 would be the selection matched in your first lay, it could be T10 etc etc.