Support Board
Date/Time: Fri, 31 Oct 2025 22:14:52 +0000
[User Discussion] - Can Someone Please Point me
View Count: 1219
| [2014-11-16 19:16:05] |
| apollofl - Posts: 95 |
|
in the right direction. Trying to accomplish the following: A crossover occurred within the last 5 bars and now the Stochastic is above or below 50 using spreadsheet. Thanks in Advance |
| [2014-11-16 21:24:35] |
| Sawtooth - Posts: 4281 |
|
Something like this seems to work: =AND(AF3>50,AF4<50,OR(CROSSOVER(AB3:AB4,AC3:AC4),CROSSOVER(AB4:AB5,AC4:AC5),CROSSOVER(AB5:AB6,AC5:AC6),CROSSOVER(AB6:AB7,AC6:AC7),CROSSOVER(AB7:AB8,AC7:AC8))) where the Stochastic is AF and the MAs are AB and AC. |
| [2014-11-17 15:26:04] |
| apollofl - Posts: 95 |
|
Tom as Always, thanks for your help.
|
To post a message in this thread, you need to log in with your Sierra Chart account: