Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 02:28:42 +0000



Post From: Calculating Price Change Since Last Alert

[2023-12-20 16:31:42]
John - SC Support - Posts: 36286
It is not possible to do this using just the alerts. You would have to use the Spreadsheet Study to do this and either recreate your Alert condition in the spreadsheet or, if you are using the "Color Bar Based on Alert Condition", then you can reference the "Color Bar" subgraph for that study which will be a particular value when true (depending on how you setup the study).

You can then use the "GETCORRESPONDINGMATCH()" along with the "ROW()" function to get the row number where the most recent value was true, then you can use that to determine the time you want. Note that you would nest these two functions like the following to get the Row number:
=ROW(GETCORRESPONDINGMATCH())

You need to put in the correct parameters for the GETCORRESPONDINGMATCH function.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing