Gold Customer
Joined: 12/16/2013 Posts: 7
|
I'm not sure there is a way to do this in TC2000 but thought to ask, since there have been several new versions rolled out recently with updated PCF coding...
If possible, I'd like to replicate the Andrew Abraham trend indicator from the 1998 Stocks and Commodities magazine....
Basicaly, the plot should compare today's close vs the Daily High in the priior 21 days minu the 21 day ATR and today's close vs the Daily Low in the prior 21 days plus the 21 day ATR and plot the following
If C > [MAXC.21 - ATR(21) AND MINL.21 + ATR(21)] then plot MAXC.21 - ATR(21)
If C < [MAXC.21 - ATR(21) AND MINL.21 + ATR(21)] then plot MINC.21 + ATR(21)
If neither of the above is true, then plot the previous day's value.
I am able to create PCF for MAXC.21 - ATR(21) and MINL.21 + ATR(21)] but unsure how to nest them to create condiational statements - if this is even possible.
Any help appreciated.
Thanks
Wesley
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If I am understanding your description correctly, you could use something similar the following Formula in a Custom PCF Indicator set to the Dots Plot Style plotted in the same pane and scale as price in TC2000 v17.
IIF(C > MAXC21 - ATR21 AND C > MINC21 + ATR21, MAXC21 - ATR21, IIF(C < MAXC21 - ATR21 AND C < MINC21 + ATR21, MINC21 + ATR21, 1 / 0))
I would however be tempted to use two different Custom PCF Indicators plotted in different colors.
IIF(C > MAXC21 - ATR21 AND C > MINC21 + ATR21, MAXC21 - ATR21, 1 / 0)
And:
IIF(C < MAXC21 - ATR21 AND C < MINC21 + ATR21, MINC21 + ATR21, 1 / 0)
This actually plots no dots when neither of the requirements is true instead of the last value, but I cann't think of a good way to just plot the last value using the current syntax.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
QUOTE (Nattow Gate)
I'm not sure there is a way to do this in TC2000 but thought to ask, since there have been several new versions rolled out recently with updated PCF coding...
If possible, I'd like to replicate the Andrew Abraham trend indicator from the 1998 Stocks and Commodities magazine....
Basicaly, the plot should compare today's close vs the Daily High in the priior 21 days minu the 21 day ATR and today's close vs the Daily Low in the prior 21 days plus the 21 day ATR and plot the following
I dont know if you are trying to make the same indicator or your version?
The article describes a weighted ATR indicator * 3:
"The calculation uses a 21-period weighted average of the true
range, giving higher weight to the true range of the most
recent bar. The final value is then multiplied by 3."
Thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If we were to use a weighted moving average and an ATR multiplier of 3 while sticking with the logic outlined in the original post, then the nested Formula would be the following.
IIF(C > MAXC21 - 3 * FAVG(ATR, 21) AND C > MINC21 + 3 * FAVG(ATR, 21), MAXC21 - 3 * FAVG(ATR, 21), IIF(C < MAXC21 - 3 * FAVG(ATR, 21) AND C < MINC21 + 3 * FAVG(ATR, 21), MINC21 + 3 * FAVG(ATR, 21), 1 / 0))
And the versions to use with different colors would be:
IIF(C > MAXC21 - 3 * FAVG(ATR, 21) AND C > MINC21 + 3 * FAVG(ATR, 21), MAXC21 - 3 * FAVG(ATR, 21), 1 / 0)
And:
IIF(C < MAXC21 - 3 * FAVG(ATR, 21) AND C < MINC21 + 3 * FAVG(ATR, 21), MINC21 + 3 * FAVG(ATR, 21), 1 / 0)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|