Support Board
Date/Time: Wed, 05 Nov 2025 08:34:48 +0000
Post From: Spreadsheet: How to look back a certain number of bars
| [2020-01-01 12:20:25] |
| tommartin321 - Posts: 77 |
|
Hello, I'm working on a Spreadsheet autotrading system and need to be able to "look back" five bars. For example, on an uptrend, I want the high of the current bar to be the highest high in the past five bars. So, the current Up bar would get a certain negative Dela number, indicating a possible reversal, but I want the high of the current bar to be the high the last five bars. I'm clear on the formula for the delta and current bar high. I just don't know how to then look back on the last five bars. Thank you, Tom |