Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

INSIDE 60 SCAN USING 30 MIN FORMULA FOR TOP OF THE HOUR Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bison36
Posted : Monday, October 15, 2018 3:02:49 PM
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. 

 

 

Bruce_L
Posted : Tuesday, October 16, 2018 9:21:08 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.