Support Board

Date/Time: Mon, 29 Apr 2024 08:01:46 +0000

Post From: Tick range calculator

[2023-10-14 13:38:28] Link To Thread - Link To Post [Go To First Post]
SSGill - Posts: 35
Hi, I am looking for something similar that I can use the spreadsheets alert system to develop. Having some trouble starting on the particular function I could use to 1) identify these ranges, 2) draw a rectangle box around them as in markuz's picture? on an ES futures chart if I wanted to identify any range bound horizontal trend, I could do the following.. I could have a lookback in column y such as =and(y13> (e3-10), y13< (e3+10), y12> (e3-10), y12< (e3+10), y11> (e3-10), y11< (e3+10), y10> (e3-10), y10< (e3+10), y9> (e3-10), y9< (e3+10), y8> (e3-10), y8< (e3+10), y7> (e3-10), y7< (e3+10) ETC, ETC but this has two problems; 1) would not be dynamic, and not be true if 8 bars ago, the price action just entered into the 10 point range. 2) not be able to identify any price action that was greater than 10 points OR longer than 10 bars. Hopefully someone knows a way to do this, or point me in the right direction!! Thanks in advance.