Support Board
Date/Time: Mon, 11 Nov 2024 06:29:10 +0000
[Programming Help] - Crossover Exit not registering on spreadsheet nor chart
View Count: 114
[2024-10-23 01:41:14] |
User522425 - Posts: 12 |
Hi, I have an "OR" function in Buy Exit and Sell Exit cells on the spreadsheet. This OR function has as one of its arguments, "D3<AC3" where D3 is the current bar low, and AC3 is the current value of a moving average of a certain length. That is in Buy Exit. In Sell Exit, I have "C3>AC3" where C3 is the current bar high, and AC3 is the current value of a moving average of a certain length. Looking to see why when the low for the current bar is below the current value for the moving average, the spreadsheet does not display a "1" in buy exit column L, nor is the chart showing the open position as closed. Same for when the high is above the moving average, for column N. Buy Exit: =OR(AND(AC3<S3, S3>0, E3<AC3), AND(S3="", E3<AC3),AND(AC3>S3, S3>0, E3<S3),AND((E4+1.25*(E4-S4))<E3),(D3<AC3)) Sell Exit: =OR(AND(AC3>T3, T3>0, E3>AC3), AND(T3="", E3>AC3),AND(AC3<T3, T3>0, E3>T3),AND((T4-(1.25*(T4-E4)))>E3),(C3>AC3)) What needs to change for the last part (D3<AC3) or (C3>AC3) to have an effect in this formula? |
[2024-10-24 14:53:35] |
User522425 - Posts: 12 |
hey it's been more than 24 hours, should we post this in the main forum?
|
[2024-10-24 15:48:20] |
Sawtooth - Posts: 4114 |
If you put =D3<AC3 in a spare Formula column, does it display '1' when true? If you put =C3>AC3 in a spare Formula column, does it display '1' when true? |
[2024-10-28 19:32:56] |
User522425 - Posts: 12 |
Hello! I put the formulas in columns "U" and "V" on the spreadsheet. At 1:05 PM Eastern Standard Time, on the 5-minute candle chart, there is a sell entry at 1:00 PM Eastern Standard Time that should have resulted in a sell exit at 1:05 PM Eastern Standard Time when the high of the candle at 1:05 Eastern Standard Time registered above the 8 period moving average from cell column AC. In column V, where the formula "=C3>AC3" resides, there is a "1" clearly displayed. However, on the sell exit column "N" there is not a 1 displayed. I am typing this now, at 3:30 PM Eastern Standard Time, looking at the chart, and the entries I'm talking about appear in rows 33 and 32 respectively for 1:00 PM and 1:05 PM. I also set the condition "C3>AC3" in the sell exit formula as "V3=1" instead, and it still doesn't show a "1" in column N for that cell where in column V it does show. This doesn't always happen this way. But, this is the first instance that I've seen that it has happened. At other times, when V column says "1", so does column N say 1 as well. Everything else is the same. ^^ to clarify what I just wrote, this is on the security named "6EZ24". Date Time Of Last Edit: 2024-10-29 16:43:08
|
[2024-10-30 00:01:30] |
Sawtooth - Posts: 4114 |
Direct Message me please.
|
[2024-10-31 10:59:30] |
User522425 - Posts: 12 |
@Sawtooth I sent you a message request on Sierra Chart. Please confirm you've received it. Thank you. |
To post a message in this thread, you need to log in with your Sierra Chart account: