| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/5/2016
Posts: 71
|
How to use the formula expression--- max(xavgh.10,xavgl.30)
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Not sure what you're trying to do here.
|
|
Registered User
Joined: 10/5/2016
Posts: 71
|
10 days high compared with low 30 days，Taking the maximum。or max(xavgh.10,xavgh.30)
？
|
|
Registered User
Joined: 9/17/2010
Posts: 484
|
XAvgH10 would be the Exponential Average of Highs over the past 10 days
XAvgL30 would be the Exponential Average of Lows over the past 30 days
If you want the actual highs and lows:
MaxH10 and MinL30
Difference between the two:
MaxH10 - MinL30
Is this getting closer to what you are looking for?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In addition, I supsect you want the GREATEST() and LEAST() functions for at least part of this as these return the highest and lowest values in a a list.
The MAX() and MIN() functions return the highest and lowest values of a formula over time.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/5/2016
Posts: 71
|
Thank you bcochrane! Thank you Bruce！Thank you very much!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |