New version 18 available now


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


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: Bruce_L
About
User Name: Bruce_L
Groups: Gold User, Platinum User, TeleChart, Worden Staff, Worden Training Agent
Rank: Worden Trainer
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, October 07, 2004
Last Visit: Monday, February 18, 2019 10:36:45 AM
Number of Posts: 64,759
[21.97% of all post / 12.34 posts per day]
Avatar
Last 10 Posts
Topic: Comparing current vs. previous day's bar (Intraday)
Posted: Friday, February 15, 2019 10:09:21 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: First Hour Range
Posted: Friday, February 15, 2019 8:37:20 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Indicator-based ratio
Posted: Friday, February 15, 2019 7:28:27 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: First Hour Range
Posted: Friday, February 15, 2019 7:26:18 PM

I am counting eleven 30 minute pre-market bars for those symbols including the bars ending at 4:30 AM ET and 9:30 AM ET. If this is correct and you are only interested in the 11th pre market bar, then please try the following for the high.

IIF(O'02/15/19' = O1 AND H'02/15/19' = H1 AND L'02/15/19' = L1 AND C'02/15/19' = C1 AND V'02/15/19' = V1, 1 / 0, IIF(O'02/15/19' = O2 AND H'02/15/19' = H2 AND L'02/15/19' = L2 AND C'02/15/19' = C2 AND V'02/15/19' = V2, 1 / 0, IIF(O'02/15/19' = O3 AND H'02/15/19' = H3 AND L'02/15/19' = L3 AND C'02/15/19' = C3 AND V'02/15/19' = V3, 1 / 0, IIF(O'02/15/19' = O4 AND H'02/15/19' = H4 AND L'02/15/19' = L4 AND C'02/15/19' = C4 AND V'02/15/19' = V4, 1 / 0, IIF(O'02/15/19' = O5 AND H'02/15/19' = H5 AND L'02/15/19' = L5 AND C'02/15/19' = C5 AND V'02/15/19' = V5, 1 / 0, IIF(O'02/15/19' = O6 AND H'02/15/19' = H6 AND L'02/15/19' = L6 AND C'02/15/19' = C6 AND V'02/15/19' = V6, 1 / 0, IIF(O'02/15/19' = O7 AND H'02/15/19' = H7 AND L'02/15/19' = L7 AND C'02/15/19' = C7 AND V'02/15/19' = V7, 1 / 0, IIF(O'02/15/19' = O8 AND H'02/15/19' = H8 AND L'02/15/19' = L8 AND C'02/15/19' = C8 AND V'02/15/19' = V8, 1 / 0, IIF(O'02/15/19' = O9 AND H'02/15/19' = H9 AND L'02/15/19' = L9 AND C'02/15/19' = C9 AND V'02/15/19' = V9, 1 / 0, IIF(O'02/15/19' = O10 AND H'02/15/19' = H10 AND L'02/15/19' = L10 AND C'02/15/19' = C10 AND V'02/15/19' = V10, 1 / 0, IIF(O'02/15/19' = O11 AND H'02/15/19' = H11 AND L'02/15/19' = L11 AND C'02/15/19' = C11 AND V'02/15/19' = V11, H, IIF(O'02/15/19' = O12 AND H'02/15/19' = H12 AND L'02/15/19' = L12 AND C'02/15/19' = C12 AND V'02/15/19' = V12, H1, IIF(O'02/15/19' = O13 AND H'02/15/19' = H13 AND L'02/15/19' = L13 AND C'02/15/19' = C13 AND V'02/15/19' = V13, H2, IIF(O'02/15/19' = O14 AND H'02/15/19' = H14 AND L'02/15/19' = L14 AND C'02/15/19' = C14 AND V'02/15/19' = V14, H3, IIF(O'02/15/19' = O15 AND H'02/15/19' = H15 AND L'02/15/19' = L15 AND C'02/15/19' = C15 AND V'02/15/19' = V15, H4, IIF(O'02/15/19' = O16 AND H'02/15/19' = H16 AND L'02/15/19' = L16 AND C'02/15/19' = C16 AND V'02/15/19' = V16, H5, IIF(O'02/15/19' = O17 AND H'02/15/19' = H17 AND L'02/15/19' = L17 AND C'02/15/19' = C17 AND V'02/15/19' = V17, H6, IIF(O'02/15/19' = O18 AND H'02/15/19' = H18 AND L'02/15/19' = L18 AND C'02/15/19' = C18 AND V'02/15/19' = V18, H7, IIF(O'02/15/19' = O19 AND H'02/15/19' = H19 AND L'02/15/19' = L19 AND C'02/15/19' = C19 AND V'02/15/19' = V19, H8, IIF(O'02/15/19' = O20 AND H'02/15/19' = H20 AND L'02/15/19' = L20 AND C'02/15/19' = C20 AND V'02/15/19' = V20, H9, IIF(O'02/15/19' = O21 AND H'02/15/19' = H21 AND L'02/15/19' = L21 AND C'02/15/19' = C21 AND V'02/15/19' = V21, H10, IIF(O'02/15/19' = O22 AND H'02/15/19' = H22 AND L'02/15/19' = L22 AND C'02/15/19' = C22 AND V'02/15/19' = V22, H11, IIF(O'02/15/19' = O23 AND H'02/15/19' = H23 AND L'02/15/19' = L23 AND C'02/15/19' = C23 AND V'02/15/19' = V23, H12, IIF(O'02/15/19' = O24 AND H'02/15/19' = H24 AND L'02/15/19' = L24 AND C'02/15/19' = C24 AND V'02/15/19' = V24, H13, IIF(O'02/15/19' = O25 AND H'02/15/19' = H25 AND L'02/15/19' = L25 AND C'02/15/19' = C25 AND V'02/15/19' = V25, H14, IIF(O'02/15/19' = O26 AND H'02/15/19' = H26 AND L'02/15/19' = L26 AND C'02/15/19' = C26 AND V'02/15/19' = V26, H15, IIF(O'02/15/19' = O27 AND H'02/15/19' = H27 AND L'02/15/19' = L27 AND C'02/15/19' = C27 AND V'02/15/19' = V27, H16, IIF(O'02/15/19' = O28 AND H'02/15/19' = H28 AND L'02/15/19' = L28 AND C'02/15/19' = C28 AND V'02/15/19' = V28, H17, IIF(O'02/15/19' = O29 AND H'02/15/19' = H29 AND L'02/15/19' = L29 AND C'02/15/19' = C29 AND V'02/15/19' = V29, H18, IIF(O'02/15/19' = O30 AND H'02/15/19' = H30 AND L'02/15/19' = L30 AND C'02/15/19' = C30 AND V'02/15/19' = V30, H19, IIF(O'02/15/19' = O31 AND H'02/15/19' = H31 AND L'02/15/19' = L31 AND C'02/15/19' = C31 AND V'02/15/19' = V31, H20, 1 / 0)))))))))))))))))))))))))))))))

And the following for the low.

IIF(O'02/15/19' = O1 AND H'02/15/19' = H1 AND L'02/15/19' = L1 AND C'02/15/19' = C1 AND V'02/15/19' = V1, 1 / 0, IIF(O'02/15/19' = O2 AND H'02/15/19' = H2 AND L'02/15/19' = L2 AND C'02/15/19' = C2 AND V'02/15/19' = V2, 1 / 0, IIF(O'02/15/19' = O3 AND H'02/15/19' = H3 AND L'02/15/19' = L3 AND C'02/15/19' = C3 AND V'02/15/19' = V3, 1 / 0, IIF(O'02/15/19' = O4 AND H'02/15/19' = H4 AND L'02/15/19' = L4 AND C'02/15/19' = C4 AND V'02/15/19' = V4, 1 / 0, IIF(O'02/15/19' = O5 AND H'02/15/19' = H5 AND L'02/15/19' = L5 AND C'02/15/19' = C5 AND V'02/15/19' = V5, 1 / 0, IIF(O'02/15/19' = O6 AND H'02/15/19' = H6 AND L'02/15/19' = L6 AND C'02/15/19' = C6 AND V'02/15/19' = V6, 1 / 0, IIF(O'02/15/19' = O7 AND H'02/15/19' = H7 AND L'02/15/19' = L7 AND C'02/15/19' = C7 AND V'02/15/19' = V7, 1 / 0, IIF(O'02/15/19' = O8 AND H'02/15/19' = H8 AND L'02/15/19' = L8 AND C'02/15/19' = C8 AND V'02/15/19' = V8, 1 / 0, IIF(O'02/15/19' = O9 AND H'02/15/19' = H9 AND L'02/15/19' = L9 AND C'02/15/19' = C9 AND V'02/15/19' = V9, 1 / 0, IIF(O'02/15/19' = O10 AND H'02/15/19' = H10 AND L'02/15/19' = L10 AND C'02/15/19' = C10 AND V'02/15/19' = V10, 1 / 0, IIF(O'02/15/19' = O11 AND H'02/15/19' = H11 AND L'02/15/19' = L11 AND C'02/15/19' = C11 AND V'02/15/19' = V11, L, IIF(O'02/15/19' = O12 AND H'02/15/19' = H12 AND L'02/15/19' = L12 AND C'02/15/19' = C12 AND V'02/15/19' = V12, L1, IIF(O'02/15/19' = O13 AND H'02/15/19' = H13 AND L'02/15/19' = L13 AND C'02/15/19' = C13 AND V'02/15/19' = V13, L2, IIF(O'02/15/19' = O14 AND H'02/15/19' = H14 AND L'02/15/19' = L14 AND C'02/15/19' = C14 AND V'02/15/19' = V14, L3, IIF(O'02/15/19' = O15 AND H'02/15/19' = H15 AND L'02/15/19' = L15 AND C'02/15/19' = C15 AND V'02/15/19' = V15, L4, IIF(O'02/15/19' = O16 AND H'02/15/19' = H16 AND L'02/15/19' = L16 AND C'02/15/19' = C16 AND V'02/15/19' = V16, L5, IIF(O'02/15/19' = O17 AND H'02/15/19' = H17 AND L'02/15/19' = L17 AND C'02/15/19' = C17 AND V'02/15/19' = V17, L6, IIF(O'02/15/19' = O18 AND H'02/15/19' = H18 AND L'02/15/19' = L18 AND C'02/15/19' = C18 AND V'02/15/19' = V18, L7, IIF(O'02/15/19' = O19 AND H'02/15/19' = H19 AND L'02/15/19' = L19 AND C'02/15/19' = C19 AND V'02/15/19' = V19, L8, IIF(O'02/15/19' = O20 AND H'02/15/19' = H20 AND L'02/15/19' = L20 AND C'02/15/19' = C20 AND V'02/15/19' = V20, L9, IIF(O'02/15/19' = O21 AND H'02/15/19' = H21 AND L'02/15/19' = L21 AND C'02/15/19' = C21 AND V'02/15/19' = V21, L10, IIF(O'02/15/19' = O22 AND H'02/15/19' = H22 AND L'02/15/19' = L22 AND C'02/15/19' = C22 AND V'02/15/19' = V22, L11, IIF(O'02/15/19' = O23 AND H'02/15/19' = H23 AND L'02/15/19' = L23 AND C'02/15/19' = C23 AND V'02/15/19' = V23, L12, IIF(O'02/15/19' = O24 AND H'02/15/19' = H24 AND L'02/15/19' = L24 AND C'02/15/19' = C24 AND V'02/15/19' = V24, L13, IIF(O'02/15/19' = O25 AND H'02/15/19' = H25 AND L'02/15/19' = L25 AND C'02/15/19' = C25 AND V'02/15/19' = V25, L14, IIF(O'02/15/19' = O26 AND H'02/15/19' = H26 AND L'02/15/19' = L26 AND C'02/15/19' = C26 AND V'02/15/19' = V26, L15, IIF(O'02/15/19' = O27 AND H'02/15/19' = H27 AND L'02/15/19' = L27 AND C'02/15/19' = C27 AND V'02/15/19' = V27, L16, IIF(O'02/15/19' = O28 AND H'02/15/19' = H28 AND L'02/15/19' = L28 AND C'02/15/19' = C28 AND V'02/15/19' = V28, L17, IIF(O'02/15/19' = O29 AND H'02/15/19' = H29 AND L'02/15/19' = L29 AND C'02/15/19' = C29 AND V'02/15/19' = V29, L18, IIF(O'02/15/19' = O30 AND H'02/15/19' = H30 AND L'02/15/19' = L30 AND C'02/15/19' = C30 AND V'02/15/19' = V30, L19, IIF(O'02/15/19' = O31 AND H'02/15/19' = H31 AND L'02/15/19' = L31 AND C'02/15/19' = C31 AND V'02/15/19' = V31, L20, 1 / 0)))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: First Hour Range
Posted: Friday, February 15, 2019 4:55:54 PM

OK, what stocks are you looking at that have 10 pre-market bars ?

Are you interested in the high and low of the entire pre market span (my assumption is this is what you wanted and that there are 10 pre market bars)?

Or are you just interested in the last 30-minute pre market bar?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: First Hour Range
Posted: Friday, February 15, 2019 4:25:47 PM

The following should work for the high between 4:30 AM and 9:30 AM (assuming this is 10 bars like you said).

IIF(O'02/15/19' = O1 AND H'02/15/19' = H1 AND L'02/15/19' = L1 AND C'02/15/19' = C1 AND V'02/15/19' = V1, H, IIF(O'02/15/19' = O2 AND H'02/15/19' = H2 AND L'02/15/19' = L2 AND C'02/15/19' = C2 AND V'02/15/19' = V2, MAXH2, IIF(O'02/15/19' = O3 AND H'02/15/19' = H3 AND L'02/15/19' = L3 AND C'02/15/19' = C3 AND V'02/15/19' = V3, MAXH3, IIF(O'02/15/19' = O4 AND H'02/15/19' = H4 AND L'02/15/19' = L4 AND C'02/15/19' = C4 AND V'02/15/19' = V4, MAXH4, IIF(O'02/15/19' = O5 AND H'02/15/19' = H5 AND L'02/15/19' = L5 AND C'02/15/19' = C5 AND V'02/15/19' = V5, MAXH5, IIF(O'02/15/19' = O6 AND H'02/15/19' = H6 AND L'02/15/19' = L6 AND C'02/15/19' = C6 AND V'02/15/19' = V6, MAXH6, IIF(O'02/15/19' = O7 AND H'02/15/19' = H7 AND L'02/15/19' = L7 AND C'02/15/19' = C7 AND V'02/15/19' = V7, MAXH7, IIF(O'02/15/19' = O8 AND H'02/15/19' = H8 AND L'02/15/19' = L8 AND C'02/15/19' = C8 AND V'02/15/19' = V8, MAXH8, IIF(O'02/15/19' = O9 AND H'02/15/19' = H9 AND L'02/15/19' = L9 AND C'02/15/19' = C9 AND V'02/15/19' = V9, MAXH9, IIF(O'02/15/19' = O10 AND H'02/15/19' = H10 AND L'02/15/19' = L10 AND C'02/15/19' = C10 AND V'02/15/19' = V10, MAXH10, IIF(O'02/15/19' = O11 AND H'02/15/19' = H11 AND L'02/15/19' = L11 AND C'02/15/19' = C11 AND V'02/15/19' = V11, MAXH10.1, IIF(O'02/15/19' = O12 AND H'02/15/19' = H12 AND L'02/15/19' = L12 AND C'02/15/19' = C12 AND V'02/15/19' = V12, MAXH10.2, IIF(O'02/15/19' = O13 AND H'02/15/19' = H13 AND L'02/15/19' = L13 AND C'02/15/19' = C13 AND V'02/15/19' = V13, MAXH10.3, IIF(O'02/15/19' = O14 AND H'02/15/19' = H14 AND L'02/15/19' = L14 AND C'02/15/19' = C14 AND V'02/15/19' = V14, MAXH10.4, IIF(O'02/15/19' = O15 AND H'02/15/19' = H15 AND L'02/15/19' = L15 AND C'02/15/19' = C15 AND V'02/15/19' = V15, MAXH10.5, IIF(O'02/15/19' = O16 AND H'02/15/19' = H16 AND L'02/15/19' = L16 AND C'02/15/19' = C16 AND V'02/15/19' = V16, MAXH10.6, IIF(O'02/15/19' = O17 AND H'02/15/19' = H17 AND L'02/15/19' = L17 AND C'02/15/19' = C17 AND V'02/15/19' = V17, MAXH10.7, IIF(O'02/15/19' = O18 AND H'02/15/19' = H18 AND L'02/15/19' = L18 AND C'02/15/19' = C18 AND V'02/15/19' = V18, MAXH10.8, IIF(O'02/15/19' = O19 AND H'02/15/19' = H19 AND L'02/15/19' = L19 AND C'02/15/19' = C19 AND V'02/15/19' = V19, MAXH10.9, IIF(O'02/15/19' = O20 AND H'02/15/19' = H20 AND L'02/15/19' = L20 AND C'02/15/19' = C20 AND V'02/15/19' = V20, MAXH10.10, IIF(O'02/15/19' = O21 AND H'02/15/19' = H21 AND L'02/15/19' = L21 AND C'02/15/19' = C21 AND V'02/15/19' = V21, MAXH10.11, IIF(O'02/15/19' = O22 AND H'02/15/19' = H22 AND L'02/15/19' = L22 AND C'02/15/19' = C22 AND V'02/15/19' = V22, MAXH10.12, IIF(O'02/15/19' = O23 AND H'02/15/19' = H23 AND L'02/15/19' = L23 AND C'02/15/19' = C23 AND V'02/15/19' = V23, MAXH10.13, 1 / 0)))))))))))))))))))))))

And the following should work for the low between 4:30 AM and 9:30 AM (using the same assumptions).

IIF(O'02/15/19' = O1 AND H'02/15/19' = H1 AND L'02/15/19' = L1 AND C'02/15/19' = C1 AND V'02/15/19' = V1, L, IIF(O'02/15/19' = O2 AND H'02/15/19' = H2 AND L'02/15/19' = L2 AND C'02/15/19' = C2 AND V'02/15/19' = V2, MINL2, IIF(O'02/15/19' = O3 AND H'02/15/19' = H3 AND L'02/15/19' = L3 AND C'02/15/19' = C3 AND V'02/15/19' = V3, MINL3, IIF(O'02/15/19' = O4 AND H'02/15/19' = H4 AND L'02/15/19' = L4 AND C'02/15/19' = C4 AND V'02/15/19' = V4, MINL4, IIF(O'02/15/19' = O5 AND H'02/15/19' = H5 AND L'02/15/19' = L5 AND C'02/15/19' = C5 AND V'02/15/19' = V5, MINL5, IIF(O'02/15/19' = O6 AND H'02/15/19' = H6 AND L'02/15/19' = L6 AND C'02/15/19' = C6 AND V'02/15/19' = V6, MINL6, IIF(O'02/15/19' = O7 AND H'02/15/19' = H7 AND L'02/15/19' = L7 AND C'02/15/19' = C7 AND V'02/15/19' = V7, MINL7, IIF(O'02/15/19' = O8 AND H'02/15/19' = H8 AND L'02/15/19' = L8 AND C'02/15/19' = C8 AND V'02/15/19' = V8, MINL8, IIF(O'02/15/19' = O9 AND H'02/15/19' = H9 AND L'02/15/19' = L9 AND C'02/15/19' = C9 AND V'02/15/19' = V9, MINL9, IIF(O'02/15/19' = O10 AND H'02/15/19' = H10 AND L'02/15/19' = L10 AND C'02/15/19' = C10 AND V'02/15/19' = V10, MINL10, IIF(O'02/15/19' = O11 AND H'02/15/19' = H11 AND L'02/15/19' = L11 AND C'02/15/19' = C11 AND V'02/15/19' = V11, MINL10.1, IIF(O'02/15/19' = O12 AND H'02/15/19' = H12 AND L'02/15/19' = L12 AND C'02/15/19' = C12 AND V'02/15/19' = V12, MINL10.2, IIF(O'02/15/19' = O13 AND H'02/15/19' = H13 AND L'02/15/19' = L13 AND C'02/15/19' = C13 AND V'02/15/19' = V13, MINL10.3, IIF(O'02/15/19' = O14 AND H'02/15/19' = H14 AND L'02/15/19' = L14 AND C'02/15/19' = C14 AND V'02/15/19' = V14, MINL10.4, IIF(O'02/15/19' = O15 AND H'02/15/19' = H15 AND L'02/15/19' = L15 AND C'02/15/19' = C15 AND V'02/15/19' = V15, MINL10.5, IIF(O'02/15/19' = O16 AND H'02/15/19' = H16 AND L'02/15/19' = L16 AND C'02/15/19' = C16 AND V'02/15/19' = V16, MINL10.6, IIF(O'02/15/19' = O17 AND H'02/15/19' = H17 AND L'02/15/19' = L17 AND C'02/15/19' = C17 AND V'02/15/19' = V17, MINL10.7, IIF(O'02/15/19' = O18 AND H'02/15/19' = H18 AND L'02/15/19' = L18 AND C'02/15/19' = C18 AND V'02/15/19' = V18, MINL10.8, IIF(O'02/15/19' = O19 AND H'02/15/19' = H19 AND L'02/15/19' = L19 AND C'02/15/19' = C19 AND V'02/15/19' = V19, MINL10.9, IIF(O'02/15/19' = O20 AND H'02/15/19' = H20 AND L'02/15/19' = L20 AND C'02/15/19' = C20 AND V'02/15/19' = V20, MINL10.10, IIF(O'02/15/19' = O21 AND H'02/15/19' = H21 AND L'02/15/19' = L21 AND C'02/15/19' = C21 AND V'02/15/19' = V21, MINL10.11, IIF(O'02/15/19' = O22 AND H'02/15/19' = H22 AND L'02/15/19' = L22 AND C'02/15/19' = C22 AND V'02/15/19' = V22, MINL10.12, IIF(O'02/15/19' = O23 AND H'02/15/19' = H23 AND L'02/15/19' = L23 AND C'02/15/19' = C23 AND V'02/15/19' = V23, MINL10.13, 1 / 0)))))))))))))))))))))))

This assumes pre / post market data is on, a 30 minute time frame, there are 10 exactly bars in this time span, and these are the only pre / post market bars after midnight ET. You will need to update the dates used in the formula for it to continue working.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: adding scan to a chart
Posted: Friday, February 15, 2019 3:50:46 PM

What is the period and average type of the moving average?

Is the Keltner Channel simple or exponential?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request PCF Formula Percentage
Posted: Friday, February 15, 2019 3:23:28 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: First Hour Range
Posted: Friday, February 15, 2019 3:17:54 PM

What gets identified in TC2000 v18+ when using the current date is the last bar of the previous trading day. If you don't know how many pre-market bars there are, it isn't possible to know what the value of the last pre-market bar might be because you don't know how many bars it happened after the last bar of the previous trading day.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request PCF Formula Percentage
Posted: Friday, February 15, 2019 2:35:33 PM

That should definitely pass the first formula.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles