Registered User Joined: 10/7/2004 Posts: 38

Bruce, I have this formula for a Rising Stochastic Cross Indicator (Stochastic 10.4.4) and it should present a Green Dot on my price chart. However, I don't get the Green Dot. Can you tell me what I'm doing wrong? (v18.0.6626.29703)
iif (stoc10.4.1 < avg(stoc10.4.1,4) and stoc10.4 > avg(stoc10.4,4) and stoc10.4<75, .995 * min(1, 5),0)
Here's the video tutorial that I followed to get the formula:
http://www.cesar.umd.edu/h348m/Videos/RisingStochCrossIndicator.mov
Preston

Worden Trainer
Joined: 10/7/2004 Posts: 65,002

There are a couple issues with the formula as posted. There is a space between IIF and the opening parenthesis. You seem to have the number 1 instead of the letter L as the first argument in your MIN() function.
I would probably write the formula as follows to shorten things up a bit and make it so you don't get a row of dots at zero.
IIF(XUP(STOC10.4, AVG(STOC10.4, 4)) AND STOC10.4 < 75, .995 * MINL5, 1 / 0)
Make sure you are choosing & Scale With when overlaying the Custom PCF Indicator into the price pane and that the Plot Style is set to Dots.
Bruce Personal Criteria Formulas TC2000 Support Articles

Gold Customer
Joined: 10/19/2006 Posts: 2

Good morning, I have a question about the green dots formual.
If I use formulal 1. IIF(XUP(STOC10.4, AVG(STOC10.4, 4)) AND STOC10.4 < 75, .995 * MINL5, 1 / 0)
the test formula icon gave and error message  Divided by 0
If I used the modified formula 2. IIF(XUP(STOC10.4, AVG(STOC10.4, 4)) AND STOC10.4 < 75, .995 * MINL(5, 1), 0)
Test formula gave value = to 0.00
The second formula also produced green dots at every price point with the "Dots" plot style selection, not only at the crossover price point as desired. At the crossover the dot was an inch or so above the price point on the chart and at the bottom of the chart at all other prices.
How can I change the formula to only generate the green dots at the crossover price, just below the price on the chart?
Thank you,
Joe

Worden Trainer
Joined: 10/7/2004 Posts: 65,002

The error message is deliberate and is what makes it so you don't get dots at every point. So you should be abel to use the first formula. Make sure it is scaled in the same scale as price.
Bruce Personal Criteria Formulas TC2000 Support Articles
