I am looking to include a MACD crossover as one of the criteria for a formula. In technicals, often times things happen, not exactly at the same time, but pretty close. So if X happens, the stage is set, then if Y happens - do Z. I tried to do a lookback idea, using references and or statements and that basically overran the other elements of my formula. So, my question is this: How do i write a formula that will look back n periods for one criteria. Ex. Stochastic reading above 80 within the past 5 trading sessions and a MACD sell cross on today's close. Thank you very much for any help provided.