Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/10/2012 Posts: 465
|
Hi Bruce
a while back you did this pcf for me and it works perfect
ABS(C > H25) * (ABS(C <= H24) + ABS(C > H24) * (ABS(C <= H23) * 2 + ABS(C > H23) * (ABS(C <= H22) * 3 + ABS(C > H22) * (ABS(C <= H21) * 4 + ABS(C > H21) * (ABS(C <= H20) * 5 + ABS(C > H20) * (ABS(C <= H19) * 6 + ABS(C > H19) * (ABS(C <= H18) * 7 + ABS(C > H18) * (ABS(C <= H17) * 8 + ABS(C > H17) * (ABS(C <= H16) * 9 + ABS(C > H16) * (ABS(C <= H15) * 10 + ABS(C > H15) * (ABS(C <= H14) * 11 + ABS(C > H14) * (ABS(C <= H13) * 12 + ABS(C > H13) * (ABS(C <= H12) * 13 + ABS(C > H12) * (ABS(C <= H11) * 14 + ABS(C > H11) * (ABS(C <= H10) * 15 + ABS(C > H10) * (ABS(C <= H9) * 16 + ABS(C > H9) * (ABS(C <= H8) * 17 + ABS(C > H8) * (ABS(C <= H7) * 18 + ABS(C > H7) * (ABS(C <= H6) * 19 + ABS(C > H6) * (ABS(C <= H5) * 20 + ABS(C > H5) * (ABS(C <= H4) * 21 + ABS(C > H4) * (ABS(C <= H3) * 22 + ABS(C > H3) * (ABS(C <= H2) * 23 + ABS(C > H2) * (ABS(C <= H1) * 24 + ABS(C > H1) * 25))))))))))))))))))))))))
So Now my question is in V17 is it possible to pcf the above as histogram with zero line centred where if formula count is above 15 then it plots histogram above zero with bright green colour and if count is between 1 and 14 then it will still remain above zero but colour will fade lighter green , and as the count goes negative as below formula below zero line from 1 to 14 bars the colour will be lighter red and as the count increases to above 15 when below zero line the colour becomes bright red
ABS(C < L25) * (ABS(C >= L24) + ABS(C < L24) * (ABS(C >= L23) * 2 + ABS(C < L23) * (ABS(C >= L22) * 3 + ABS(C < L22) * (ABS(C >= L21) * 4 + ABS(C < L21) * (ABS(C >= L20) * 5 + ABS(C < L20) * (ABS(C >= L19) * 6 + ABS(C < L19) * (ABS(C >= L18) * 7 + ABS(C < L18) * (ABS(C >= L17) * 8 + ABS(C < L17) * (ABS(C >= L16) * 9 + ABS(C < L16) * (ABS(C >= L15) * 10 + ABS(C < L15) * (ABS(C >= L14) * 11 + ABS(C < L14) * (ABS(C >= L13) * 12 + ABS(C < L13) * (ABS(C >= L12) * 13 + ABS(C < L12) * (ABS(C >= L11) * 14 + ABS(C < L11) * (ABS(C >= L10) * 15 + ABS(C < L10) * (ABS(C >= L9) * 16 + ABS(C < L9) * (ABS(C >= L8) * 17 + ABS(C < L8) * (ABS(C >= L7) * 18 + ABS(C < L7) * (ABS(C >= L6) * 19 + ABS(C < L6) * (ABS(C >= L5) * 20 + ABS(C < L5) * (ABS(C >= L4) * 21 + ABS(C < L4) * (ABS(C >= L3) * 22 + ABS(C < L3) * (ABS(C >= L2) * 23 + ABS(C < L2) * (ABS(C >= L1) * 24 + ABS(C < L1) * 25))))))))))))))))))))))))
Thanks a lot
Cheers
Dhiren
|
|
Registered User Joined: 3/10/2012 Posts: 465
|
Also is it possible to get the count number(1-25) in the result output when histogram is plotted above zero with +ve count and below zero with -ve count !
thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Use this for what I am assuming is +ve (what you are using already). Set it to be a green histogram.
ABS(C > H25) * (ABS(C <= H24) + ABS(C > H24) * (ABS(C <= H23) * 2 + ABS(C > H23) * (ABS(C <= H22) * 3 + ABS(C > H22) * (ABS(C <= H21) * 4 + ABS(C > H21) * (ABS(C <= H20) * 5 + ABS(C > H20) * (ABS(C <= H19) * 6 + ABS(C > H19) * (ABS(C <= H18) * 7 + ABS(C > H18) * (ABS(C <= H17) * 8 + ABS(C > H17) * (ABS(C <= H16) * 9 + ABS(C > H16) * (ABS(C <= H15) * 10 + ABS(C > H15) * (ABS(C <= H14) * 11 + ABS(C > H14) * (ABS(C <= H13) * 12 + ABS(C > H13) * (ABS(C <= H12) * 13 + ABS(C > H12) * (ABS(C <= H11) * 14 + ABS(C > H11) * (ABS(C <= H10) * 15 + ABS(C > H10) * (ABS(C <= H9) * 16 + ABS(C > H9) * (ABS(C <= H8) * 17 + ABS(C > H8) * (ABS(C <= H7) * 18 + ABS(C > H7) * (ABS(C <= H6) * 19 + ABS(C > H6) * (ABS(C <= H5) * 20 + ABS(C > H5) * (ABS(C <= H4) * 21 + ABS(C > H4) * (ABS(C <= H3) * 22 + ABS(C > H3) * (ABS(C <= H2) * 23 + ABS(C > H2) * (ABS(C <= H1) * 24 + ABS(C > H1) * 25))))))))))))))))))))))))
Now add a second indicator in the same pane and scale and set it to be a light green histogram.
ABS(C > H25) * (ABS(C <= H24) + ABS(C > H24) * (ABS(C <= H23) * 2 + ABS(C > H23) * (ABS(C <= H22) * 3 + ABS(C > H22) * (ABS(C <= H21) * 4 + ABS(C > H21) * (ABS(C <= H20) * 5 + ABS(C > H20) * (ABS(C <= H19) * 6 + ABS(C > H19) * (ABS(C <= H18) * 7 + ABS(C > H18) * (ABS(C <= H17) * 8 + ABS(C > H17) * (ABS(C <= H16) * 9 + ABS(C > H16) * (ABS(C <= H15) * 10 + ABS(C > H15) * (ABS(C <= H14) * 11 + ABS(C > H14) * (ABS(C <= H13) * 12 + ABS(C > H13) * (ABS(C <= H12) * 13 + ABS(C > H12) * (ABS(C <= H11) * 14))))))))))))))
Add your existing -ve formula to the same pane and scale as other two as a red histogram, but put the formula inside -() to make it negative.
-(ABS(C < L25) * (ABS(C >= L24) + ABS(C < L24) * (ABS(C >= L23) * 2 + ABS(C < L23) * (ABS(C >= L22) * 3 + ABS(C < L22) * (ABS(C >= L21) * 4 + ABS(C < L21) * (ABS(C >= L20) * 5 + ABS(C < L20) * (ABS(C >= L19) * 6 + ABS(C < L19) * (ABS(C >= L18) * 7 + ABS(C < L18) * (ABS(C >= L17) * 8 + ABS(C < L17) * (ABS(C >= L16) * 9 + ABS(C < L16) * (ABS(C >= L15) * 10 + ABS(C < L15) * (ABS(C >= L14) * 11 + ABS(C < L14) * (ABS(C >= L13) * 12 + ABS(C < L13) * (ABS(C >= L12) * 13 + ABS(C < L12) * (ABS(C >= L11) * 14 + ABS(C < L11) * (ABS(C >= L10) * 15 + ABS(C < L10) * (ABS(C >= L9) * 16 + ABS(C < L9) * (ABS(C >= L8) * 17 + ABS(C < L8) * (ABS(C >= L7) * 18 + ABS(C < L7) * (ABS(C >= L6) * 19 + ABS(C < L6) * (ABS(C >= L5) * 20 + ABS(C < L5) * (ABS(C >= L4) * 21 + ABS(C < L4) * (ABS(C >= L3) * 22 + ABS(C < L3) * (ABS(C >= L2) * 23 + ABS(C < L2) * (ABS(C >= L1) * 24 + ABS(C < L1) * 25)))))))))))))))))))))))))
Then add the following formula to the same pane and scale as the other three indicators as a light red histogram.
-(ABS(C < L25) * (ABS(C >= L24) + ABS(C < L24) * (ABS(C >= L23) * 2 + ABS(C < L23) * (ABS(C >= L22) * 3 + ABS(C < L22) * (ABS(C >= L21) * 4 + ABS(C < L21) * (ABS(C >= L20) * 5 + ABS(C < L20) * (ABS(C >= L19) * 6 + ABS(C < L19) * (ABS(C >= L18) * 7 + ABS(C < L18) * (ABS(C >= L17) * 8 + ABS(C < L17) * (ABS(C >= L16) * 9 + ABS(C < L16) * (ABS(C >= L15) * 10 + ABS(C < L15) * (ABS(C >= L14) * 11 + ABS(C < L14) * (ABS(C >= L13) * 12 + ABS(C < L13) * (ABS(C >= L12) * 13 + ABS(C < L12) * (ABS(C >= L11) * 14)))))))))))))))
The order that these indicators is added matters as the indicators you add later will be plotted on top of the indicators added earlier.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/10/2012 Posts: 465
|
Bruce i m getting the above zero numbering correct but below zero the histogram seems not showing any number it stays at zero...
example CMG on daily should have shown -24 but its not showing ( can we adjust that in pcf ) it shows the -24 when i left click on red histogram and it shows in data box but not to the right of result pane
Same with AZO on daily when i hover left click then the data is there of -13 but not on to the right of histogram pane it stays at zero
same with SBUX on daily no result number on to the right it says at zero and it should show -9
so what to be corrected ?
thanks a lot
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Have you added all four formulas to the same pane and scale? It takes four indicators plotted in different colors to produce the desired colors. Each of these indicators returns its own set of values. No indicator returns all of the values.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/10/2012 Posts: 465
|
Yes i have added them in same pane and scale ... i m getting the values in data box when i left click on below zero histogram but the value does not show in right of the pane ... the value of above zero items show on right of the pane but the below zero are not showing ,
can u pls try plotting at your end, ? or is my -ve side formula incorrect from my original post ? as i created -ve side from your formula...
thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I did add all of the indicators to my chart before I even posted. It is four indicators. The value only plots in the scale for the first indicator.
If what you are concerned about is the number ot the right in the scale, you could create it using two Custom PCF Indicators instead of four.
Use the following for the first Custom PCF Indicator with the Plot Color set to green and Negative Value Color checked and set to red.
ABS(C > H25) * (ABS(C <= H24) + ABS(C > H24) * (ABS(C <= H23) * 2 + ABS(C > H23) * (ABS(C <= H22) * 3 + ABS(C > H22) * (ABS(C <= H21) * 4 + ABS(C > H21) * (ABS(C <= H20) * 5 + ABS(C > H20) * (ABS(C <= H19) * 6 + ABS(C > H19) * (ABS(C <= H18) * 7 + ABS(C > H18) * (ABS(C <= H17) * 8 + ABS(C > H17) * (ABS(C <= H16) * 9 + ABS(C > H16) * (ABS(C <= H15) * 10 + ABS(C > H15) * (ABS(C <= H14) * 11 + ABS(C > H14) * (ABS(C <= H13) * 12 + ABS(C > H13) * (ABS(C <= H12) * 13 + ABS(C > H12) * (ABS(C <= H11) * 14 + ABS(C > H11) * (ABS(C <= H10) * 15 + ABS(C > H10) * (ABS(C <= H9) * 16 + ABS(C > H9) * (ABS(C <= H8) * 17 + ABS(C > H8) * (ABS(C <= H7) * 18 + ABS(C > H7) * (ABS(C <= H6) * 19 + ABS(C > H6) * (ABS(C <= H5) * 20 + ABS(C > H5) * (ABS(C <= H4) * 21 + ABS(C > H4) * (ABS(C <= H3) * 22 + ABS(C > H3) * (ABS(C <= H2) * 23 + ABS(C > H2) * (ABS(C <= H1) * 24 + ABS(C > H1) * 25)))))))))))))))))))))))) - (ABS(C < L25) * (ABS(C >= L24) + ABS(C < L24) * (ABS(C >= L23) * 2 + ABS(C < L23) * (ABS(C >= L22) * 3 + ABS(C < L22) * (ABS(C >= L21) * 4 + ABS(C < L21) * (ABS(C >= L20) * 5 + ABS(C < L20) * (ABS(C >= L19) * 6 + ABS(C < L19) * (ABS(C >= L18) * 7 + ABS(C < L18) * (ABS(C >= L17) * 8 + ABS(C < L17) * (ABS(C >= L16) * 9 + ABS(C < L16) * (ABS(C >= L15) * 10 + ABS(C < L15) * (ABS(C >= L14) * 11 + ABS(C < L14) * (ABS(C >= L13) * 12 + ABS(C < L13) * (ABS(C >= L12) * 13 + ABS(C < L12) * (ABS(C >= L11) * 14 + ABS(C < L11) * (ABS(C >= L10) * 15 + ABS(C < L10) * (ABS(C >= L9) * 16 + ABS(C < L9) * (ABS(C >= L8) * 17 + ABS(C < L8) * (ABS(C >= L7) * 18 + ABS(C < L7) * (ABS(C >= L6) * 19 + ABS(C < L6) * (ABS(C >= L5) * 20 + ABS(C < L5) * (ABS(C >= L4) * 21 + ABS(C < L4) * (ABS(C >= L3) * 22 + ABS(C < L3) * (ABS(C >= L2) * 23 + ABS(C < L2) * (ABS(C >= L1) * 24 + ABS(C < L1) * 25)))))))))))))))))))))))))
And set the second Custom PCF Indicator to light green for Plot Color and light red for Negative Value Color.
ABS(C > H25) * (ABS(C <= H24) + ABS(C > H24) * (ABS(C <= H23) * 2 + ABS(C > H23) * (ABS(C <= H22) * 3 + ABS(C > H22) * (ABS(C <= H21) * 4 + ABS(C > H21) * (ABS(C <= H20) * 5 + ABS(C > H20) * (ABS(C <= H19) * 6 + ABS(C > H19) * (ABS(C <= H18) * 7 + ABS(C > H18) * (ABS(C <= H17) * 8 + ABS(C > H17) * (ABS(C <= H16) * 9 + ABS(C > H16) * (ABS(C <= H15) * 10 + ABS(C > H15) * (ABS(C <= H14) * 11 + ABS(C > H14) * (ABS(C <= H13) * 12 + ABS(C > H13) * (ABS(C <= H12) * 13 + ABS(C > H12) * (ABS(C <= H11) * 14)))))))))))))) - (ABS(C < L25) * (ABS(C >= L24) + ABS(C < L24) * (ABS(C >= L23) * 2 + ABS(C < L23) * (ABS(C >= L22) * 3 + ABS(C < L22) * (ABS(C >= L21) * 4 + ABS(C < L21) * (ABS(C >= L20) * 5 + ABS(C < L20) * (ABS(C >= L19) * 6 + ABS(C < L19) * (ABS(C >= L18) * 7 + ABS(C < L18) * (ABS(C >= L17) * 8 + ABS(C < L17) * (ABS(C >= L16) * 9 + ABS(C < L16) * (ABS(C >= L15) * 10 + ABS(C < L15) * (ABS(C >= L14) * 11 + ABS(C < L14) * (ABS(C >= L13) * 12 + ABS(C < L13) * (ABS(C >= L12) * 13 + ABS(C < L12) * (ABS(C >= L11) * 14)))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/10/2012 Posts: 465
|
Superb Bruce,,
this works... thank you very much ..and one last question on this topic.. there are some bars on histogram which has no up or down histogram bars so its at zero value can ipls get pcf to plot aother colour for only those value histogram
that way its very easy to see at one glance
thanks a lot
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Maybe the following as a third Custom PCF Indicator in the same pane and scale using either the Dots or Histogram Plot Style?
IIF(ABS(C > H25) * (ABS(C <= H24) + ABS(C > H24) * (ABS(C <= H23) * 2 + ABS(C > H23) * (ABS(C <= H22) * 3 + ABS(C > H22) * (ABS(C <= H21) * 4 + ABS(C > H21) * (ABS(C <= H20) * 5 + ABS(C > H20) * (ABS(C <= H19) * 6 + ABS(C > H19) * (ABS(C <= H18) * 7 + ABS(C > H18) * (ABS(C <= H17) * 8 + ABS(C > H17) * (ABS(C <= H16) * 9 + ABS(C > H16) * (ABS(C <= H15) * 10 + ABS(C > H15) * (ABS(C <= H14) * 11 + ABS(C > H14) * (ABS(C <= H13) * 12 + ABS(C > H13) * (ABS(C <= H12) * 13 + ABS(C > H12) * (ABS(C <= H11) * 14 + ABS(C > H11) * (ABS(C <= H10) * 15 + ABS(C > H10) * (ABS(C <= H9) * 16 + ABS(C > H9) * (ABS(C <= H8) * 17 + ABS(C > H8) * (ABS(C <= H7) * 18 + ABS(C > H7) * (ABS(C <= H6) * 19 + ABS(C > H6) * (ABS(C <= H5) * 20 + ABS(C > H5) * (ABS(C <= H4) * 21 + ABS(C > H4) * (ABS(C <= H3) * 22 + ABS(C > H3) * (ABS(C <= H2) * 23 + ABS(C > H2) * (ABS(C <= H1) * 24 + ABS(C > H1) * 25)))))))))))))))))))))))) - (ABS(C < L25) * (ABS(C >= L24) + ABS(C < L24) * (ABS(C >= L23) * 2 + ABS(C < L23) * (ABS(C >= L22) * 3 + ABS(C < L22) * (ABS(C >= L21) * 4 + ABS(C < L21) * (ABS(C >= L20) * 5 + ABS(C < L20) * (ABS(C >= L19) * 6 + ABS(C < L19) * (ABS(C >= L18) * 7 + ABS(C < L18) * (ABS(C >= L17) * 8 + ABS(C < L17) * (ABS(C >= L16) * 9 + ABS(C < L16) * (ABS(C >= L15) * 10 + ABS(C < L15) * (ABS(C >= L14) * 11 + ABS(C < L14) * (ABS(C >= L13) * 12 + ABS(C < L13) * (ABS(C >= L12) * 13 + ABS(C < L12) * (ABS(C >= L11) * 14 + ABS(C < L11) * (ABS(C >= L10) * 15 + ABS(C < L10) * (ABS(C >= L9) * 16 + ABS(C < L9) * (ABS(C >= L8) * 17 + ABS(C < L8) * (ABS(C >= L7) * 18 + ABS(C < L7) * (ABS(C >= L6) * 19 + ABS(C < L6) * (ABS(C >= L5) * 20 + ABS(C < L5) * (ABS(C >= L4) * 21 + ABS(C < L4) * (ABS(C >= L3) * 22 + ABS(C < L3) * (ABS(C >= L2) * 23 + ABS(C < L2) * (ABS(C >= L1) * 24 + ABS(C < L1) * 25))))))))))))))))))))))))) = 0, 0, 1 / 0)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/10/2012 Posts: 465
|
Thankyou very Much Bruce dots work ,
Appreciate your help
Regards
Dhiren Shah
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |