Excwl trigger help!! (again)

[jmini123]

Hey guys, i am wondering if somebody could help me with writing a trigger?
I have a spreadsheet that places a lay bet on every horse in-play at a certain price, After the first horse has met the lay price criteria, All other bets are then cancelled.

I am looking to try and put a back trade on the said horse at for example 20ticks higher (with greening) and i have no idea how to actually right that into the sheet?

I hope for someone this could be easy to implement? I will send the sheet to anyone wanting to have a look at. It's the smash and grab sheet from the betting school, I'm not sure if gary actually wrote the sheet?? So some of you might be familiar with it?

thanks in advance

jmini123 [/code][/url]

[jmini123]

the sheet can be found here.

http://www.mediafire.com/?ahrvi4a2fjuhwtc

[milfor]

Sorry, my old Excel can't open .xlsm files only .xls files.

[jmini123]

ok mate, thanks anyway

[osknows]

Sorry, my old Excel can't open .xlsm files only .xls files.

MS provide conversion tools which will convert .xlsm and .xlsx files to the older .xls version. They work quite well except where the row/column limits are exceeded and data is just truncated

On the computer that has the earlier version of Excel installed, download the Microsoft Office Compatibility Pack for 2007 Office Word, Excel and PowerPoint File Formats from the Microsoft Office Downloads Web site and install the updates and converters that are needed to open Excel 2007 workbooks. http://www.microsoft.com/downloads/en/d ... layLang=en

[jmini123]

Ok, i understand that i will need the TLn trigger in the formula?? Where in the formula do i put it?

I'm really sorry for all the questiond but excel just goes over my head. I have to make a real effort to learn it properly,

jmini

=IF(AA5="","",IF($AC$3<>"auto","",IF($Q$1>15,"CLEAR",IF(AC5="","",IF($Q$1>5,"LAY-IP",IF($E$2<>"In Play","",IF(AG5="Y","",IF($AG$1<>0,"CANCEL",""))))))))

[milfor]

Replace "LAY-IP" with "LAY-TL20-IP" if you want 20 ticks profit.

[jmini123]

Replace "LAY-IP" with "LAY-TL20-IP" if you want 20 ticks profit.

Milfor, You are a gent.

I feel so silly. thakns again for you help.

[milfor]

No problem. Those lengthy formulas can give one a headache.