| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/21/2007
Posts: 181
|
Is it possible to get a PCF for the "Leader of the MACD" from TASC July 2008? I know the indicator is available in SF but I'm looking for a PCF.
Thanks
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
I don't think so becuase the PCF language doesn't allow you to group operators inside the AVG function.
This would be the formula, but the sections in bold are not valid.
(AVGC12 - AVG(C-AVGC12 ,12)) - (AVGC26 - AVG(C-AVGC26 ,26))
|
|
Registered User
Joined: 8/21/2007
Posts: 181
|
Grrrr... remind me again why you guys are not developing SF any more???
Just kidding.... thanks for your help....
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
2 * XAVGC12 - XAVG(XAVGC12,12) - 2 * XAVGC26 + XAVG(XAVGC26,26)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/2/2017
Posts: 9
|
QUOTE (Bruce_L) Please try the following:
2 * XAVGC12 - XAVG(XAVGC12,12) - 2 * XAVGC26 + XAVG(XAVGC26,26)
Hi Bruce,
to practice PCFs I want to write a 50 simple moving average of that formula, but it doesn't quite work:
AVGC(2 * XAVGC12 - XAVG(XAVGC12,12) - 2 * XAVGC26 + XAVG(XAVGC26,26)),50) does not work. Where am I wrong ?
Martin
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The basic structure should in fact work if you are using TC2000 v17 (but not earlier versions of TC2000). I think you just might have the parentheses wrong.
AVG(2 * XAVGC12 - XAVG(XAVGC12,12) - 2 * XAVGC26 + XAVG(XAVGC26,26), 50)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/2/2017
Posts: 9
|
QUOTE (Bruce_L)
The basic structure should in fact work if you are using TC2000 v17 (but not earlier versions of TC2000). I think you just might have the parentheses wrong.
AVG(2 * XAVGC12 - XAVG(XAVGC12,12) - 2 * XAVGC26 + XAVG(XAVGC26,26), 50)
Also I put "AVGC" instead of "AVG" at the beginning, which was my main mistake.
Very fast reply, thanks so much!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |