Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Measuring ROC from a low point on a monthly chart to current Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
calm2bw-subscribe
Posted : Tuesday, August 16, 2016 5:36:48 PM
Platinum Customer Platinum Customer

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?
Bruce_L
Posted : Friday, August 19, 2016 12:15:18 PM


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
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.