Login Page - Create Account

Support Board


Date/Time: Tue, 01 Jul 2025 08:57:55 +0000



Post From: Spreadsheet

[2019-08-01 16:34:29]
Sawtooth - Posts: 4231
You could try this:
= AND (E3 >= V3 + 0.25)
= AND (E3 <= V3-0.25)

You also may need to round the prices to the the rounded ticksize:
= AND (MROUND(E3,1/ROUND(1/$J$21,0)) >= MROUND(V3,1/ROUND(1/$J$21,0)) + 0.25)
= AND (MROUND(E3,1/ROUND(1/$J$21,0)) <= MROUND(V3,1/ROUND(1/$J$21,0)) -0.25)

How to act in such a way as to create a prerequisite for the execution of the order in case the price passes through the level and even if the price just touched the level and rebounded. In any case, it is necessary to execute the order. Which formula will be most effective in this case?
I don't know enough about your system to answer this.