Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 condition true on a 10min bar throughout a trading day Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
Macgyver9791
 Posted : Thursday, March 21, 2019 3:18:54 PM
Registered User
Joined: 10/27/2016
Posts: 9

Hi,

I'm trying to put a scan together that gives me stocks in a listthat is true throughout the trading day but on a 10min chart

suppose I'm looking for a close on a 10min bar that is within 10% of the high of that bar. On the list all stocks that have that condition true from the start of the trading day until the end of the trading day. when market is closed I can scan it without trouble because nothing changes anymore. how can I do this when I refresh the scan through-out the day to see which new stocks come on the list.

So the first 10min of the trading day the scan has to go through the first 10min bar, in time window 10-20min the scan needs to go through the first two 10min bars and so on ...

Is this possible?

Bruce_L
 Posted : Thursday, March 21, 2019 3:35:27 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There really isn't any good way of doing this because there isn't a reliable method of determining how many bars have passed in the trading day so far.

The following condition formula relies on the open, high, low, close, and volume of the last 10-minute bar of the previous trading day being unique when compared to the rest of the bars in the available data.

And that it is not its only limitation. You would also need to edit the formula each and every trading day to change the date (although this can be done using the replace function in a text editor).

`IIF(O'03/25/19' = O1 AND H'03/25/19' = H1 AND L'03/25/19' = L1 AND C'03/25/19' = C1 AND V'03/25/19' = V1, CountTrue(STOC1 >= 90, 1), IIF(O'03/25/19' = O2 AND H'03/25/19' = H2 AND L'03/25/19' = L2 AND C'03/25/19' = C2 AND V'03/25/19' = V2, CountTrue(STOC1 >= 90, 2), IIF(O'03/25/19' = O3 AND H'03/25/19' = H3 AND L'03/25/19' = L3 AND C'03/25/19' = C3 AND V'03/25/19' = V3, CountTrue(STOC1 >= 90, 3), IIF(O'03/25/19' = O4 AND H'03/25/19' = H4 AND L'03/25/19' = L4 AND C'03/25/19' = C4 AND V'03/25/19' = V4, CountTrue(STOC1 >= 90, 4), IIF(O'03/25/19' = O5 AND H'03/25/19' = H5 AND L'03/25/19' = L5 AND C'03/25/19' = C5 AND V'03/25/19' = V5, CountTrue(STOC1 >= 90, 5), IIF(O'03/25/19' = O6 AND H'03/25/19' = H6 AND L'03/25/19' = L6 AND C'03/25/19' = C6 AND V'03/25/19' = V6, CountTrue(STOC1 >= 90, 6), IIF(O'03/25/19' = O7 AND H'03/25/19' = H7 AND L'03/25/19' = L7 AND C'03/25/19' = C7 AND V'03/25/19' = V7, CountTrue(STOC1 >= 90, 7), IIF(O'03/25/19' = O8 AND H'03/25/19' = H8 AND L'03/25/19' = L8 AND C'03/25/19' = C8 AND V'03/25/19' = V8, CountTrue(STOC1 >= 90, 8), IIF(O'03/25/19' = O9 AND H'03/25/19' = H9 AND L'03/25/19' = L9 AND C'03/25/19' = C9 AND V'03/25/19' = V9, CountTrue(STOC1 >= 90, 9), IIF(O'03/25/19' = O10 AND H'03/25/19' = H10 AND L'03/25/19' = L10 AND C'03/25/19' = C10 AND V'03/25/19' = V10, CountTrue(STOC1 >= 90, 10), IIF(O'03/25/19' = O11 AND H'03/25/19' = H11 AND L'03/25/19' = L11 AND C'03/25/19' = C11 AND V'03/25/19' = V11, CountTrue(STOC1 >= 90, 11), IIF(O'03/25/19' = O12 AND H'03/25/19' = H12 AND L'03/25/19' = L12 AND C'03/25/19' = C12 AND V'03/25/19' = V12, CountTrue(STOC1 >= 90, 12), IIF(O'03/25/19' = O13 AND H'03/25/19' = H13 AND L'03/25/19' = L13 AND C'03/25/19' = C13 AND V'03/25/19' = V13, CountTrue(STOC1 >= 90, 13), IIF(O'03/25/19' = O14 AND H'03/25/19' = H14 AND L'03/25/19' = L14 AND C'03/25/19' = C14 AND V'03/25/19' = V14, CountTrue(STOC1 >= 90, 14), IIF(O'03/25/19' = O15 AND H'03/25/19' = H15 AND L'03/25/19' = L15 AND C'03/25/19' = C15 AND V'03/25/19' = V15, CountTrue(STOC1 >= 90, 15), IIF(O'03/25/19' = O16 AND H'03/25/19' = H16 AND L'03/25/19' = L16 AND C'03/25/19' = C16 AND V'03/25/19' = V16, CountTrue(STOC1 >= 90, 16), IIF(O'03/25/19' = O17 AND H'03/25/19' = H17 AND L'03/25/19' = L17 AND C'03/25/19' = C17 AND V'03/25/19' = V17, CountTrue(STOC1 >= 90, 17), IIF(O'03/25/19' = O18 AND H'03/25/19' = H18 AND L'03/25/19' = L18 AND C'03/25/19' = C18 AND V'03/25/19' = V18, CountTrue(STOC1 >= 90, 18), IIF(O'03/25/19' = O19 AND H'03/25/19' = H19 AND L'03/25/19' = L19 AND C'03/25/19' = C19 AND V'03/25/19' = V19, CountTrue(STOC1 >= 90, 19), IIF(O'03/25/19' = O20 AND H'03/25/19' = H20 AND L'03/25/19' = L20 AND C'03/25/19' = C20 AND V'03/25/19' = V20, CountTrue(STOC1 >= 90, 20), IIF(O'03/25/19' = O21 AND H'03/25/19' = H21 AND L'03/25/19' = L21 AND C'03/25/19' = C21 AND V'03/25/19' = V21, CountTrue(STOC1 >= 90, 21), IIF(O'03/25/19' = O22 AND H'03/25/19' = H22 AND L'03/25/19' = L22 AND C'03/25/19' = C22 AND V'03/25/19' = V22, CountTrue(STOC1 >= 90, 22), IIF(O'03/25/19' = O23 AND H'03/25/19' = H23 AND L'03/25/19' = L23 AND C'03/25/19' = C23 AND V'03/25/19' = V23, CountTrue(STOC1 >= 90, 23), IIF(O'03/25/19' = O24 AND H'03/25/19' = H24 AND L'03/25/19' = L24 AND C'03/25/19' = C24 AND V'03/25/19' = V24, CountTrue(STOC1 >= 90, 24), IIF(O'03/25/19' = O25 AND H'03/25/19' = H25 AND L'03/25/19' = L25 AND C'03/25/19' = C25 AND V'03/25/19' = V25, CountTrue(STOC1 >= 90, 25), IIF(O'03/25/19' = O26 AND H'03/25/19' = H26 AND L'03/25/19' = L26 AND C'03/25/19' = C26 AND V'03/25/19' = V26, CountTrue(STOC1 >= 90, 26), IIF(O'03/25/19' = O27 AND H'03/25/19' = H27 AND L'03/25/19' = L27 AND C'03/25/19' = C27 AND V'03/25/19' = V27, CountTrue(STOC1 >= 90, 27), IIF(O'03/25/19' = O28 AND H'03/25/19' = H28 AND L'03/25/19' = L28 AND C'03/25/19' = C28 AND V'03/25/19' = V28, CountTrue(STOC1 >= 90, 28), IIF(O'03/25/19' = O29 AND H'03/25/19' = H29 AND L'03/25/19' = L29 AND C'03/25/19' = C29 AND V'03/25/19' = V29, CountTrue(STOC1 >= 90, 29), IIF(O'03/25/19' = O30 AND H'03/25/19' = H30 AND L'03/25/19' = L30 AND C'03/25/19' = C30 AND V'03/25/19' = V30, CountTrue(STOC1 >= 90, 30), IIF(O'03/25/19' = O31 AND H'03/25/19' = H31 AND L'03/25/19' = L31 AND C'03/25/19' = C31 AND V'03/25/19' = V31, CountTrue(STOC1 >= 90, 31), IIF(O'03/25/19' = O32 AND H'03/25/19' = H32 AND L'03/25/19' = L32 AND C'03/25/19' = C32 AND V'03/25/19' = V32, CountTrue(STOC1 >= 90, 32), IIF(O'03/25/19' = O33 AND H'03/25/19' = H33 AND L'03/25/19' = L33 AND C'03/25/19' = C33 AND V'03/25/19' = V33, CountTrue(STOC1 >= 90, 33), IIF(O'03/25/19' = O34 AND H'03/25/19' = H34 AND L'03/25/19' = L34 AND C'03/25/19' = C34 AND V'03/25/19' = V34, CountTrue(STOC1 >= 90, 34), IIF(O'03/25/19' = O35 AND H'03/25/19' = H35 AND L'03/25/19' = L35 AND C'03/25/19' = C35 AND V'03/25/19' = V35, CountTrue(STOC1 >= 90, 35), IIF(O'03/25/19' = O36 AND H'03/25/19' = H36 AND L'03/25/19' = L36 AND C'03/25/19' = C36 AND V'03/25/19' = V36, CountTrue(STOC1 >= 90, 36), IIF(O'03/25/19' = O37 AND H'03/25/19' = H37 AND L'03/25/19' = L37 AND C'03/25/19' = C37 AND V'03/25/19' = V37, CountTrue(STOC1 >= 90, 37), IIF(O'03/25/19' = O38 AND H'03/25/19' = H38 AND L'03/25/19' = L38 AND C'03/25/19' = C38 AND V'03/25/19' = V38, CountTrue(STOC1 >= 90, 38), IIF(O'03/25/19' = O39 AND H'03/25/19' = H39 AND L'03/25/19' = L39 AND C'03/25/19' = C39 AND V'03/25/19' = V39, CountTrue(STOC1 >= 90, 39), 1 / 0))))))))))))))))))))))))))))))))))))))) > 0`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Macgyver9791
 Posted : Thursday, March 21, 2019 4:13:35 PM
Registered User
Joined: 10/27/2016
Posts: 9

Thank you Bruce for the inspiration. Maybe an idea to develop something like this in a next version?

Bruce_L
 Posted : Thursday, March 21, 2019 4:26:07 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138