Support Board
Date/Time: Wed, 12 Mar 2025 21:12:33 +0000
[Programming Help] - Spreadsheet Formula Help
View Count: 497
| [2022-05-27 05:19:32] |
| RedSkull - Posts: 6 |
|
I am in need of some help in creating a certain formula. I need to be able to say that prior to the current candle I am in, there needs to be at least one Bullish or Bearish candle ,depending on if it's a long or short trade scenario. So another way to say this would be that I need to be in at least my second bullish or bearish candle in a row before I can take a trade. I need to know how I could represent this as a formula. It will be placed within a larger formula just FYI. Hopefully that's not too confusing. Any help is appreciated. Thanks Chris Date Time Of Last Edit: 2022-05-27 05:20:36
|
| [2022-05-27 12:47:40] |
| Sawtooth - Posts: 4182 |
|
Simple Alert syntax: Two bullish candles in succession: =AND(C[-1]>O[-1],C>O) Two bearish candles in succession: =AND(C[-1]<O[-1],C<O) Study/Chart Alerts And Scanning Spreadsheet syntax: Two bullish candles in succession: =AND(E4>B4,E3>B3) Two bearish candles in succession: =AND(E4<B4,E3<B3) Date Time Of Last Edit: 2022-05-27 13:06:31
|
To post a message in this thread, you need to log in with your Sierra Chart account: