Hi,

I was wondering if there is any column that could tell me which tickers have bigger % moves on average. The "Price Volatility" Column does not seem to work very well, I think. Is there another one like that?

If you want the average of the magnitude of the percent changes for each bar, you could write a formula which measures this directly.

For example, the following would be the 20 period simple moving average of the absolute value of the 1 period percent change in TC2000 v17.

100 * AVG(ABS(C / C1 - 1), 20)

Rate of Change Percent (ROC%)

That's great, Bruce. Thanks so much!

Hey Bruce,

Sorry to bother you again. I tried entering

100 * AVG(ABS(C / C1 - 1), 100)  

as a condition formula, so I can the use it as a column on my watchlist, but I can't because there is a syntax error. I guess something is missing. Could you please guide me on how to do it?

Thanks again!

It is an Indicator Formula which returns a numeric value instead of being a Condition Formula which would return true or false, but there doesn't appear to be a syntax error. I copied and pasted your formula into my copy of TC2000 v17 and it worked.

If you are using an earlier version of TC2000 or FreeStockCharts Premium, then I would add a Custom PCF Indicator to the chart.

ABS(C / C1 - 1)

You should then be able to click on the indicator and select Copy to WatchList or Report to display the value as a WatchList Column.

I am using the Premium version of Freestockcharts.com, maybe that is why it works differently. Thanks!

Definitely try the Custom PCF Indicator method. I think it should work fine in FreeStockChart Premium.

I was playing around with formulas based on your suggestions and I came up with this formula for my Custom PCF indicator:

ABS((C*100) / C1 -100)

over a period on 100 days works like a charm. thanks for your guidance!

I am happy to read you were able to come up with something which works better for you on your own.