Support Board
Date/Time: Sun, 26 Oct 2025 09:46:49 +0000
Post From: Spreadsheet: How to look back a certain number of bars
| [2020-01-01 13:40:47] |
| Sawtooth - Posts: 4278 |
|
Try this: =C3>MAX(C4:C7) This compares the current High to the max of 4 previous Highs. This also works: =C3>MAX(C4:OFFSET(C3,4,0)) You can reference cell H2 as a user parameter, instead of modifying the formula: =C3>MAX(C4:OFFSET(C3,$H$2,0)) where H2 = 4 Date Time Of Last Edit: 2020-01-07 00:57:59
|