Support Board
Date/Time: Tue, 26 Nov 2024 06:29:54 +0000
Post From: Request for simple alert / bar coloring
| [2016-06-16 14:00:24] |
| Sawtooth - Posts: 4120 |
|
Try this: =AND(H[0]<MAX(H[-1],H[-2]),L[0]>MIN(L[-1],L[-2]),H[0]<H[-2],L[0]>L[-2]) Note that Simple Alert formulas identify the current day as [0], yesterday as [-1], and the day before yesterday as [-2]. The [0] can be omitted but I included it for clarification and example. MAX, MIN, and AND are spreadsheet functions that also work in Simple Alerts. Their inputs/conditions are between open and close parenthesis, and separated by commas. So if you examine the formula: The MAX function has 2 inputs, each separated by a comma: H[-1],H[-2] The MIN function has 2 inputs, each separated by a comma: L[-1],L[-2] The AND function has 4 conditions using the comparison operators > < with each condition separated by commas: H[0]<MAX(H[-1],H[-2]) L[0]>MIN(L[-1],L[-2]) H[0]<H[-2] L[0]>L[-2] |