Support Board
Date/Time: Mon, 13 Jan 2025 02:46:53 +0000
[User Discussion] - Formula - Reference previous # of bars
View Count: 1632
| [2017-03-24 01:51:29] |
| User104854 - Posts: 457 |
|
Is there a simple way that I can use a formula where, for instance, I'd like the low of the current bar to be lower than all of the previous 10 bars?
|
| [2017-03-27 14:45:32] |
| User104854 - Posts: 457 |
|
Hi. I didn't get a response on this. Is this possible or do I have to reference each individual bar? Again I want the alert to trigger when the current bar low is lower than the previous 10 bar lows. Thanks.
|
| [2017-03-27 16:54:50] |
| mkata - Posts: 103 |
|
You could use the Highest/Lowest over N-Bars study set to length of 10 to show when the low breaks lower.
|
| [2017-03-27 16:57:06] |
| Sawtooth - Posts: 4149 |
|
You'll have to reference each individual bar because you cannot reference a range in Simple Alerts formulas. For example, this formula L<MIN(L[-1]:L[-10]) returns the same as L<MIN(L[-1],L[-10]) So use this: =AND(L<L[-1],L<L[-2],L<L[-3],L<L[-4],L<L[-5],L<L[-6],L<L[-7],L<L[-8],L<L[-9],L<L[-10]) |
| [2017-03-27 17:23:52] |
| User104854 - Posts: 457 |
|
Great! That helps. Thank you for the responses on this.
|
| [2017-03-27 19:08:53] |
| |
|
With simple alert formulas there is not the ability currently to specify data from multiple bars as a single range. Each bar needs to be specified individually.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: