New version 17 available now


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


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: Bruce_L
About
User Name: Bruce_L
Groups: Gold User, Platinum User, TeleChart, Worden Staff, Worden Training Agent
Rank: Worden Trainer
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, October 07, 2004
Last Visit: Monday, April 24, 2017 1:06:24 PM
Number of Posts: 58,850
[21.05% of all post / 12.84 posts per day]
Avatar
Last 10 Posts
Topic: EPS % change comparison
Posted: Monday, April 24, 2017 1:01:43 PM

There really isn't a way to create your own fundamentals other than to apply indicators to those fundamentals. You can't even do it with PCFs because the Personal Criteria Formula Language does not have syntax for referencing the fundamentals. It really isn't something TC2000 is currently designed to do.

So, for Sales Growth, you can either add the built in Sales Growth Rate 5-Yr or add Sales 1-Yr, add a Rate of Change Percent Indicator to the chart and change the Data Source of the ROC% indicator to use Sales 1-Yr.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Histogram for Anding 2 Moving Averages
Posted: Monday, April 24, 2017 12:55:14 PM

Please try the following Indicator Formula in TC2000 v17.

100 * IIF((C > XAVGC21 AND C > AVGC50) OR (C < XAVGC21 AND C < AVGC50), C / XAVGC21 + C / AVGC50 - 2, 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Formula correction needed.
Posted: Monday, April 24, 2017 12:42:21 PM

The NR7 part can be written as follows in TC2000 v17.

H - L < MIN(H1 - L1, 6)

And as follows in earlier versions of TC2000.

H - L < H1 - L1 AND H - L < H2 - L2 AND H - L < H3 - L3 AND H - L < H4 - L4 AND H - L < H5 - L5 AND H - L < H6 - L6

Your version allows for equality, so you can change the < to <= if you would prefer.

The portion of your formula which checks for an uptrend is:

AVGC10 >= AVGC20 OR AVGC20 >= AVGC50

You may want to switch this to AND and get rid of the equality.

This portion checks for either the highs or closes of the two most recent bars to not be going down. This could be part of a definition of an uptrend, so we will leave it in, but require both.

This could be written as follows in TC2000 v17.

TrueInRow(H >= H1 AND C >= C1, 2) = 2

But it isn&#39;t much longer in older versions of TC2000 (which will also work in TC2000 v17).

H >= H1 AND C >= C1 AND H1 >= H2 AND C1 >= C2

So the formula I would get for TC2000 v17 would be the following.

H - L < MIN(H1 - L1, 6) AND TrueInRow(H >= H1 AND C >= C1, 2) = 2 AND AVGC10 > AVGC20 AND AVGC20 > AVGC50

This would be the following in earlier versions of TC2000.

H - L < H1 - L1 AND H - L < H2 - L2 AND H - L < H3 - L3 AND H - L < H4 - L4 AND H - L < H5 - L5 AND H - L < H6 - L6 AND H >= H1 AND C >= C1 AND H1 >= H2 AND C1 >= C2 AND AVGC10 > AVGC20 AND AVGC20 > AVGC50

I&#39;m not really sure any of this is a "correction" if you didn&#39;t like you previous results, but we would need further clarification from you as to the pattern you are actually trying to identify to change much else.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Backtesting
Posted: Monday, April 24, 2017 12:32:11 PM

TC2000 v17 has a CountTrue() function which can be used in PCFs for this, but in TC2000 v7, you would have to write the Personal Criteria Formula in such a way that it checks for all 5 bars.

So let&#39;s say your base bearish engulfing pattern was as follows.

O > C1 AND C1 > O1 AND O1 > C

You would have to repeat it 5 times with the bars ago parameters changed and ORs in between instance.

(O > C1 AND C1 > O1 AND O1 > C) OR (O1 > C2 AND C2 > O2 AND O2 > C1) OR (O2 > C3 AND C3 > O3 AND O3 > C2) OR (O3 > C4 AND C4 > O4 AND O4 > C3) OR (O4 > C5 AND C5 > O5 AND O5 > C4)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Next Earnings Date as a Condition
Posted: Monday, April 24, 2017 12:18:47 PM

There is not a way to scan for this in the current version of TC2000. An EasyScan will let you add Next Earnings as an EasyScan Condition, but there isn&#39;t actually a way to make it work.

You would need to scan based on your other conditions and then sort based on Next Earnings.

Thank you for your suggestion.

 



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: PCF For Williams Vix Fix - Finds Market Bottoms
Posted: Monday, April 24, 2017 12:15:46 PM

Certainly the new formula for TC2000 v17 is only going to work in TC2000 v17. It will not work in TC2000 v12.5 or the mobile version.

You will want to use the older versions of these types of formulas if you need the fomulas to work in older versions of TC2000.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: how do I create mansfield relative strength
Posted: Monday, April 24, 2017 12:13:57 PM

There isn&#39;t a way to write a Personal Criteria Formula for this because there is no way to reference another symbol in the PCF Language.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Andrew Abraham Trend Indicator
Posted: Saturday, April 22, 2017 12:45:33 PM

If we were to use a weighted moving average and an ATR multiplier of 3 while sticking with the logic outlined in the original post, then the nested Formula would be the following.

IIF(C > MAXC21 - 3 * FAVG(ATR, 21) AND C > MINC21 + 3 * FAVG(ATR, 21), MAXC21 - 3 * FAVG(ATR, 21), IIF(C < MAXC21 - 3 * FAVG(ATR, 21) AND C < MINC21 + 3 * FAVG(ATR, 21), MINC21 + 3 * FAVG(ATR, 21), 1 / 0))

And the versions to use with different colors would be:

IIF(C > MAXC21 - 3 * FAVG(ATR, 21) AND C > MINC21 + 3 * FAVG(ATR, 21), MAXC21 - 3 * FAVG(ATR, 21), 1 / 0)

And:

IIF(C < MAXC21 - 3 * FAVG(ATR, 21) AND C < MINC21 + 3 * FAVG(ATR, 21), MINC21 + 3 * FAVG(ATR, 21), 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: How to find divergences
Posted: Saturday, April 22, 2017 9:59:04 AM

You&#39;re welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Hiding a panel in a Chart
Posted: Saturday, April 22, 2017 9:58:32 AM

You&#39;re welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles