Hi Bruce 

a while back you did this pcf for me and it works perfect

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 

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 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 

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.

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 

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)))))))))))))))

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 

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)

Thankyou very Much Bruce dots work , 

Appreciate your help 

Regards

Dhiren Shah

You're welcome.