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 |

PCF,s help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
falmeshari
Posted : Wednesday, March 26, 2008 4:01:43 PM
Registered User
Joined: 1/5/2007
Posts: 9
Hi , can you help me  write these PCF,s :

1- An all time RSI high monthly chart
2-An all time RSI high weekly chart
3-An all time RSI high daily chart
4-A 3-year RSI high monthly chart
5-A 3-year RSI high weekly chart
6-A 3-year RSI high  daily chart
6-A new RSI move past 68 on monthly chart
7-A new RSI move past 68 on weekly chart
8-An all time MACD (settings “12,26,9” )high monthly chart
9-An all time MACD (settings “12,26,9” )high weekly chart
10-An all time MACD (settings “12,26,9” )high daily chart
11-An all time MACD (settings “4,9,3” )high monthly chart
12-An all time MACD (settings “4,9,3” )high weekly chart
13-An all time MACD( settings(“4,9,3”) high  daily chart

Thanks.





Bruce_L
Posted : Thursday, March 27, 2008 8:29:41 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (falmeshari)
1- An all time RSI high monthly chart
2-An all time RSI high weekly chart
3-An all time RSI high daily chart
... ...
8-An all time MACD (settings “12,26,9” )high monthly chart
9-An all time MACD (settings “12,26,9” )high weekly chart
10-An all time MACD (settings “12,26,9” )high daily chart
11-An all time MACD (settings “4,9,3” )high monthly chart
12-An all time MACD (settings “4,9,3” )high weekly chart
13-An all time MACD( settings(“4,9,3”) high  daily chart

I do not know of a practical automated method for writing Personal Criteria Formulas for all time highs in TeleChart.

QUOTE (falmeshari)
4-A 3-year RSI high monthly chart
5-A 3-year RSI high weekly chart

The formulas for these would be too long to be practical.

QUOTE (falmeshari)
6-A 3-year RSI high daily chart

The practicality of this formula would depend on your specific RSI settings.

RSI Period: ?
Use Wilders Smoothing: Checked or Unchecked?
Avg Period: ?
Average Type: Simple or Exponential?

The ability to write a practical formula would require Use Wilders Smoothing to be Unchecked and the Average Type to be Simple if the Avg Period is anything besides 1.

QUOTE (falmeshari)
6-A new RSI move past 68 on monthly chart
7-A new RSI move past 68 on weekly chart

The exact formulas would again depend on your specific RSI settings:

RSI Period: ?
Use Wilders Smoothing: Checked or Unchecked?
Avg Period: ?
Average Type: Simple or Exponential?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
falmeshari
Posted : Thursday, March 27, 2008 9:48:58 AM
Registered User
Joined: 1/5/2007
Posts: 9
Thank you bruce for your reply , and regarding the Personal Criteria Formulas for all time highs ,
1- An all time RSI high monthly chart
2-An all time RSI high weekly chart
3-An all time RSI high daily chart
... ...
8-An all time MACD (settings “12,26,9” )high monthly chart
9-An all time MACD (settings “12,26,9” )high weekly chart
10-An all time MACD (settings “12,26,9” )high daily chart
11-An all time MACD (settings “4,9,3” )high monthly chart
12-An all time MACD (settings “4,9,3” )high weekly chart
13-An all time MACD( settings(“4,9,3”) high  daily chart

 

what do you think if we write it this way ,

MACD or RSI ( monthly , weekly , daily ) close today >( 120 months or  520 weeks or 3600 days) Max close.


and for the 3 year RSI  high ( monthly or weekly ) , how about :

RSI Wilders Smoothing (14) Unchecked ( monthly or weekly or daily ) close today >( 36 months or 156 weeks or 750 days ) Max close .

Thanks .
Faisal

Bruce_L
Posted : Thursday, March 27, 2008 1:22:21 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (falmeshari)
what do you think if we write it this way ,MACD or RSI ( monthly , weekly , daily ) close today >( 120 months or  520 weeks or 3600 days) Max close.

We can this for the Daily RSI (assuming the same settings as were mentioned for the 3 year RSI High):

RSI14 > MAX(RSI14.1.1,3600)

It should be noted that many symbols will not have enough data to calculate the formula. The other formulas are too long to be practical.

QUOTE (falmeshari)
and for the 3 year RSI  high ( monthly or weekly ) , how about :

RSI Wilders Smoothing (14) Unchecked ( monthly or weekly or daily ) close today >( 36 months or 156 weeks or 750 days ) Max close .

I've already stated that the Monthly or Weekly versions of these formulas would be too long to be practical. The Daily formula could be written as:

RSI14 > MAX(RSI14.1.1,750)

QUOTE (falmeshari)
6-A new RSI move past 68 on monthly chart
7-A new RSI move past 68 on weekly chart

The Daily version of this is fairly short:

RSI14 > 68 AND RSI14.1.1 <= 68

The Weekly and Monthly versions are quite a bit longer:

Weekly:

100 * ((C0 > C5) * (C5 - C0) + (C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65)) / (ABS(C0 - C5) + ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + .00001) > 68 AND 100 * ((C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70)) / (ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + .00001) <= 68

Monthly:

100 * ((C0 > C21) * (C21 - C0) + (C21 > C42) * (C42 - C21) + (C42 > C63) * (C63 - C42) + (C63 > C84) * (C84 - C63) + (C84 > C105) * (C105 - C84) + (C105 > C126) * (C126 - C105) + (C126 > C147) * (C147 - C126) + (C147 > C168) * (C168 - C147) + (C168 > C189) * (C189 - C168) + (C189 > C210) * (C210 - C189) + (C210 > C231) * (C231 - C210) + (C231 > C252) * (C252 - C231) + (C252 > C273) * (C273 - C252) + (C273 > C294) * (C294 - C273)) / (ABS(C0 - C21) + ABS(C21 - C42) + ABS(C42 - C63) + ABS(C63 - C84) + ABS(C84 - C105) + ABS(C105 - C126) + ABS(C126 - C147) + ABS(C147 - C168) + ABS(C168 - C189) + ABS(C189 - C210) + ABS(C210 - C231) + ABS(C231 - C252) + ABS(C252 - C273) + ABS(C273 - C294) + .00001) > 68 AND 100 * ((C21 > C42) * (C42 - C21) + (C42 > C63) * (C63 - C42) + (C63 > C84) * (C84 - C63) + (C84 > C105) * (C105 - C84) + (C105 > C126) * (C126 - C105) + (C126 > C147) * (C147 - C126) + (C147 > C168) * (C168 - C147) + (C168 > C189) * (C189 - C168) + (C189 > C210) * (C210 - C189) + (C210 > C231) * (C231 - C210) + (C231 > C252) * (C252 - C231) + (C252 > C273) * (C273 - C252) + (C273 > C294) * (C294 - C273) + (C294 > C315) * (C315 - C294)) / (ABS(C21 - C42) + ABS(C42 - C63) + ABS(C63 - C84) + ABS(C84 - C105) + ABS(C105 - C126) + ABS(C126 - C147) + ABS(C147 - C168) + ABS(C168 - C189) + ABS(C189 - C210) + ABS(C210 - C231) + ABS(C231 - C252) + ABS(C252 - C273) + ABS(C273 - C294) + ABS(C294 - C315) + .00001) <= 68

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
falmeshari
Posted : Friday, March 28, 2008 6:19:07 AM
Registered User
Joined: 1/5/2007
Posts: 9
Thanks Bruce for your help .
faisal
Bruce_L
Posted : Friday, March 28, 2008 7:44:34 AM


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.