(XAVGC5) - (XAVGC34) - XAVG(XAVGC5,5) + XAVG(XAVGC34,5) - ((XAVGC5.16) - (XAVGC34.16) - XAVG(XAVGC5.16,5) + XAVG(XAVGC34.16,5))

this is the roc over 16 days for a macd for a daily, actual value, 5,34,5 exponential. what would the formula be for a weekly? I'm having trouble using the "," for 5 days - results in formula errors.

If you are using TC2000 version 12, all you need to do is set the Time Frame of the Indicator Formula to Weekly when you create or edit it (there is a Time Frame drop-down menu).

The ,5 isn't for days. The ,5 represents the period of the Exponential Moving Average in the XAVG() function.

what is the difference b/t the "period" for the MACD versus the" timeframe" when setting the sort? In other words, I'm trying to replicate the "timeframe" in the formula (because when using a pcf for a sort it doesn't allow this).

The periods are the periods of the three moving averages which are used in calculating the MACD Histogram.

Understanding MACD

The period of a moving average is in bars. When you change the Time Frame, you are adjusting the size of the bar being used. When you adajsut the period, you are adjusting the number of bars used in calculating the moving average.

You definitely can adjust the Time Frame of a Personal Criteria Formula when using it for a Sort in TC2000 version 12 (right-click on the WatchList Column header and select Edit). All PCFs use a Daily Time Frame in TC2000 version 7.