Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Avg of $Vol Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jackmanjls
Posted : Friday, March 1, 2013 8:11:32 AM
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?

 

Bruce_L
Posted : Friday, March 1, 2013 8:54:40 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.