Support Board
Date/Time: Wed, 27 Nov 2024 19:29:35 +0000
build a formula for triger an alert
View Count: 255
| [2023-07-17 12:36:19] |
| User278398 - Posts: 291 |
|
hello, i want to triger an alert if a value that i get from other formula (id1.sg1) with "spreadsheet formula" study (for example, ask volume) is 100% more higher then the last value i got. for example: if i got the value 44468: (pic 1) at 9:39:56 and i got the value: 111105 (pic 2) at 9:39:57 (which is 100% more then 44468) so i want the Triger will happen (at 9:39:57). what is the formula i need to build? regards. Date Time Of Last Edit: 2023-07-17 12:38:12
|
1.png| [2023-07-17 19:26:48] |
| John - SC Support - Posts: 36341 |
|
Are these two values in different bars? In other words, is the formula you want the following when using 1 second bars: - When the current bar has a value that is twice as large as the previous bar The formula for this would be: =ID1.SG1 > 2 * ID1.SG1[-1] Or is this Intrabar, the value is one thing then changes to another within a single bar? There is not a way to do this using the Sierra Chart tools. You would have create a custom study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-07-18 14:44:52] |
| User278398 - Posts: 291 |
|
i got this data from 1 min chart and i display it in other chart (1 second chart)... /// u sent me a formula which connect to every bar. there is formula which connect to time? this can work? regards |
| [2023-07-18 17:01:30] |
| John - SC Support - Posts: 36341 |
|
In order to create an alert using Time, you would have to use the "Spreadsheet System/Alert". Refer to the following: Spreadsheet Systems, Alerts and Automated Trading And refer to the following as well as the other functions (specifically time-related functions) on this page: Spreadsheet Functions: Serial DateTime Values For the most reliable, advanced, and zero cost futures order routing, use 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: