Support Board
Date/Time: Sat, 30 Nov 2024 00:41:45 +0000
Post From: Formula to check if price has been above a level for X minutes.
| [2022-12-12 11:43:49] |
| Dean Roberts - Posts: 79 |
|
Hi I'm trying to add a simple formula to go long if price has been above a level for x number of minutes... a simple pull back long basically. Would this work - with AS being the level I am trying to do the check for price being above for 8 minutes (if this was a minute chart)? AND(CROSSFROMABOVE(C3:C1000,AS3:AS1000), C3[-1]:C1000[-1]>AS3[-1]:AS1000[-1], C3[-2]:C1000[-2]>AS3[-2]:AS1000[-2], C3[-3]:C1000[-3]>AS3[-3]:AS1000[-3], C3[-4]:C1000[-4]>AS3[-4]:AS1000[-4], C3[-5]:C1000[-5]>AS3[-5]:AS1000[-5], C3[-6]:C1000[-6]>AS3[-6]:AS1000[-6], C3[-7]:C1000[-]>AS3[-7]:AS1000[-7], C3[-8]:C1000[-8]>AS3[-8]:AS1000[-8]) Is there a way of adding in a check to say price was a certain number of points above the level for that time period? Much appreciated Cad |