Bruce, you provided me with the following PCF % True below.

Bullish Pressure:

H - GREATEST(O, C) < LEAST(O, C) - L

Bearish Pressure:

H - GREATEST(O, C) > LEAST(O, C) - L

Could you please change these to indicate percentages based on the comparative length of the lower and upper wicks?

Maybe something like the following with the percentage based on just the wick with Bullish Pressure being positive and Bearish Pressure being negative?

IIF(H - L = ABS(O - C), 0, 200 * (LEAST(O, C) - L) / (H - L - ABS(O - C)) - 100)

Or the following with the percentage based on the entire candle with Bullish Pressure still being positive and Bearish Pressure still being negative?

IIF(H = L, 0, 100 * (LEAST(O, C) - L - H + GREATEST(O, C)) / (H - L))

Both formulas run from -100 to 100. The magnitude (absolute value) of the second formula should always be less than or equal to the magnitude of the first formula. The values should only match if there is either a doji or no wicks.

I tested the above PCF the last daily candlesticks for SPY (on 9/27/17 before Open today) which gave a positive value of 39.73%.

I contrasted this with two Custom PCF Indicators from a previous request from some time ago as shown below:

Lower Wick %:

100 * ((O + C - ABS(O - C)) / 2 - L) / (H - L + .00001)

Upper Wick %:

100 * (H - (O + C + ABS(O - C)) / 2) / (H - L + .00001)

For SPY on 9/27//17 its' Lower Wick % balue was 62.96, and the Upper Wick % balue was 27.16. 

Thus, SPY'S Lower Wick was taller than its' Upper Wick which is what the 9/27/17 candlestick looks like.

Thus, I would expect a high value as a positive bullish indicator (perhaps 60.27%).

Can you please tweek this PCF, Bruce?

I am referring to your first PCF above:  This one:

IIF(H - L = ABS(O - C), 0, 200 * (LEAST(O, C) - L) / (H - L - ABS(O - C)) - 100)

which was the only one I tested.

Your second PCF is below:

Or the following with the percentage based on the entire candle with Bullish Pressure still being positive and Bearish Pressure still being negative?

IIF(H = L, 0, 100 * (LEAST(O, C) - L - H + GREATEST(O, C)) / (H - L))

Result: I just tested this one which resulted in a value of 35.80 for SPY, again for 9/27/17.

I have changed Lower Wick % and Upper Wick % to 1-Ago as below:

Lower:

100 * ((O1+ C1 - ABS(O1 - C1)) / 2 - L1) / (H1 - L1 + .00001)

Upper:

100 * (H1 - (O1 + C1 + ABS(O1 - C1)) / 2) / (H1 - L1 + .00001)

Most importantly, I have changed your first PCF to 1-Ago and must ask if this is correct for 1-Ago?

IIF(H1 - L1 = ABS(O1 - C1), 0, 200 * (LEAST(O1, C1) - L1) / (H1 - L1 - ABS(O1 - C1)) - 100)

The two symbols coming resulting from my Easy Scan are PBF and INT.  The chart is set to Daily.

The values resulting from your first PCF with Bullish Pressure being Positive and Bearish Pressure being Negative appear now to be accurate.

PBF is 61.36

INT is 75.00

Both at the current time of 9:44 am EST.

Just now changed from Manual to 1 minute Refresh Rate for 1-Ago PCF and at 9:48 results are as follows:

QCO is 67.71

PBF is 61.26

Notice one symbol has changed.

It's difficult to tell whether these results are accurate by focusing on the size of each of the wicks.

But, I assume they are if the changes I made to your original formula are correct.

See below:

Most importantly, I have changed your first PCF to 1-Ago and must ask if this is correct for 1-Ago?

IIF(H1 - L1 = ABS(O1 - C1), 0, 200 * (LEAST(O1, C1) - L1) / (H1 - L1 - ABS(O1 - C1)) - 100)

Your 1 bar ago conversions appear to be correct.

For SPY on Wednesday September 27, 2017 on a daily chart.

After further testing, I believe we need to look back at these formulas from September 11, 2017:

Bullish Pressure:

H - GREATEST(O, C) < LEAST(O, C) - L

Bearish Pressure:

H - GREATEST(O, C) > LEAST(O, C) - L

To further test, I have changed these to the following:

1-Ago Bullish Pressure:

H1 - GREATEST(O1, C1) < LEAST(O1, C1) - L1

1-Ago Bearish Pressure:

H1 - LEAST(O1, C1) - L1 < H 1- GREATEST(O1, C1)

I am testing five symbols from my Easy Scan.  They are (in alphabetical order) CARA, LXRX, MULE, PBF, and REGN.

The first tests 1-Ago Bearish Pressure and the other four test both 1-Ago Bullish and 1-Ago Bearish Pressure.

In particular, yesterday's PBF does not look like a Spinning Top, but has a long lower wick.  It should not indicate 1-Ago Bullish Pressure.

Bruce, perhaps should 1-Ago Bearish Pressure start with L1 (instead of H1)?

In particular, yesterday's MULE candlestick does look like a Spinning Top, so one might expect that both the 1-Ago Bullish Pressure as well as the 1-Ago Bearish Pressure would both indicates checks for True.

Your 1-Ago Bullish Pressure formula looks correct, but your 1-Ago Bearish Pressure formula should be the following.

H1 - GREATEST(O1, C1) > LEAST(O1, C1) - L1

Yes, indeed.  Thanks so much.

You're welcome.