| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 23
|
Is there a way to write a formula to find the maximum high of a series of days? it would look something like: Max (H2,H3....Hn). A search of all the tc functions and formula offers nothing I could find that satisfies the question.
|
|
Registered User
Joined: 9/27/2010
Posts: 11
|
Will this work for you? MaxH15.35 which is the max high over 15 days 35 days ago or any numbers you might want to substitute.
|
|
Registered User
Joined: 10/7/2004
Posts: 23
|
No this doesn't work since it includes today. I want an arbitrary sequence of days, for example:
H3,H4,H5....Hn
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, brucecj's suggestion does in fact work. Lets say you wanted the highest high for the bars H3, H4, H5, H6, H7, H8, H9 and H10. The number of bars in this sequence is 8 and the number of bars ago of the most recent bar is 3. This means the formula would be:
MAXH8.3
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 23
|
Thank you both, you are absolutely correct.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |