Support Board
Date/Time: Thu, 02 Jan 2025 16:23:53 +0000
Post From: Crossover Exit not registering on spreadsheet nor chart
| [2024-10-23 01:41:14] |
| User522425 - Posts: 15 |
|
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? |