Registered User
Joined: 2/1/2012
Posts: 14
|
I tried chating with support but was unable to get a reasonable answer, so I'm posting it here:
I have a chart where I indicate a low points and High points. In this case, I am looking at a 21 period low on a monthly time frame. It works well for most, but it doesnt work for about half of the stocks in my easyscan. I created a PCF that looks back until it finds the most recent 21 bar low and measures the rate of change from there to the current month. I'll use symbol "DLTR" which has 104 bars from its 21 period low (C=MINC21.104) to the current month, as an example of what doesnt work. "ROST" has 199 bars from its monthly 21p low to current, and this works correctly, giving me the correct Rate of change. The PCF logic is long so I'll shorten it here:
ABS(C = MINC21) * 0 - NOT(C = MINC21) * (
ABS(C1 = MINC21.1) * (((C-MINC21.1 )/MINC21.1 )*100) - NOT(C1 = MINC21.1 ) * (
ABS(C2 = MINC21.2) * (((C-MINC21.2 )/MINC21.2 )*100) - NOT(C2 = MINC21.2 ) * (
ABS(C3 = MINC21.3) * (((C-MINC21.3 )/MINC21.3 )*100) - NOT(C3 = MINC21.3 ) * (
ABS(C4 = MINC21.4) * (((C-MINC21.4 )/MINC21.4 )*100) - NOT(C4 = MINC21.4 ) * (
ABS(C5 = MINC21.5) * (((C-MINC21.5 )/MINC21.5 )*100) - NOT(C5 = MINC21.5 ) * (
ABS(C6 = MINC21.6) * (((C-MINC21.6 )/MINC21.6 )*100) - NOT(C6 = MINC21.6 ) * (
ABS(C7 = MINC21.7) * (((C-MINC21.7 )/MINC21.7 )*100) - NOT(C7 = MINC21.7 ) * (
ABS(C8 = MINC21.8) * (((C-MINC21.8 )/MINC21.8 )*100) - NOT(C8 = MINC21.8 ) * (
ABS(C9 = MINC21.9) * (((C-MINC21.9 )/MINC21.9 )*100) - NOT(C9 = MINC21.9 ) * (
ABS(C10 = MINC21.10) * (((C-MINC21.10 )/MINC21.10 )*100) - NOT(C10 = MINC21.10 ) * (
.
.
.
ABS(C251=MINC21.251)*(((C-MINC21.251)/MINC.251)*100) - NOT(C251 = MINC21.251)
))))))))))
DLTR does not give me a Rate of Change for 104 bars, but ROST will with 199 bars.
I have verified this with the cursor drag method, and the command-C so I know what rate of change should be returning. Again it works on my easy scan of 913 stocks about half and not on the other half. I have looked at the PCF and not seen any point where a typo may have occured. It works on symbols with less bars and more bars. I am suspecting there is some kind of data error.
Can anyone help with this?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Your formula requires 271 bars of data to calculate. DLTR does not have 271 monthly bars available while ROST does have 271 monthly bars available.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|