Support Board
Date/Time: Sat, 23 Nov 2024 08:37:01 +0000
Post From: Audible alert on Spreadsheet study when cell value exceeds a certain number
| [2024-09-06 14:02:07] |
| John - SC Support - Posts: 36238 |
|
It sounds like you have at one of the Spreadsheet Studies on a chart. You would need to put test formula in that sheet and then reference back to the "Profit" sheet, such as =Profit!$A$6. Whatever column you put that into on the sheet will have a corresponding subgraph. For instance, for Column K the subgraph is Subgraph 1. If you look at the Subgraph tab of the Spreadsheet Study Settings, you will see these listed out. You can then reference that subgraph in the Alert condition by entering a formula like the following: =ID1.SG1 > 100 Where ID1 is the ID of the Spreadsheet study and SG1 is the first subgraph (in this case, column K). Refer to the following and the section below it: Study/Chart Alerts And Scanning: Referencing Study Subgraphs For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |