I AM TRYING TO DO A MACD 5/12 CROSSING 0 UP WITHIN THE LAST TWO WEEKS USING WEEKLY CHARTS AND THE FOLLOWING: (XAVGC5.10 - XAVGC12.10) < 0 AND (XAVGC5.5 - XAVGC12.5) > 0. THIS PCF IS NOT WORKING FOR ME ON WEEKLY CHARTS--PLEASE TELL ME WHAT I AM  DOING WRONG?  FURTHER, I WOULD LIKE TO GET THE SCAN  RESULTS ONE DAY AGO IF POSSIBLE ? THANKS, BOBBY B. 

Your formula appears to be looking for a crossup between 2-weekly bars ago and 1-weekly bar ago. You have multiplied the period of the offset by 5, but you have not multiplied the periods of the MACD itself by 5. Doing so would result in:

XAVGC25.5 > XAVGC110.5 AND XAVGC25.10 <= XAVGC110.10

This is actually a pretty decent approximation, but it will not match the charts.

In TC2000 version 7, the weekly charts are comprised of rolling 5-trading day bars and Personal Criteria Formulas are always calculated using daily bars (although Custom PCF Indicators use the bars on the chart for their calculations).

Another consequence of the rolling 5-trading day bars is that moving averages of the close have absolutely nothing to do with yesterday, 2-days ago, 3-days ago or 4-days ago. A 2-Period Simple Moving Average on a weekly chart would skip all of those bars for example and be calculated using the current price and the closing price of 5-days ago.

If we take this into account, we need to manually expand the moving average by sampling price only once every 5-days. This results in the following approximation which should be better at matching the charts than the shorter formula above (but the above formula may be better in that it uses more information and his granularity in its calculations).

.333559 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85 + 2 / 3 * (C90)))))))))))))))))) > 0.153984303064341 * (C5 + 11 / 13 * (C10 + 11 / 13 * (C15 + 11 / 13 * (C20 + 11 / 13 * (C25 + 11 / 13 * (C30 + 11 / 13 * (C35 + 11 / 13 * (C40 + 11 / 13 * (C45 + 11 / 13 * (C50 + 11 / 13 * (C55 + 11 / 13 * (C60 + 11 / 13 * (C65 + 11 / 13 * (C70 + 11 / 13 * (C75 + 11 / 13 * (C80 + 11 / 13 * (C85 + 11 / 13 * (C90 + 11 / 13 * (C95 + 11 / 13 * (C100 + 11 / 13 * (C105 + 11 / 13 * (C110 + 11 / 13 * (C115 + 11 / 13 * (C120 + 11 / 13 * (C125 + 11 / 13 * (C130 + 11 / 13 * (C135 + 11 / 13 * (C140 + 11 / 13 * (C145 + 11 / 13 * (C150 + 11 / 13 * (C155 + 11 / 13 * (C160 + 11 / 13 * (C165 + 11 / 13 * (C170 + 11 / 13 * (C175 + 11 / 13 * (C180 + 11 / 13 * (C185 + 11 / 13 * (C190 + 11 / 13 * (C195 + 11 / 13 * (C200 + 11 / 13 * (C205 + 11 / 13 * (C210)))))))))))))))))))))))))))))))))))))))))) AND .333559 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85 + 2 / 3 * (C90 + 2 / 3 * (C95)))))))))))))))))) <= 0.153984303064341 * (C10 + 11 / 13 * (C15 + 11 / 13 * (C20 + 11 / 13 * (C25 + 11 / 13 * (C30 + 11 / 13 * (C35 + 11 / 13 * (C40 + 11 / 13 * (C45 + 11 / 13 * (C50 + 11 / 13 * (C55 + 11 / 13 * (C60 + 11 / 13 * (C65 + 11 / 13 * (C70 + 11 / 13 * (C75 + 11 / 13 * (C80 + 11 / 13 * (C85 + 11 / 13 * (C90 + 11 / 13 * (C95 + 11 / 13 * (C100 + 11 / 13 * (C105 + 11 / 13 * (C110 + 11 / 13 * (C115 + 11 / 13 * (C120 + 11 / 13 * (C125 + 11 / 13 * (C130 + 11 / 13 * (C135 + 11 / 13 * (C140 + 11 / 13 * (C145 + 11 / 13 * (C150 + 11 / 13 * (C155 + 11 / 13 * (C160 + 11 / 13 * (C165 + 11 / 13 * (C170 + 11 / 13 * (C175 + 11 / 13 * (C180 + 11 / 13 * (C185 + 11 / 13 * (C190 + 11 / 13 * (C195 + 11 / 13 * (C200 + 11 / 13 * (C205 + 11 / 13 * (C210 + 11 / 13 * (C215))))))))))))))))))))))))))))))))))))))))))

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages

BRUCE, THX FOR YOUR MACD WEELY MACD HELP. bobby b

You're welcome.