dhirenshah 
Gold User, Member, Platinum User

Registered User 




Gender: 

Saturday, March 10, 2012 
Monday, July 24, 2017 8:10:18 PM 
181 [0.06% of all post / 0.09 posts per day] 

Thankyou very Much Bruce dots work ,
Appreciate your help
Regards
Dhiren Shah

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

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

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

Also is it possible to get the count number(125) in the result output when histogram is plotted above zero with +ve count and below zero with ve count !
thanks

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

Yes I wanted pivots earlier to see signal and divergence but it was getting too cluttered , however the below zero formula works perfect,,,
thank you so much

Bruce thanks a lot for the formula
however if i can please get a bit of tweaking from you, i m plotting the formula from diceman as histogram and i want custom pcf% showing histogram today is higher than it was yesterday,and yesterday was the lowest value at least for the 3 bars prior to that when histogram is below zero and want to sort in scan
and same for inverse where today is lower then it was yesterday and yesterday was the highest value for 3 bars prior to that when histogram is above zero and want to sort and scan
thanks again
and no worries Bcochrane ! Cheers

Diceman thanks it works , one more simple question can u pls compute 5 bar pivot high and low on the above formula ? as my parenthesis placement is bad and that sometimes freezes my work
Bcochrane thanks for your input
have a great Sunday
cheers

Bruce
how to write custom formula for MACD indicator using settings short as (MAXH9 + MINL9) / 2
and for long as (MAXH26 + MINL26) / 2
I tried using V17 template but keep getting error
thanks
Dhiren

