Registered User Joined: 10/7/2004 Posts: 286
|
Is there a PCF approximation formula for a 30 day average of a 30 day variance. ?
SQR( ( ( C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19 + C20 * C20 + C21 * C21 + C22 * C22 + C23 * C23 + C24 * C24 + C25 * C25 + C26 * C26 + C27 * C27 + C28 * C28 + C29 * C29) - 30 * AVGC30 * AVGC30 ) / 30)
thanks.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
As far as I can tell, you would need to add 30 slightly different versions of your formula together and divide the result by 30. I cannot think of a shortcut. I actually just did this using Excel and some hand editing, but the resulting formula ends up being too long and slow to be practical or post in the forums.
You could use your base formula as a Custom PCF Indicator with the Smoothing set to 30 and the Average Type set to Simple to plot the desired value on the chart. You could then click on the indicator and select Show values in WatchList or Create Scan Condition to utilize the result.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/7/2004 Posts: 286
|
okay, thanks...first time I've ever "stumped" you. :) ...will use the custom indicator window at bottom of screen.
thx.
jynkin
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|