Support Board
Date/Time: Tue, 04 Feb 2025 06:07:51 +0000
Post From: Spreadsheet: How to look back a certain number of bars
| [2020-01-01 13:40:47] |
| Sawtooth - Posts: 4166 |
|
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
|