Support Board
Date/Time: Wed, 12 Feb 2025 08:43:33 +0000
Post From: How to look back x number of bars
| [2020-10-12 02:59:35] |
| Sawtooth - Posts: 4173 |
|
if I want to get the value of ID1.SG1 from the number of bars back based on the current value of ID2.SG1 I'd logically do it like this: ID1.SG1[-ID2.SG1]. This produces a syntax error. How do I achieve this?
What you want to do is not supported in Simple Alerts. You would need to use one of the 3 spreadsheet studies, with a formula like this in row 3 of a Formula Column (K-Z):=OFFSET(ID1.SG1@3,ID2.SG1@3,0) |