Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 Williams Awesome Oscillator (AO) Topic Rating:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
Bruce_L
 Posted : Friday, March 17, 2017 1:15:14 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

# Williams Awesome Oscillator (AO)

## Templates (v17+)

### Main Indicator

``(AVG(H + L, 5) - AVG(H + L, 34)) / 2``

### Plot Only Down Bars

``(AVGH5 + AVGL5 - AVGH34 - AVGL34) / 2 / ABS(AVG(H + L, 5) - AVG(H + L, 34)` < (AVG(H1 + L1, 5) - AVG(H1 + L1, 34)))`

## Related Topics

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Sunday, November 18, 2018 4:26:27 PM
Registered User
Joined: 4/30/2015
Posts: 197

i assume the plot only down bars and another plot only up bars you could create a 2 color histogram?

I tried the formula and got an error cannot divide by zero

Bruce_L
 Posted : Monday, November 19, 2018 8:20:27 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You would plot the main indicator as a Custom PCF Indicator using the Histogram Plot Style in your up color. Then you would use the Plot Only Down Bars formula using a Custom PCF Indicator using the Histogram Plot Style in your down color.

The division by zero error is deliberate. This is what causes the down bars version to not plot when the indicator is up.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Monday, November 26, 2018 5:58:50 AM
Registered User
Joined: 9/30/2011
Posts: 788
I would like to change the following formula to get the Up signal instead of numbers.

(AVG (H + L, 5) - AVG (H + L, 34)) / 2

Thank you and goodbye.
Raider45
Bruce_L
 Posted : Monday, November 26, 2018 9:29:37 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If you mean the value is above zero:

`AVG(H + L, 5) > AVG(H + L, 34)`

If you mean the value is crossing above zero:

`XUP(AVG (H + L, 5), AVG(H + L, 34))`

If you mean the value is going up:

`AVG(H + L - H1 - L1, 5) > AVG(H + L - H1 - L1, 34)`

If you mean the value has started going up while below zero:

`AVG(H1 + L1, 5) < AVG(H1 + L1, 34) AND TrueInRow(AVG(H + L - H1 - L1, 5) > AVG(H + L - H1 - L1, 34), 2) = 1`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Tuesday, November 27, 2018 6:34:20 AM
Registered User
Joined: 9/30/2011
Posts: 788
Congratulations, thank you!

Sincerely
Bruce_L
 Posted : Tuesday, November 27, 2018 8:23:56 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
check9255
 Posted : Saturday, December 1, 2018 10:37:01 AM
Gold Customer

Joined: 4/19/2012
Posts: 7

HI BRUCE/ PCF FOR PRICE CLOSES ABOVE 15 DAY MOVING AVG, I AM HAVING ALL KINDS OF TROUBLE=(FIX FORMULA) MOSTLY PARENTHES

THANKS

StockGuy
 Posted : Saturday, December 1, 2018 10:44:10 AM