Support Board

Date/Time: Sat, 20 Apr 2024 12:32:34 +0000

Post From: Spreadsheet

[2019-08-01 16:34:29] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
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.