I am attempting to set up a scan condition that identifies when the PPO Histogram turns from negative to positive. After many attempts, I am unable to get the scan to recognize when the aforementioned conditon occurs. How do I set up this scan? Thanks!

Charles

I am also unable to get correct results from a Condition created by clicking on the PPO Histogram and selecting Create Scan Condition to identify symbols where the PPO Histogram is crossing up through zero. Thank you for reporting the issue. It has been assigned case number 8894.

It is possible to create Condition Formulas for this as a workaround, but they can be quite complex. If you are using an Exponential PPO Histogram 12,26,9, a Condition Formula for this could be written as:

XAVGC12 / XAVGC26 - .200198266760174 * (XAVGC12 / XAVGC26 + .8 * (XAVGC12.1 / XAVGC26.1 + .8 * (XAVGC12.2 / XAVGC26.2 + .8 * (XAVGC12.3 / XAVGC26.3 + .8 * (XAVGC12.4 / XAVGC26.4 + .8 * (XAVGC12.5 / XAVGC26.5 + .8 * (XAVGC12.6 / XAVGC26.6 + .8 * (XAVGC12.7 / XAVGC26.7 + .8 * (XAVGC12.8 / XAVGC26.8 + .8 * (XAVGC12.9 / XAVGC26.9 + .8 * (XAVGC12.10 / XAVGC26.10 + .8 * (XAVGC12.11 / XAVGC26.11 + .8 * (XAVGC12.12 / XAVGC26.12 + .8 * (XAVGC12.13 / XAVGC26.13 + .8 * (XAVGC12.14 / XAVGC26.14 + .8 * (XAVGC12.15 / XAVGC26.15 + .8 * (XAVGC12.16 / XAVGC26.16 + .8 * (XAVGC12.17 / XAVGC26.17 + .8 * (XAVGC12.18 / XAVGC26.18 + .8 * (XAVGC12.19 / XAVGC26.19 + .8 * (XAVGC12.20 / XAVGC26.20 + .8 * (XAVGC12.21 / XAVGC26.21 + .8 * (XAVGC12.22 / XAVGC26.22 + .8 * (XAVGC12.23 / XAVGC26.23 + .8 * (XAVGC12.24 / XAVGC26.24 + .8 * (XAVGC12.25 / XAVGC26.25 + .8 * (XAVGC12.26 / XAVGC26.26 + .8 * (XAVGC12.27 / XAVGC26.27 + .8 * (XAVGC12.28 / XAVGC26.28 + .8 * (XAVGC12.29 / XAVGC26.29 + .8 * (XAVGC12.30 / XAVGC26.30))))))))))))))))))))))))))))))) > 0 AND XAVGC12.1 / XAVGC26.1 - .200198266760174 * (XAVGC12.1 / XAVGC26.1 + .8 * (XAVGC12.2 / XAVGC26.2 + .8 * (XAVGC12.3 / XAVGC26.3 + .8 * (XAVGC12.4 / XAVGC26.4 + .8 * (XAVGC12.5 / XAVGC26.5 + .8 * (XAVGC12.6 / XAVGC26.6 + .8 * (XAVGC12.7 / XAVGC26.7 + .8 * (XAVGC12.8 / XAVGC26.8 + .8 * (XAVGC12.9 / XAVGC26.9 + .8 * (XAVGC12.10 / XAVGC26.10 + .8 * (XAVGC12.11 / XAVGC26.11 + .8 * (XAVGC12.12 / XAVGC26.12 + .8 * (XAVGC12.13 / XAVGC26.13 + .8 * (XAVGC12.14 / XAVGC26.14 + .8 * (XAVGC12.15 / XAVGC26.15 + .8 * (XAVGC12.16 / XAVGC26.16 + .8 * (XAVGC12.17 / XAVGC26.17 + .8 * (XAVGC12.18 / XAVGC26.18 + .8 * (XAVGC12.19 / XAVGC26.19 + .8 * (XAVGC12.20 / XAVGC26.20 + .8 * (XAVGC12.21 / XAVGC26.21 + .8 * (XAVGC12.22 / XAVGC26.22 + .8 * (XAVGC12.23 / XAVGC26.23 + .8 * (XAVGC12.24 / XAVGC26.24 + .8 * (XAVGC12.25 / XAVGC26.25 + .8 * (XAVGC12.26 / XAVGC26.26 + .8 * (XAVGC12.27 / XAVGC26.27 + .8 * (XAVGC12.28 / XAVGC26.28 + .8 * (XAVGC12.29 / XAVGC26.29 + .8 * (XAVGC12.30 / XAVGC26.30 + .8 * (XAVGC12.31 / XAVGC26.31))))))))))))))))))))))))))))))) <= 0

Bruce, re your post of 10-4-2012 on PPO Histogram; I wanted to do a PCF to simply determine whether it was above or below zero, for a scan. In testing your PCF from the post as an indicator, without the greater than operator, the top portion, for the current day/period, the result showed as zero. By multiplying that part of the PCF by 100, as the PPO formula reaquires, the PCF gives the value presented on the chart. I was thinking that might be the source of the case #8894 problem, too many decimals.

Now my question, the second part of my scan involved the coincidence of PPO histogram 8-12-7 also being < 0. If the above doesn't help with the Indicator condition problem, could you post the formula for histogram 8-12-7.

You do amazing things with your math and these formulas. Thanks for your help!

The formula doesn't multiply the results by 100 because the magnitude of the result is irrelevant in determining if the result is above or below zero, so there is no reason to add unnecessary computational complexity that will just slow down the formula.

The formula has absolutely nothing to do with case number 8894 other than be offered as a workaround for the bug.

An Indicator Formula for the PPO Histogram 8,12,7 could be written as:

100 * (XAVGC8 / XAVGC12 - .2501883 * (XAVGC8 / XAVGC12 + .75 * (XAVGC8.1 / XAVGC12.1 + .75 * (XAVGC8.2 / XAVGC12.2 + .75 * (XAVGC8.3 / XAVGC12.3 + .75 * (XAVGC8.4 / XAVGC12.4 + .75 * (XAVGC8.5 / XAVGC12.5 + .75 * (XAVGC8.6 / XAVGC12.6 + .75 * (XAVGC8.7 / XAVGC12.7 + .75 * (XAVGC8.8 / XAVGC12.8 + .75 * (XAVGC8.9 / XAVGC12.9 + .75 * (XAVGC8.10 / XAVGC12.10 + .75 * (XAVGC8.11 / XAVGC12.11 + .75 * (XAVGC8.12 / XAVGC12.12 + .75 * (XAVGC8.13 / XAVGC12.13 + .75 * (XAVGC8.14 / XAVGC12.14 + .75 * (XAVGC8.15 / XAVGC12.15 + .75 * (XAVGC8.16 / XAVGC12.16 + .75 * (XAVGC8.17 / XAVGC12.17 + .75 * (XAVGC8.18 / XAVGC12.18 + .75 * (XAVGC8.19 / XAVGC12.19 + .75 * (XAVGC8.20 / XAVGC12.20 + .75 * (XAVGC8.21 / XAVGC12.21 + .75 * (XAVGC8.22 / XAVGC12.22 + .75 * (XAVGC8.23 / XAVGC12.23 + .75 * (XAVGC8.24 / XAVGC12.24))))))))))))))))))))))))))

I have created a weekly chart in TC2000 v.12 that includes the PPO histogram with the default settings (12,26,9).  I clicked on "PPO Histogram/Show Values in Watchlist." This does create a column of values in the watchlist, but the values in the watchlist are not that same as shown on the chart. For example, the weekly value of the PPO Histogram for ARMH is -2.78 on the chart but +3.33 in the watchlist.  The chart and watchlist values are not equal for every stock in the watchlist.  Thanks for your help.

Just to update my comment above, the weekly macd histogram values appear to be the same on the chart as in the watchlist.  But the values for weekly PPO histogram on the chart and in the watchlist appear to be completely unrelated.  What is causing this, and how can I get the PPO histogram values to be the same on the chart and in the watchlist? Thanks.

That PPO Histogram based values and conditions cannot be correctly displayed as WatchList Columns by clicking on the PPO Histogram is a known issue. This bug is mentioned in the posts above and the formulas provided in this topic are designed as workarounds to this issue.

You could create an Custom PCF Indicator on a Weekly Chart using the following Indicator Formula as the Formula (you could also just create an Indicator Formula) to replicate a PPO Histogram 12,26,9. Unlike the PPO Histogram indicator, you should be able to click on it and select Show Values in WatchList and get the correct results.

100 * (XAVGC12 / XAVGC26 - .2001983 * (XAVGC12 / XAVGC26 + .8 * (XAVGC12.1 / XAVGC26.1 + .8 * (XAVGC12.2 / XAVGC26.2 + .8 * (XAVGC12.3 / XAVGC26.3 + .8 * (XAVGC12.4 / XAVGC26.4 + .8 * (XAVGC12.5 / XAVGC26.5 + .8 * (XAVGC12.6 / XAVGC26.6 + .8 * (XAVGC12.7 / XAVGC26.7 + .8 * (XAVGC12.8 / XAVGC26.8 + .8 * (XAVGC12.9 / XAVGC26.9 + .8 * (XAVGC12.10 / XAVGC26.10 + .8 * (XAVGC12.11 / XAVGC26.11 + .8 * (XAVGC12.12 / XAVGC26.12 + .8 * (XAVGC12.13 / XAVGC26.13 + .8 * (XAVGC12.14 / XAVGC26.14 + .8 * (XAVGC12.15 / XAVGC26.15 + .8 * (XAVGC12.16 / XAVGC26.16 + .8 * (XAVGC12.17 / XAVGC26.17 + .8 * (XAVGC12.18 / XAVGC26.18 + .8 * (XAVGC12.19 / XAVGC26.19 + .8 * (XAVGC12.20 / XAVGC26.20 + .8 * (XAVGC12.21 / XAVGC26.21 + .8 * (XAVGC12.22 / XAVGC26.22 + .8 * (XAVGC12.23 / XAVGC26.23 + .8 * (XAVGC12.24 / XAVGC26.24 + .8 * (XAVGC12.25 / XAVGC26.25 + .8 * (XAVGC12.26 / XAVGC26.26 + .8 * (XAVGC12.27 / XAVGC26.27 + .8 * (XAVGC12.28 / XAVGC26.28 + .8 * (XAVGC12.29 / XAVGC26.29 + .8 * (XAVGC12.30 / XAVGC26.30))))))))))))))))))))))))))))))))

Bruce,

I came across this thread when I found that Case 8894 appears to remain open.

Can you help with the daily histogram is going negative from positive?

Thanks,

Dan

What are the exact and complete settings of the PPO Histogram in question?

 12-26-9, Exponential, Daily.  Is this what you are looking for?

- Select Add Indicator and choose Custom PCF Indicator from the list.
- Click on the Custom PCF Indicator and select Edit to setup the Custom PCF Indicator as follows:
-- Plot Style: Histogram
-- Period: 1
-- Formula: 100 * (XAVGC12 / XAVGC26 - .2001983 * (XAVGC12 / XAVGC26 + .8 * (XAVGC12.1 / XAVGC26.1 + .8 * (XAVGC12.2 / XAVGC26.2 + .8 * (XAVGC12.3 / XAVGC26.3 + .8 * (XAVGC12.4 / XAVGC26.4 + .8 * (XAVGC12.5 / XAVGC26.5 + .8 * (XAVGC12.6 / XAVGC26.6 + .8 * (XAVGC12.7 / XAVGC26.7 + .8 * (XAVGC12.8 / XAVGC26.8 + .8 * (XAVGC12.9 / XAVGC26.9 + .8 * (XAVGC12.10 / XAVGC26.10 + .8 * (XAVGC12.11 / XAVGC26.11 + .8 * (XAVGC12.12 / XAVGC26.12 + .8 * (XAVGC12.13 / XAVGC26.13 + .8 * (XAVGC12.14 / XAVGC26.14 + .8 * (XAVGC12.15 / XAVGC26.15 + .8 * (XAVGC12.16 / XAVGC26.16 + .8 * (XAVGC12.17 / XAVGC26.17 + .8 * (XAVGC12.18 / XAVGC26.18 + .8 * (XAVGC12.19 / XAVGC26.19 + .8 * (XAVGC12.20 / XAVGC26.20 + .8 * (XAVGC12.21 / XAVGC26.21 + .8 * (XAVGC12.22 / XAVGC26.22 + .8 * (XAVGC12.23 / XAVGC26.23 + .8 * (XAVGC12.24 / XAVGC26.24 + .8 * (XAVGC12.25 / XAVGC26.25 + .8 * (XAVGC12.26 / XAVGC26.26 + .8 * (XAVGC12.27 / XAVGC26.27 + .8 * (XAVGC12.28 / XAVGC26.28 + .8 * (XAVGC12.29 / XAVGC26.29 + .8 * (XAVGC12.30 / XAVGC26.30))))))))))))))))))))))))))))))))

Any other settings are up to you.

Adding and Moving Indicators

You can then click on the Custom PCF Indicator and select Create Scan Condition to create a Condition for the Custom PCF Indicator crossing up through 0.

Create Conditions from Your Chart