Registered User Joined: 12/23/2010 Posts: 10
|
Can someone please help me to develop a PCF to find the condition when:
High of today is greater than 50% above the average range of the previous 5 candlesticks
I developed this one but it doesn't work at all: H>0.51*(ABS((H5-L5)+(H4-L4)+(H3-L3)+(H2-L2)+(H1-L1))/5)
All help will be greatly appreciated.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Price and the range of price use the same units, but they are rarely close to each other in value. The range of price is usually much lower in value than price itself. This means your formula and the very concept of your formula will almost always return true for most stocks.
You would generally need to check for price to be above something that is close to the value of price (such as the open, high, low, close, midpoint or moving average of price) plus some multiple of the range of price to create a formula which is going to have a result which could be either true or false for most symbols instead of almost always being true or almost always being false.
That said, what I suspect is of interest is if the high is above the average midpoint of the 5-bars ending 1-bar ago:
H > (AVGH5.1 + AVGL5.1) / 2
Or above the actual midpoint of the total range of the 5-bars ending 1-bar ago:
H > (MAXH5.1 + MINL5.1) / 2
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: 1/28/2005 Posts: 6,049
|
Bruce
Some things to try if they can be done.
Close greater than simple average close of previous five bars.
All bars Heikin Ashi.
Close greater than simple average midpoint of prevous five bars.
All bars Heikin Ashi.
Close greater than actual midpont of high low range prevous five bars.
All bars Heikin Ashi.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (diceman) Close greater than simple average close of previous five bars.
All bars Heikin Ashi.
O + H + L + C > AVGO5.1 + AVGH5.1 + AVGL5.1 + AVGC5.1
QUOTE (diceman) Close greater than simple average midpoint of prevous five bars.
All bars Heikin Ashi.
O + H + L + C > AVGH5.1 + AVGL5.1 + (AVG(XAVGO3.2,5) + AVG(XAVGH3.2,5) + AVG(XAVGL3.2,5) + AVG(XAVGC3.2,5)) / 2 + (ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4) - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4) + ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4) - ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4) + ABS(H3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4) - ABS(L3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4) + ABS(H4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4) - ABS(L4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4) + ABS(H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4) - ABS(L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)) / 5
QUOTE (diceman) Close greater than actual midpont of high low range prevous five bars.
All bars Heikin Ashi.
O + H + L + C > ((H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+H2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 + ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 - ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))+2*(H3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.1) / 4 + ABS(H3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4))+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+H2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 + ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 - ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))-2*(H3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.1) / 4 + ABS(H3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4)))+2*(H4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.1) / 4 + ABS(H4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)+H5 + (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.1) / 4 + ABS(H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)+ABS(H4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.1) / 4 + ABS(H4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)-H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.1) / 4 - ABS(H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)))+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+H2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 + ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 - ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))+2*(H3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.1) / 4 + ABS(H3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4))+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+H2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 + ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)+ABS(H1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.1) / 4 + ABS(H1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.1) / 4 - ABS(H2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))-2*(H3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.1) / 4 + ABS(H3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4)))-2*(H4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.1) / 4 + ABS(H4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)+H5 + (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.1) / 4 + ABS(H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)+ABS(H4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.1) / 4 + ABS(H4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)-H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.1) / 4 - ABS(H5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4))))) + (L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+L2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 - ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 + ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))+2*(L3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4 - ABS(L3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4))-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+L2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 - ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 + ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))-2*(L3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4 - ABS(L3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4)))+2*(L4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4 - ABS(L4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)+L5 + (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4 - ABS(L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)-ABS(L4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4 - ABS(L4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)-L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4 + ABS(L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)))-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+L2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 - ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 + ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))+2*(L3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4 - ABS(L3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4))-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)+L2 + (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 - ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4)-ABS(L1 + (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4 - ABS(L1 - (XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2) / 4)-L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4 + ABS(L2 - (XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3) / 4))-2*(L3 + (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4 - ABS(L3 - (XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4) / 4)))-2*(L4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4 - ABS(L4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)+L5 + (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4 - ABS(L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)-ABS(L4 + (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4 - ABS(L4 - (XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5) / 4)-L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4 + ABS(L5 - (XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6) / 4)))))) / 8
haDelta
Min Max PCFs
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/23/2010 Posts: 10
|
Bruce - thank you very much.
|
|
Registered User Joined: 3/31/2011 Posts: 68
|
Bruce,
How would you write these two?
1.
The average closing price of the prior six bars is in the upper 50% of the trading range.
2.
The average closing price of the prior six bars is in the lower 50% of the trading range.
Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (tkamada) The average closing price of the prior six bars is in the upper 50% of the trading range.
2 * AVGC6 >= MAXH6 + MINL6 AND MAXH6 > MINL6
QUOTE (tkamada) The average closing price of the prior six bars is in the lower 50% of the trading range.
2 * AVGC6 <= MAXH6 + MINL6 AND MAXH6 > MINL6
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/31/2011 Posts: 68
|
Bruce,
Thank you for your help.
T.Kamada
|
|
Registered User Joined: 3/31/2011 Posts: 68
|
Bruce,
I have one more question. Are those formulas still the same if Heikin-ashi bars are used?
Thank you.
QUOTE (Bruce_L)
QUOTE (tkamada) The average closing price of the prior six bars is in the upper 50% of the trading range.
2 * AVGC6 >= MAXH6 + MINL6 AND MAXH6 > MINL6
QUOTE (tkamada) The average closing price of the prior six bars is in the lower 50% of the trading range.
2 * AVGC6 <= MAXH6 + MINL6 AND MAXH6 > MINL6
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
No, the formulas for regular bars and HA bars are not even close.
QUOTE (tkamada) The average closing price of the prior six bars is in the upper 50% of the trading range.
AVGO6 + AVGH6 + AVGL6 + AVGC6 >= ((4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)+ABS(4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))+XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)+2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6))+ABS(4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)+ABS(4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))-XAVGO3.4 - XAVGH3.4 - XAVGL3.4 - XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)))) + (4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)-ABS(4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))+XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)+2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6))-ABS(4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)-ABS(4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))-XAVGO3.4 - XAVGH3.4 - XAVGL3.4 - XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6))))) / 16
QUOTE (tkamada) The average closing price of the prior six bars is in the lower 50% of the trading range.
AVGO6 + AVGH6 + AVGL6 + AVGC6 <= ((4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)+ABS(4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))+XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)+2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6))+ABS(4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)+ABS(4 * MAXH6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1+ABS(4 * MAXH6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))-XAVGO3.4 - XAVGH3.4 - XAVGL3.4 - XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)))) + (4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)-ABS(4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))+XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)+2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6))-ABS(4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)+XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2+XAVGO3.3 + XAVGH3.3 + XAVGL3.3 + XAVGC3.3-ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3)-ABS(4 * MINL6+XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1-ABS(4 * MINL6-XAVGO3.1 - XAVGH3.1 - XAVGL3.1 - XAVGC3.1)-XAVGO3.2 - XAVGH3.2 - XAVGL3.2 - XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3+ABS(XAVGO3.2 + XAVGH3.2 + XAVGL3.2 + XAVGC3.2-XAVGO3.3 - XAVGH3.3 - XAVGL3.3 - XAVGC3.3))-XAVGO3.4 - XAVGH3.4 - XAVGL3.4 - XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6)+ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4+XAVGO3.5 + XAVGH3.5 + XAVGL3.5 + XAVGC3.5-ABS(XAVGO3.4 + XAVGH3.4 + XAVGL3.4 + XAVGC3.4-XAVGO3.5 - XAVGH3.5 - XAVGL3.5 - XAVGC3.5)-2*(XAVGO3.6 + XAVGH3.6 + XAVGL3.6 + XAVGC3.6))))) / 16
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/31/2011 Posts: 68
|
Bruce,
Thank you. I appreciate your help.
T.Kamada
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
I tried out all of the various formulas posted above but none of them match the TTM Trend indicator. I think the issue may be that the Heiken-Ashi Opening price should be based on an average of the previous days open and close price. Therefore simply using Open (O) in the formula does not give an accurate Heiken-Ashi opening price.
TTM Trend with default settting is defined as a Closing price greater than the average of the previous 6 days closing price. All bars are Heiken-Ashi.
I tried both of these formulas but neither is accurate to the built in version of the indicator in TOS.
O + H + L + C > AVGO6.1 + AVGH6.1 + AVGL6.1 + AVGC6.1
C > (AVGO6.1 + AVGH6.1 + AVGL6.1 + AVGC6.1) / 4
I'm wondering if one of these formulas might be the correct one IF the opening price was a proper Heiken-Ashi opening price (average of the previous days open and close price).
Any additional thoughts on how to replicate this indicator?
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
Apparently there is more to a proper calculation of Heiken-Ashi bars.
1. The Heikin-Ashi Close is simply an average of the open,
high, low and close for the current period.
HA-Close = (Open(0) + High(0) + Low(0) + Close(0)) / 4
2. The Heikin-Ashi Open is the average of the prior Heikin-Ashi
candlestick open plus the close of the prior Heikin-Ashi candlestick.
HA-Open = (HA-Open(-1) + HA-Close(-1)) / 2
3. The Heikin-Ashi High is the maximum of three data points:
the current period's high, the current Heikin-Ashi
candlestick open or the current Heikin-Ashi candlestick close.
HA-High = Maximum of the High(0), HA-Open(0) or HA-Close(0)
4. The Heikin-Ashi low is the minimum of three data points:
the current period's low, the current Heikin-Ashi
candlestick open or the current Heikin-Ashi candlestick close.
HA-Low = Minimum of the Low(0), HA-Open(0) or HA-Close(0)
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
Here are a couple more formulas I created... but there are too many false signals compared to the original indicator. Still struggling with this.
(((O1 + C1) / 2) + H + L + C) / 4 > (((((O7 + C7) / 2) + H6 + L6 + C6) / 4) + ((((O6 + C6) / 2) + H5 + L5 + C5) / 4) + ((((O5 + C5) / 2) + H4 + L4 + C4) / 4) + ((((O4 + C4) / 2) + H3 + L3 + C3) / 4) + ((((O3 + C3) / 2) + H2 + L2 + C2) / 4) + ((((O2 + C2) / 2) + H1 + L1 + C1) / 4)) / 6
C > (((((O7 + C7) / 2) + H6 + L6 + C6) / 4) + ((((O6 + C6) / 2) + H5 + L5 + C5) / 4) + ((((O5 + C5) / 2) + H4 + L4 + C4) / 4) + ((((O4 + C4) / 2) + H3 + L3 + C3) / 4) + ((((O3 + C3) / 2) + H2 + L2 + C2) / 4) + ((((O2 + C2) / 2) + H1 + L1 + C1) / 4)) / 6
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
Here's another take on it based on a description from John Carter at 2:18 in this video.
http://www.tradethemarkets.com/public/Review_on_How_I_Read_Charts.cfm
If the midpoint of the current bar is above the Heiken Ashi average closing price of the previous 6 days then the bar is marked as being in an uptrend.
(H + L) / 2 > (((((O7 + C7) / 2) + H6 + L6 + C6) / 4) + ((((O6 + C6) / 2) + H5 + L5 + C5) / 4) + ((((O5 + C5) / 2) + H4 + L4 + C4) / 4) + ((((O4 + C4) / 2) + H3 + L3 + C3) / 4) + ((((O3 + C3) / 2) + H2 + L2 + C2) / 4) + ((((O2 + C2) / 2) + H1 + L1 + C1) / 4)) / 6
Interested in thoughts or confirmation that this is correct. The formula still doesn't match the results I see in TOS but it is useable.
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
After trying a lot of different things, this is what I am using for now. It's relatively close to TTM Trend but tends to flash opposing signals in some cases where TTM Trend would still keep you in the move.
(AVGH6.1 + AVGL6.1) / 2 < (((((O6 + C6) / 2) + H5 + L5 + C5) / 4) + ((((O5 + C5) / 2) + H4 + L4 + C4) / 4) + ((((O4 + C4) / 2) + H3 + L3 + C3) / 4) + ((((O3 + C3) / 2) + H2 + L2 + C2) / 4) + ((((O2 + C2) / 2) + H1 + L1 + C1) / 4) + ((((O1 + C1) / 2) + H + L + C) / 4)) / 6
I'm still looking for additional feedback from anyone who has more insight on the TTM Trend formula or who has created a more accurate representation.
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
QUOTE (Telework)
I'm still looking for additional feedback from anyone who has more insight on the TTM Trend formula or who has created a more accurate representation.
I know in TradeStation the code works like this:
First Bar:
HaOpen=OPEN
HaClose=(O+H+L+C)/4
After that:
HaOpen=(HaOpen yesterday+HaClose yesterday)/2
HaClose=(O+H+L+4)/4
I dont think this can be done exactly in Telechart because youre
accessing a running calculation.
(you can only simulate it or get close)
Thanks
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
diceman, you have posted the formulas for calculating a Heiken-Ashi bar, but not the TTM Trend which is based on Average Range of the last 6 bars residing above or below the midpoint of the current Heiken-Ashi MA (6 bar moving average I think).
Do you have access to the full TTM Trend code in TradeStation that might give us more information?
Thanks
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
Yes, after the initial calc:
if haClose > haOpen then color = UpColor
else color = DnColor;
for value1 = 1 to CompBars
begin
if haOpen <= MaxList(haOpen[value1],haClose[value1]) and
haOpen >= MinList(haOpen[value1],haClose[value1]) and
haClose <= MaxList(haOpen[value1],haClose[value1]) and
haClose >= MinList(haOpen[value1],haClose[value1]) then
color = color[value1];
end;
If youre not familiar with TS language.
Just off the top of my head.
Value1 to Compbars is a For Next loop
(Compbars is the 6 and sets the lookback period value1 is the counter)
Maxlist is the highest value within the parentheses.
Minlist is the lowest.
So its comparing today's haopen and haclose to those lists each bar back until 6 back.
I suspect this loop is what keeps the color from switching. (until an actual change)
I just haven't had the time to look at it.
Thanks
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
I don't fully get it. Maybe Bruce or someone else would be able to translate that into a PCF formula based on Compbars = 6
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
diceman or Bruce, do either of you have the know-how to translate the Tradestation code above into TC2000 PCF?
I'm revisiting this topic and would really like to understand this original code better.
Thanks in advance.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (diceman) First Bar:
HaOpen=OPEN
HaClose=(O+H+L+C)/4
After that:
HaOpen=(HaOpen yesterday+HaClose yesterday)/2
HaClose=(O+H+L+4)/4
I dont think this can be done exactly in Telechart because youre
accessing a running calculation.
(you can only simulate it or get close)
HA Open really can be safely written as follows.
(XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1) / 4
And HA Close is always exactly:
(O + H + L + C) / 4
The initilization condition of using O for HA Open for the first bar is going to very, very quickly get reduced to not affecting the value in any significant way. I would be quite impressed if it were noticable after 15 terms (or 5 times the period of the EMA being used).
All of the other terms besides the oldest term in the HA Open calculation are using (O + H + L + C) / 4, so the O for the first bar is pretty much meaningless. The amount of historical data used is going to affect the values of these early bars more than the initialization value for example if the number of bars doesn't match exactly.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |