New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: dhirenshah
About
User Name: dhirenshah
Groups: Gold User, Member, Platinum User
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Gender:
Statistics
Joined: Saturday, March 10, 2012
Last Visit: Monday, July 24, 2017 8:10:18 PM
Number of Posts: 181
[0.06% of all post / 0.09 posts per day]
Avatar
Last 10 Posts
Topic: PCF QUERY
Posted: Monday, July 24, 2017 3:47:18 PM

Thankyou very Much Bruce dots work , 

Appreciate your help 

Regards

 

Dhiren Shah

Topic: PCF QUERY
Posted: Monday, July 24, 2017 3:26:19 PM

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 

Topic: PCF QUERY
Posted: Monday, July 24, 2017 2:41:33 PM

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 

Topic: PCF QUERY
Posted: Monday, July 24, 2017 2:22:20 PM

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 

 

Topic: PCF QUERY
Posted: Monday, July 24, 2017 1:17:07 AM

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 

Topic: PCF QUERY
Posted: Sunday, July 23, 2017 2:49:53 PM

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
 
 
 
Topic: PCF HELP
Posted: Monday, July 17, 2017 1:10:18 PM

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 

Topic: PCF HELP
Posted: Monday, July 17, 2017 12:43:44 PM

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

 

Topic: PCF HELP
Posted: Sunday, July 16, 2017 2:00:55 PM

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

Topic: PCF HELP
Posted: Sunday, July 16, 2017 2:48:46 AM

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