Support Board
Date/Time: Sat, 30 Nov 2024 00:33:43 +0000
Post From: Formula to check if price has been above a level for X minutes.
| [2023-01-06 19:44:29] |
| ForgivingComputers.com - Posts: 960 |
|
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?
One approach would be a spreadsheet study and a formula that adds one to the previous value if the condition is true, and resets it to 0 if false. Assume: E3 = Last AS = ID1.SG1 New Formula 1 Price above AS: P3 =(E3>ID1.SG1@3)
New Formula 2 Count of Bars with Price Above AS: O3 =if(P3,O4+1,0)
New Formula 3 Buy Entry - If Count >= 8 and position is flat: K3 =AND(O3>=8,J$8=0)
|