Bruce, 

Few months ago you wrote the PCF below that plots the volume based on where the stock closed in its Daily Range and I have monitored this with PP signals 

V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2)

this is pcf for the PP i use 

(C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10))

I like to change the PP PCF and Adj the Volume based on where the stock closed within its DR.

For ex

Please take a look at MSFT and as you can see it did not meet the PP requirement yesterday as yesterday's volume was lower than the 11/20 volume when the stock closed down

But on 11/20 the stock closed almost at the 45% of its DR so since the stock closed significantly off of its lows I like to adjust the Down day volume based on where the stock closed within its DR.   

Total of 64M shares traded on 11/20 - Adj that based on the Close vs DR 35.4M (55% of the Volume) as Down Vol and 28.7M (45% of the Volume) as Up Vol

Yesterday 11/28 the stock traded total of 46.8M shares and closed at the 95% of its DR - Meaning 95% of the total Vol as Up Vol (44.4M) and 5% of the total volume as Down Vol (2.3M) 

I want the new PP PCF to compare today's Up Vol vs. the Down Volume in the last 10 days 

As such yesterday MSFT would have had a PP signal since yesterday's Up Vol of 44.4M was higher than any of the Down Day Volumes in the last 10 days  

AMZN is another ex - It did not qualify as PP yesterday since yesterday's vol was lower than the 11/20 vol when the stock closed down. But on 11/20 AMZN closed at the 65.76% of its DR. 

If we Adj the Down Day Vol based on Close vs. DR it would only count about 35% of the total vol on 11/20 as Down Vol. 

yesterday it traded 8.4M shares and closed at 96.3% of DR so the Up Vol yesterday was 8.1M shares which is higher than any of the Down Day Vol's in the last 10 days   

Can this be done?   

My interpretation of what you are describing would be the following.

(C > C1 AND V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2) > MAX(V1 * IIF(H1 > L1 OR H1 <> C2, (C1 - LEAST(L1, C2)) / (GREATEST(H1, C2) - LEAST(L1, C2)), 1 / 2), 10))

Bruce, I played with the above PCF and something is off 

I plotted your PCF as a IIF function so I can compare

IIF((C > C1 AND V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2) > MAX(V1 * IIF(H1 > L1 OR H1 <> C2, (C1 - LEAST(L1, C2)) / (GREATEST(H1, C2) - LEAST(L1, C2)), 1 / 2), 10)), 10, 1/0)

This will plot 10 if true and nothing if false 

if you plot the above it shows that 10/25 was a PP on MSFT which is not true

On 10/25 MSFT Total Vol was 61.6M and the stock closed at 86% of DR therefore 86% of the Total Vol will be the UP Day Vol at 53M Shares 

One day before on 10/24 MSFT traded 63.8M Shares and closed at 10.58% of its DR making 89.42% of the Total Vol as Down Day Vol 57.1

10/25 - 61.6M Total Volume - Closed at 86% of DR - Up Day Vol (53M - 86% of 61.6M) with remaining 14% as Down Day Vol

10/24 - 63.8M Total Volume - Closed at 10.58% of DR - Up Day Vol (6.8M - 10.58% of 63.8M) and Down Day Vol (57.1M - 89.42% of 63.8M) 

So the Up Vol on 10/25 of 53M shares was less than the Down Vol of 57.1M on 10/24 therefore the condition should be false on 10/25 and not true 

MA on 10/11 vs 10/12 is another ex

The PCF plots 10/12 as True and that's incorrect 

10/11 Total Vol was 9.2M (2.2M Up Vol, 7.0M Down Vol based on closing at 23.46% of DR)

10/12 Total Vol was 6.2M (5.8M Up Vol, 370K Down Vol based on closing at 94% of DR) 

The 5.8M Up Vol on 10/12 is less than the 7.0M Down Vol on 10/11

Even the Total Vol of 6.2M on 10/12 is less than the 7.0M Down Vol on 10/12

It should be False on 10/12 and not True 

The Up Vol should be higher then Down Vol in the last 10 days 

Thanks  

Up volume was being compared to up volume, to compare it to down volume, please try the following instead.

2 * C > GREATEST(H, C1) + LEAST(L, C1) AND V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2) > MAX(V1 * IIF(H1 > L1 OR H1 <> C2, (GREATEST(H1, C2) - C1) / (GREATEST(H1, C2) - LEAST(L1, C2)), 1 / 2), 10)

It also switches from checking for price being above the previous close to price being above the middle of DR for the current bar. You can replace everything before the first AND with C > C1 instead to switch that back if desired.

This seems to be correct. Let me play with it 

For the last few months I decided not to ask this bc I thought it would be too complicated to do this in TC

Thank you! You are amazing 

Bruce I played with both PCF's one checking for price being above the mid of today's DR and C > C1

I am just curious why we need to check for price to be above the mid of today's DR bc if price is below the middle of its DR that means today's down volume is higher than today's up volume and that alone should eliminate the stock.

when I changed to C > C1 instead of mid-range I got stocks like FBR and TRCO checking true on 11/30

Both stocks closed below the mid of their DR on 11/30. 

for ex, FBR closed at the 41.46% of its DR so almost 59% of the volume of that day is counted as Down Vol and 41% as Up Vol

That alone should eliminate the stock unless the PCF is starting to check from yesterday?  

Having down volume greater than up volume would not automatically eliminate the stock unless specifically checked (as in checking for price being above the center of its DR).

Just checking for price being above its previous close will not check for more up volume than down volume for the current bar as that is determined by where price is relative to the total range from the close of the previous bar to the current price (including the high and low of the current bar).

Comparing the up volume to down volume of preivous bars will not check for more up volume than down volume for the current bar either. A high volume day with more down volume than up volume might still have more up volume than the up volume of the current bar. It is even possible that all of the previous bars in the comparison have more down volume than up volume.

It really is entirely up to you on how you want to calculate the formula since the new version isn't a pocket pivot formula. It is your invention and can follow whatever rules you want.