Login Page - Create Account

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:

Login

Login Page - Create Account