Registered User Joined: 9/28/2009 Posts: 135
|
The formula for TC Volume(Dollars) n-day is avgCn*avgVn/100.
I want to smooth this result. When n-day = 5-day it's choppy.
Is there anyway to take the avg of the results from the above?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you are plotting the formula on the chart using a Custom PCF Indicator, you can set the Period of the Custom PCF Indicator to the period of the moving average you wish to add and the Average Type of the Custom PCF Indicator to the type of moving average you wish to use. You could also just add a moving average indicator to the Custom PCF Indicator.
It is not possible to just use an AVG() or XAVG() function on your formula. If you want a formula, you would need to manually expand the moving average you wish to apply. For example, if you wanted to apply a 5-Period Simple Moving Average, you would need to add together bars ago versions of the formula and then divide the result by 5:
(AVGC5 * AVGV5 + AVGC5.1 * AVGV5.1 + AVGC5.2 * AVGV5.2 + AVGC5.3 * AVGV5.3 + AVGC5.4 * AVGV5.4) / 5 / 100
Note that the AVGC5 * AVGV5 / 100 is in itself a simplification, but multiplying each day by its own volume wolud create a much longer formula:
(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * C4) / 5 / 100
A 5-Period Simple Moving Average of that would be:
(C * V + 2 * C1 * V1 + 3 * C2 * V2 + 4 * C3 * V3 + 5 * C4 * V4 + 4 * C5 * V5 + 3 * C6 * V6 + 2 * C7 * V7 + C8 * V8) / 25 / 100
Note that actual dollar volume would require using tick charts over the period, and we don't have that much tick data available. In addition, you may not want to divide the result by 100 (it is up to you). TC2000 version 12.3 reports volume in actual shares while TC2000 version 7 reports volume in blocks of 100 shares.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|