Lay trigger in spreadsheet

[manager1]

Can anyone suggest a formula for laying below a price by ticks?

For example if I have a price of $1.50 in a column, I want to lay only (not back and lay) 5 ticks below, or if I have a price of $50.00 in a column 5 ticks below is $40.00.

How do I account for tick size being different amounts?

I looked at the help file, but it seems that it is aimed at offset betting, not straight laying.

Also is there a code for if lay is matched, then lay at 1 tick lower as well?

Thanks.

[Ian]

See this thread

http://www.gruss-software.co.uk/forum/v ... ight=ticks

[manager1]

That's a big help thanks Ian, do you know if you can lay again another tick below, if the first lay is matched?

[Ian]

You would need some code to clear the bet ref etc. when your first bet was matched so that a second can be triggered.