Support Board
Date/Time: Thu, 27 Feb 2025 12:41:51 +0000
Post From: Formula Help
[2021-06-30 12:04:03] |
Sawtooth - Posts: 4176 |
All of the formulas require that all of the lines change slope in the same bar. If some have already changed slope, and then one has changed slope, the formulas would look like this (after also removing the unnecessary ANDs and parentheses) : Down: =AND( ID3.SG1[0] < ID3.SG1[-1] , ID5.SG1[0] < ID5.SG1[-1] , ID2.SG1[0] < ID2.SG1[-1] , (ID2.SG1[-1] >= ID2.SG1[-2]) Up: =AND( ID3.SG1[0] > ID3.SG1[-1] , ID5.SG1[0] > ID5.SG1[-1] , ID2.SG1[0] > ID2.SG1[-1] , (ID2.SG1[-1] <= ID2.SG1[-2]) Down: =AND( ID5.SG1[0] < ID5.SG1[-1] , ID2.SG1[0] < ID2.SG1[-1] , ID2.SG1[-1] >= ID2.SG1[-2]) Up: =AND( ID5.SG1[0] > ID5.SG1[-1] , ID2.SG1[0] > ID2.SG1[-1] , ID2.SG1[-1] >= ID2.SG1[-2]) |