Login Page - Create Account

Support Board


Date/Time: Sat, 05 Apr 2025 01:49:24 +0000



Post From: Calculating Price Change Since Last Alert

[2023-12-20 16:31:42]
John - SC Support - Posts: 39172
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