New version 18 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, May 21, 2018 5:06:50 PM
Number of Posts: 62,715
[21.64% of all post / 12.60 posts per day]
Avatar
Last 10 Posts
Topic: Creating a Condition for a Condition Column Check Mark
Posted: Monday, May 21, 2018 4:58:21 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Questions about Heiken-Ashi Formulas
Posted: Monday, May 21, 2018 3:41:29 PM

Thanks. Copy and paste can be both a blessing and a curse. Still probably better with fewer mistakes than trying to manually type everything out though.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Creating a Condition for a Condition Column Check Mark
Posted: Monday, May 21, 2018 3:36:50 PM

Mine really are just designed to be shorter versions of those formulas.

I take advantage of the fact that an exponential moving average always moves in the direction of what is being averaged. So:

XAVGC13 < XAVGC13.1 can be shortened to C < XAVGC13.1

Also uncascaded the exponential moving averages and used the difference equation for exponential moving averages to shorten:

((XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9)) < (XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9)))

Into:

119 * C + 765 * XAVGC12.1 < 65 * XAVGC26.1 + 819 * XAVGC9.1

It even ends up being a bit shorter than the modern syntax (and can calculate with less data).

MACD12.26 - XAVG(MACD12.26, 9) < MACD12.26.1 - XAVG(MACD12.26.1, 9)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Creating a Condition for a Condition Column Check Mark
Posted: Monday, May 21, 2018 3:06:02 PM

My guess would be Greater Than 0.00, but I don&#39;t actually have access to the Elder-Disk to know for sure what formulas are being used for the dots on the chart (to know what is returned when true versus what is returned when false).

I use the following for red.

C < XAVGC13.1 AND 119 * C + 765 * XAVGC12.1 < 65 * XAVGC26.1 + 819 * XAVGC9.1

The following for green.

C > XAVGC13.1 AND 119 * C + 765 * XAVGC12.1 > 65 * XAVGC26.1 + 819 * XAVGC9.1

And the following for blue.

SGN(C - XAVGC13.1) <> SGN(119 * C + 765 * XAVGC12.1 - 65 * XAVGC26.1 - 819 * XAVGC9.1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Questions about Heiken-Ashi Formulas
Posted: Monday, May 21, 2018 2:52:57 PM

Please try the following indicator formula.

SGN(XAVG(O1 + H1 + L1 + C1, 3) - HAVG(O + H + L + C, 21)) + SGN(GREATEST(4 * H, XAVG(O1 + H1 + L1 + C1, 3)) - MAX(GREATEST(4 * H1, XAVG(O2 + H2 + L2 + C2, 3)), 2))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request for Modification CMO PCF Formula
Posted: Monday, May 21, 2018 12:02:27 PM

You&#39;re welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request for Modification CMO PCF Formula
Posted: Monday, May 21, 2018 11:29:59 AM

The only thing changing in these formulas is the values at the beginning and end of the formula.

(-100) <= 100 * (C - C14) / SUM(ABS(C - C1), 14) AND 100 * (C - C14) / SUM(ABS(C - C1), 14) <= (50)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: PCF Scan request
Posted: Monday, May 21, 2018 10:28:06 AM

Please try the following.

ABS(TrueInRow(C > 1.01 * XAVGC8 AND ABS(XAVGC8 / XAVGC50 - 1.02) <= .01 AND ABS(XAVGC50 / XAVGC150 - 1.02) <= .01, 10) - 6.5) < 3

I do not know what is being requested in the second paragraph.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Bollinger inside ketlner
Posted: Monday, May 21, 2018 10:23:03 AM

Make sure when you create the condition that you have selected the top band for both Bollinger Bands and Keltner Channels for the first condition and the Bottom band for both Bollinger Bands and Keltner Channels for the second condition.

If you don&#39;t specifically select the correct bands for both channels, the conditions will not work correctly.

Also verify that the time frame of the conditions are the same as the time frame on the chart, that you are scrolled all the way to the right edge of the chart, and that the settings on the chart match the settings in the conditions for both the Bollinger Bands and Keltner Channels.

If this does not resolve the issue, please contact technical support (as it is working correctly on my system).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: 3 year sales growth
Posted: Monday, May 21, 2018 10:11:21 AM

There is not a way to reference fundamentals in the Personal Criteria Formula Language, so there is no way for your to create the desired fundamental.

About the best you could do is add Sales 1-Yr to a chart in a yearly time frame along with a 3 period Rate of Change Percent indicator. Change the Data Source of the ROC% to use Sales 1-Yr instead of Price History.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles