Support Board
Date/Time: Sun, 02 Nov 2025 17:08:16 +0000
Post From: Alert condition formula on the Spreadsheet system for Trading study
| [2025-09-08 21:47:08] |
| John - SC Support - Posts: 42699 |
|
The Spreadsheet System for Trading and the Spreadsheet System/Alert both have capabilities for alerting within the spreadsheet itself. You do not need to use the "Alerts" tab of the settings window in order to do this. Find an unused formula column in your Spreadsheet System for Trading and enter the following in row 3 of that column: =$J$45 < -500 Then on the Settings and Inputs tab of the Settings window for that Spreadsheet System for Trading, find the "Column ? Alert" entry for the column where you entered this formula and select the Alert Sound you want to use for it. You will then get an alert sound when the "Closed Daily Profit/Loss" is less than -500. Refer to the following: Spreadsheet Systems, Alerts and Automated Trading: Column [K, L, M, N, O, P, Q, R, S, T, U, V-Z] Alert If you want something visual, then you would want to add a "Color Bar Based on Alert Condition" study and reference the subgraph that represents that column. Refer to the following: Color Bar Based on Alert Condition For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |