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

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)

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?

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.

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!

Thanks for your answer, SweetAndSour---& good trading!