Registered User
Joined: 9/20/2010
Posts: 16
|
I want to create a Histogram of the difference between a 12 day Exponential TSV and its 6 day Simple Average. I tried XAVG(TSV1.1,12) - AVG(TSV,6); it does not give corret results. XAVG(TSV1.1,12) - AVG(XAVG(TSV1.1,12),6) gives Syntax Error
|
Registered User
Joined: 9/27/2010
Posts: 11
|
This does not give a syntax error. XAVG(TSV,12)-AVG(TSV,6) ....but does it give what you want plotted as a histogram?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
An Indicator Formula for the difference between a 12-day exponential TSV and its 6-period simple moving average can be written as:
XAVG(TSV,12) - XAVG(TSV6,12)
You can use this as the Formula in a Custom PCF Indicator with the Plot Style set to Histogram to plot this as a Histogram on the charts in TC2000.
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: 9/20/2010
Posts: 16
|
Thanks, Bruce.
bruceci, it did not give the correct answer.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|