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 |

Possible Bug, some formulas not working on charts Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
usmansajid
Posted : Monday, January 16, 2017 4:41:49 AM
Registered User
Joined: 3/17/2016
Posts: 48

Hi, 

Since I've updated to the new release last week, my charts are not showing some of the plots. It was working on V17, but the update that came out last week killed the plots. 

I had TTM Squeeze on the chart as dots and its not displaying the dots anymore. When I open the plot settings, it says ERROR:Unreachable code. Please can you look into fixing it. 

 

Formula on chart:

0 / ABS (4 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) < 3 * ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40)
)
 
 
 
 
bcochrane
Posted : Monday, January 16, 2017 6:11:22 PM
Registered User
Joined: 9/17/2010
Posts: 484

I'm not having that problem on the new beta release. 

May I suggest you contact Support Support@TC2000.com

Bruce_L
Posted : Tuesday, January 17, 2017 10:15:35 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Try getting rid of the space right after the ABS in the formula. In should be ABS( without a space and not ABS ( with a space. i would probably also get rid of the line return at the very end of the formula so it ends 40)) without any spaces or line returns, but it isn't a necessary change.

This can actually be written as follows in the newest TC2000 v17 beta.

0 / ABS(4 * STDDEV(C, 20) < 3 * ATR(20))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
usmansajid
Posted : Tuesday, January 17, 2017 11:37:55 AM
Registered User
Joined: 3/17/2016
Posts: 48

Bruce,

The formula you have provided, I want to plot the TTM Squeeze as dots, this worked in V16. 

Are you sure that the formula below is TTM Squeeze (Bollinger Bands inside Keltner Channels)?

0 / ABS(4 * STDDEV(C, 20) < 3 * ATR(20))

 
 
Also, 
 
I use the VIX Bottom plot on chart, you provided the formula and it worked on V16. 
 
Below is the formula, this isn't working anymore: 
 
0 / ABS (100 * (1 - L / MAXC22) / ABS((100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * ( - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20))
)
 
 
 
Can you provide VIX formula or above equivalent that works, I need to plot the dots on chart for when the condition is true. 
 
 

 

Bruce_L
Posted : Tuesday, January 17, 2017 12:28:36 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Yes, I am sure the formula matches the formula you gave which is in fact an Indicator Formula designed to be used as the Formula in a Custom PCF Indicator with the Plot Style set to Dots so dots plot when the TTM Squeeze is true and nothing plots when the TTM Squeeze is false (because it generates a division by zero error).

That said, TTM Squeeze is NOT Bollinger Bands inside Keltner Channels but is instead Bollinger Bands being narrower than Keltner Channels.

Your new formula has exactly the same issue as the TTM Squeeze Formula you gave originally. There is a space in the ABS( function between ABS and the opening parenthesis which should not be there.

 



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Monday, February 13, 2017 2:42:42 PM
Registered User
Joined: 6/14/2016
Posts: 285

Hi Bruce,

I'm looking to use an condition in an Easyscan column which will show me the %value(s) of:

- the last bar high to the

- upper Keltner Band (using 16 periods & atr multiplier of 1.3)

relative to the (1) lower Keltner Band, and alternately, relative the (2) last 10 bar low..

Many thanks for your help with this.

Chris

Bruce_L
Posted : Monday, February 13, 2017 2:56:16 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The percent that the high of the current bar is above the low of the most recent 10 bars is pretty straightforward and should work in any version of TC2000.

100 * (H / MINL10 - 1)

The percentage that price is above or below the upper Keltner Channel 16, 1.30 follows a similar pattern but is longer because the formula for the upper Keltner Channel is longer than the formula for the lowest low of the most recent 10 bars. This will also only work in TC2000 v17 as written.

100 * (H / XAVG((H + L + C) / 3 + 1.3 * ATR, 16) - 1)

Using the lower channel results in a similar formula.

100 * (H / XAVG((H + L + C) / 3 - 1.3 * ATR, 16) - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Monday, February 13, 2017 4:52:03 PM
Registered User
Joined: 6/14/2016
Posts: 285

Many thanks Bruce, I appreciate your help.

Bruce_L
Posted : Monday, February 13, 2017 4:53:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



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