Registered User Joined: 1/2/2018 Posts: 3
|
I have been attempting to create a formula for a condition in a scan that shows me inside 60 min bars by using some sort of code to find them from the 30 minute chart, as the hourly on tc2000 does not update at the bottom of the hour. Essentially, the lowest low of the current bar and the previous bar should be greater than the lowest low of the bars 2 and 3 bars ago. Something like so: https://i.imgur.com/g9nXfEp.png right off the open would not be an inside 60 using tc2000 hourly scan but I am wondering if there is some logic to fix that problem.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You would need to change the dates each day and it won't work for all symbols since the closing 30-minute bar of the previous trading day needs to have an open, high, low, close, and volume distinct enough to identify that particular bar, but you might want to try something similar to the following.
IIF(SinceTrue(O = O'10/16/18' AND H = H'10/16/18' AND L = L'10/16/18' AND C = C'10/16/18' AND V = V'10/16/18', 14) > 0, IIF(SinceTrue(O = O'10/16/18' AND H = H'10/16/18' AND L = L'10/16/18' AND C = C'10/16/18' AND V = V'10/16/18', 14) MOD 2 > 0, ABS(MINL2.1 < L AND H < MAXH2.1), ABS(MINL2.2 < MINL2 AND MAXH2 < MAXH2.2)), 0) > 0
-Bruce Personal Criteria Formulas TC2000 Support Articles
|