Hi
It can be done using Excel, but it needs to be connected to MF.
a better way for this is to use a text file with selection names.
I think four triggers, I'll give you an idea with the greater than 4.79 pair of triggers
constant: name ba, value: total back amount (e.g. 20.00)
TRIGGER name: greater than 4.79 first half
back
price: back_price
amount: ba/2
all matching selections
once per market
conditions:
markets minutes before the off is less than 120
and selections name is in file...path to text file
and selections back price is equal or greater than 4.80
and selections back matched is equal to 0
TRIGGER name: greater than 4.79 second half
back
price: back_price
amount: ba/2
all matching selections
once per market
conditions:
trigger greater than 4.79 first half number of runs in the market is greater than 0
and markets minutes before the off is less than 5
and selections back matched is greater than 0
and selections back unmatched is equal to 0
please test in test mode
if you still want to go the Excel route let me know and I'll post something up