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 |

Day Week Month Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kenjanson
Posted : Tuesday, October 2, 2012 2:13:43 PM
Registered User
Joined: 12/21/2004
Posts: 35

This is an indicator formula I use when viewing DAILY charts.

(ABS(C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1) * L AND STOC3.2 < 50 AND (STOC3.2.1 < STOC14.3.1) AND STOC3.2 > STOC14.3)

How would it be modified to return the indicator for WEEK view and MONTH view.

 

 

StockGuy
Posted : Tuesday, October 2, 2012 2:34:51 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Just change the time frame on the chart.  Custom indicators use the data from the chart so if you're viewing a weekly chart the formula will use weekly data.

Bruce_L
Posted : Tuesday, October 2, 2012 2:36:17 PM


Worden Trainer

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

I don't understand the formula. The first part returns a value (albeit based on boolean calculations):

ABS(C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1) * L

While the second part is boolean (true or false):

STOC3.2 < 50 AND STOC3.2.1 < STOC14.3.1 AND STOC3.2 > STOC14.3

You should either just return a value:

ABS(C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1 AND STOC3.2 < 50 AND STOC3.2.1 < STOC14.3.1 AND STOC3.2 > STOC14.3) * L

Or you should just return true or false:

C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1 AND STOC3.2 < 50 AND STOC3.2.1 < STOC14.3.1 AND STOC3.2 > STOC14.3

In any case, it is possible to change the Time Frame of an Indicator Formula in TC2000 version 12.2 by using the Time Frame drop-down menu when you create or edit the Indicator Formula. Personal Criteria Formulas in TC2000 version 7 always use a Daily Time Frame.

If you are using the Indicator Formula as the Formula in a Custom PCF Indicator or Boolean Formula in a Custom PCF % True Indicator, changing the Time Frame of the chart will change the Time Frame being used for the indicator. A Custom PCF Indicator will always use the Time Frame of the chart to calculate its formula. This is true in both TC2000 version 12.2 and TC2000 version 7.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kenjanson
Posted : Tuesday, October 2, 2012 4:20:08 PM
Registered User
Joined: 12/21/2004
Posts: 35

When I use the formula in an Easy Scan it returns Daily chart information. I'd like to set up Easy Scans for Week hits and Month Hits. Indicators change depending on whether they are viewed in Day, Week, or Month time frames.

Bruce_L
Posted : Tuesday, October 2, 2012 4:45:12 PM


Worden Trainer

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

If you are using TC2000 version 12.2, you can just change the Time Frame of the Condition Formula by using the Time Frame drop-down menu when you edit or create the Condition Formula. The EasyScan itself also allows you to change the Time Frame of any of its EasyScan Conditions.

In TC2000 version 7, all Personal Criteria Formulas are calculated using Daily bars. It would be possible to convert the following Daily Personal Criteria Formula:

C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1 AND STOC3.2 < 50 AND STOC3.2.1 < STOC14.3.1 AND STOC3.2 > STOC14.3

To Weekly:

C < C45 AND C < C40 AND C < C35 AND C < C30 AND C < C25 AND C < C20 AND C < C15 AND C < C10 AND C < C5 AND (STOC15 + STOC15.1.5) / 2 < 50 AND (STOC15.1.5 + STOC15.1.10) / 2 < (STOC70.1.5 + STOC70.1.10 + STOC70.1.15) / 3 AND (STOC15 + STOC15.1.5) / 2 > (STOC70 + STOC70.1.5 + STOC70.1.10) / 3

Or to Monthly:

C < C189 AND C < C168 AND C < C147 AND C < C126 AND C < C105 AND C < C84 AND C < C63 AND C < C42 AND C < C21 AND (STOC63 + STOC63.1.21) / 2 < 50 AND (STOC63.1.21 + STOC63.1.42) / 2 < (STOC294.1.21 + STOC294.1.42 + STOC294.1.63) / 3 AND (STOC63 + STOC63.1.21) / 2 > (STOC294 + STOC294.1.21 + STOC294.1.42) / 3

But these PCFs would only match the Weekly and Monthly charts in TC2000 version 7. They would not match the Weekly and Monthly Chart in TC2000 version 12.2.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
krishbala
Posted : Tuesday, October 2, 2012 10:17:28 PM
Gold Customer Gold Customer

Joined: 10/24/2005
Posts: 1

Is it possible to find out the high and low for the prior months? I mean can PCF understand monthly and weekly candlesticks instead of daily ones. As far as I know the scans are based on daily prices, but I am looking to scan based on weekly and monthly values. How do I do that?

Bruce_L
Posted : Wednesday, October 3, 2012 8:03:36 AM


Worden Trainer

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

Are you using TC2000 version 7 or TC2000 version 12.2? It is possible to do so in both programs, but the techniques required are significantly more complicated in TC2000 version 7.

All you need to do in TC2000 version 12.2 to change the Time Frame is use the Time Frame drop-down menu in the formula window when it is created or edited.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kenjanson
Posted : Wednesday, October 3, 2012 4:58:58 PM
Registered User
Joined: 12/21/2004
Posts: 35

Thank you, Bruce. You nailed it.

Bruce_L
Posted : Wednesday, October 3, 2012 5:10:35 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.