Support Board

Date/Time: Sat, 18 May 2024 11:36:57 +0000

Post From: SPREADSHEET FORMULA HELP

[2020-02-22 20:28:00] Link To Thread - Link To Post [Go To First Post]
User597941 - Posts: 6
I am new to spreadsheets and am trying to make a buy entry that occurs after price opens with a green bar, makes a high, then makes a low that does not extend below the opening price, then buys at the break of the high. What I have so far is: =AND(ABS($J$8)=0,AA3>0,AB3>0,T3=1) POSITION QUANTITY GREATER THAN 0, SWING HIGH TRUE (indicator in AA3), SWING LOW TRUE (indicator in AB3), CANDLE IS GREEN (formula in T3) This obviously won't work as it says all conditions must apply at the same time for a buy. How would I say "if opening candle is green and there is a swing high, followed by a swing low that doesn't break below the open price, then buy break of the swing high"? Also, how would I cancel the setup if price does extend below the low of the opening candle? Any help would be appreciated!