| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/3/2004
Posts: 7
Location: New York City
|
I recently created the custom indicator (c-MINL13)/(Maxh13-MINL13)*100 with a three day simple smoothing average. I'd like to see if it's rising vs. yesterday. As your AVG function doesn't (yet) support formulas, I tried manually creating a PCF to do it as follows:
(((((C - MINL13) / (MAXH13 - MINL13) * 100) + ((C1 - MINL13.1) / (MAXH13.1 - MINL13.1) * 100) + ((C2 - MINL13.2) / (MAXH13.2 - MINL13.2) * 100)) / 3) > ((((C1 - MINL13.1) / (MAXH13.1 - MINL13.1) * 100) + ((C2 - MINL13.2) / (MAXH13.2 - MINL13.2) * 100) + ((C3 - MINL13.3) / (MAXH13.3 - MINL13.3) * 100)) / 3))
Unfortunately, this often returns false when the indicator line is rising (see EXH). What have I done wrong? Iif this can't be done in Telechart, is there any third party add-on program that supports moving averages of formulas?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
STOC13.3 > STOC13.3.1
You may wish to review the following:
Understanding Stochastics
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
|
|
Registered User
Joined: 12/3/2004
Posts: 7
Location: New York City
|
Dear Bruce,
Thank you for yourr suggestion. I still have a problem, however, in that I also use a related custom formula ((O - MINL13) / (MAXH13 - MINL13) * 100) based on opening price and compare it to the first. Is there a way I can create a STOC based on opening price instead of closing price? If not, would (((O1 - MINL13.1) / (MAXH13.1 - MINL13.1) * 100) + ((O2 - MINL13.2) / (MAXH13.2 - MINL13.2) * 100) + ((O3 - MINL13.3) / (MAXH13.3 - MINL13.3) * 100)) / 3) yield yesterday's equivalent of STOC based on opening price? If not, is there a third party program that would do the job?
P.S. If you plot both the custom indicator ((C-MINL13)/(MAXH13-MINL13))*100 (with 3 day smoothing) and STOC13.3 in the same window, the two lines are in sync but NOT congruent.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'll start with the PS. They are just not being plotted on the same scale. If you plot STOC13.3 as a Custom Indicator instead of using the built in Stochastics Indicator, they should line up.
You pretty much have the formula for yesterday's Stochastic based on the Open instead of the Close right, but I think there are some parentheses issue. You may wish to try the following instead:
100 * ((O1 - MINL13.1) / (MAXH13.1 - MINL13.1) + (O2 - MINL13.2) / (MAXH13.2 - MINL13.2) + (O3 - MINL13.3) / (MAXH13.3 - MINL13.3)) / 3
That said, we don't need the entire thing if you just want to find out if your Open based Stochastic is increasing. Please try the following:
(O - MINL13) / (MAXH13 - MINL13) > (O3 - MINL13.3) / (MAXH13.3 - MINL13.3)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |