Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 5/26/2017 Posts: 25
|
Hi Trainer,
I have a Trend Stability Factor calculation.
((((XAVGC100.0 - XAVGC100.1) / XAVGC100.1) * 100) * 5) + (((XAVGC50.0 - XAVGC50.1) / XAVGC50.1) * 100)
Out of this calculation, i would like to get a smoothing using a 60 day SMA. How can i do this?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You should be able to put the entire thing in an AVG() function.
AVG(((((XAVGC100.0 - XAVGC100.1) / XAVGC100.1) * 100) * 5) + (((XAVGC50.0 - XAVGC50.1) / XAVGC50.1) * 100), 60)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I've not used Trend Stabity Factor Calculations before and am just wondering...
If I wanted a faster calculation speed than slow, let's say I changed the values to those below:
AVG(((((XAVGC34.0 - XAVGC34.1) / XAVGC34.1) * 100) * 5) + (((XAVGC21.0 - XAVGC21.1) / XAVGC21.1) * 100), 60)
Then would the bolded values of 5 and 60 remain the same or need to be changed.
If they need to be changed, what is the logic behind the values one might choose?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am not famililiar with the calculations either. I just smoothed the formula as provided. I cannot think of an obivious reason these values would need to be changed, but I am not familiar with the purpose of the formula or the reason the formula is structured as given.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 5/26/2017 Posts: 25
|
QUOTE (traderlady)
I've not used Trend Stabity Factor Calculations before and am just wondering...
If I wanted a faster calculation speed than slow, let's say I changed the values to those below:
AVG(((((XAVGC34.0 - XAVGC34.1) / XAVGC34.1) * 100) * 5) + (((XAVGC21.0 - XAVGC21.1) / XAVGC21.1) * 100), 60)
Then would the bolded values of 5 and 60 remain the same or need to be changed.
If they need to be changed, what is the logic behind the values one might choose?
The trend stability factor is a backtested calculation metric used to pre-select a list of stocks with a certain trend quality specification. The output of the list will then be used to trade pullbacks (with a different formula) during an uptrend. Speeding up the calculation can produce missleading results!
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
Thanks for your answer, SweetAndSour---& good trading!
|
|
Guest-1 |