Some help with tick offset trigger

[Timstertoo]

Maybe someone can give me a push in the right direction as I'm struggeling with getting this up and running.

I want to do a BACK trigger combined with the autolevel tickoffset trigger. That would be the "TLn" function where "n" determines the amount of ticks.

To get the trigger working you need to say "BACK-TL8" because if you don't use the "" it will not print it and not do the trigger.

But seeing as I'm difficult as always I want to get the "n" number from somewhere else and I want to substract a number from that to get to the exact offset I want.

So my trigger would look like "BACK-TL(Y14-2)" to get the number in Y14 minus 2 as my tick offset.

This doesn't work as it simply prints that whole statement and doesn't give me the result of the calculcation.

I also tried "BACK-TL"Y14-2 but this just gives me an error. "BACK-TL"(Y14-2) gives me an error too.

Any help would be greatly appreciated!

[Timstertoo]

Forget you can't edit here.

I also posted this on another forum so the explanation of the trigger probably sounds patronising but it was meant to help the other bot newbies understand what I was trying to do. So a combination of a question and a bit of explaining.

Rereading the post on this forum I realised the tone is wrong but I can't edit it so have to do it like this, my apologies!

[2020vision]

Hi Timstertoo

Although I am not exactly fluent with Excel or triggers you could try the following?
Give your "n" a label - e.g. tickoffset, (maybe= a cell value-x) and then try:
"LAY-TL" &tickoffset&

Does this help or make any sense? Hope so - Michael

P.S. Seems to be the way tickbotA10 works? (I think you know what I mean)?
Please forgive if I am totally wrong, just trying to help - thanks.

[Timstertoo]

Right under my eyes al along! DOH!

Thanks!

So it obviously works in the tickbot A10 but I keep getting an error in mine. Maybe I'm just not seeing it as it's pretty late over here.

This is what I had:

=IF(AND(AC14=0,AB14>tick_gap,H14>minOdds),"BACK" and this works.

Now I change it to:

=IF(AND(AC14=0,AB14>tick_gap,H14>minOdds),"BACK-TL"&test&

and I get an error.

And yes I made a cell, put a number in there and called it "test"

[Timstertoo]

Got it!

The second & shouldn't be there in my forumula as I have nothing after it that I want to tie together.

Thanks a lot 2020Vision! Now I can fix it, go to bed and see how much I lost tomorrow morning.

[2020vision]

Yes - my mistake about the second & - sorry about that

Have a profitable day - Michael