Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
SGN(TrueInRow(NOT(L < MINL63.1), 126) - TrueInRow(NOT(H > MAXH63.1), 126)) + SGN(TrueInRow(NOT(L < MINL126.1), 126) - TrueInRow(NOT(H > MAXH126.1), 126)) + SGN(TrueInRow(NOT(L < MINL189.1), 126) - TrueInRow(NOT(H > MAXH189.1), 126)) + SGN(TrueInRow(NOT(L < MINL252.1), 126) - TrueInRow(NOT(H > MAXH252.1), 126))
Bruce I need to make an adjustment to the above PCF
Currently this plots the difference between the 4 time frames 63, 126, 189, 252 which means if the last 63 & 126 day High or low was a High but the last 189 and 252 was a Low the indicator plots 0
I need this to instead plot the Num of the Negatives and ignore the positive and neutrals(Zero). On all of them if 126 days passes without either a NH or NL the signal of that time frame goes to 0.
For ex aif we have 1 poistive, 1 neutral and 2 that are negative I need this to plot -2 (Only the total of the negative count)
thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I really can't tell from your description if this is what you want or not, but please give it a try.
IIF(TrueInRow(NOT(L < MINL63.1), 126) < TrueInRow(NOT(H > MAXH63.1), 126), -1, 0) + IIF(TrueInRow(NOT(L < MINL126.1), 126) < TrueInRow(NOT(H > MAXH126.1), 126), -1, 0) + IIF(TrueInRow(NOT(L < MINL189.1), 126) < TrueInRow(NOT(H > MAXH189.1), 126), -1, 0) + IIF(TrueInRow(NOT(L < MINL252.1), 126) < TrueInRow(NOT(H > MAXH252.1), 126), -1, 0)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
It seems correct from first glance i'll test it over the next few hours
Thanks
I run into an issue with IPO's that have less than 252 trading days.
Since there is not enough data it gives you 3 dots
Is there to do anything that when there is not enough data it will plot 0
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I do not know of any workarounds for this.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|