Support Board

Date/Time: Sat, 18 May 2024 05:25:06 +0000

Post From: How to combine two crossfromabove statements

[2019-08-30 21:57:10] Link To Thread - Link To Post [Go To First Post]
User116135 - Posts: 9
I'm trying to code a spreadsheet where I have the main chart and two indicators. The indicators are crossover indicators, let say the macd and stochastics. I have =CROSSFROMABOVE(AA3:AA6,AB3:AB6) currently as a sell entry for the macd and it works fine. I want to make the sell statement where it has to only fire off when it meets both conditions only. The other statement it has to meet is =CROSSFROMABOVE(AF3:AF6,AG3:AG6). Could you please show me how to combine them into one sell statement where they meet both conditions? Thanks in advance... p.s. Also need the statement to meet a condition where it will only fire off when price is under vwap which is another indicator and it's cell is AK3. Date Time Of Last Edit: 2019-08-30 22:30:51