I am looking to create two conditions:

First one has 3 criteria - Bullish:

1. Stochastic %D(14,3) > 50

2. RSI(7) > 50

3. MACD > Zero Line > Signal Line (9 period) 

This is what I have so far, but seems to be missing something on the MACD > Signal Line

(RSI7>50) And (((XAVGC12-XAVGC26)>0) And ((XAVGC12-XAVGC26)-(XAVG(XAVGC12,9)-XAVG(XAVGC26,9)))>0) AND (AVG(STOC14.3,3) > 50)

Second one has 3 criteria - Bearish:

1. Stochastic %D(14,3) < 50

2. RSI(7) < 50

3. MACD < Zero Line < Signal Line (9 period)

Assuming your RSI is the plain RSI indicator and not the RSI - Wilder's indicator, the stochastic is simple, the MACD is exponential and you want the MACD above the zero line and its signal line and not that you want the signal line below zero, I don't see any problems with your formulas as written. It seems to work correctly on my computer.

Can you provide specific examples where it doesn't seem to be working for you?

UVXY today - seems to meet all the criteria, but is returning false.

Thanks for your help.

The plain RSI7 is above 50.

The simple stochastic 14,3 %K is above 50.

The exponential MACD 12,26 is above its 9-period signal line.

But the exponential MACD 12,26 is below 0.

Got it, thanks.

You're welcome.