Support Board
Date/Time: Tue, 26 Nov 2024 10:45:05 +0000
Post From: In need of some scanner help
| [2023-12-15 18:39:26] |
| John - SC Support - Posts: 36286 |
|
Any study that is on the same chart will have that data in the Spreadsheet Study starting in column AA (by default, it depends on how many Calculation Columns you specify in the Inputs to the Spreadsheet Study). But as we said, it is best to reference any data that you need within the Spreadsheet study using the IDx.SGy@n nomenclature, otherwise things can change and you will have a mess to clean up. To access previous values within a spreadsheet, you need to reference the actual row values. When needing to reference previous values for a particular study/subgraph, you need to change the value after the @. For example, to get the value for the bar prior to the current bar, for the High, it would be ID0.SG2@4, as 4 is the row number of the second bar in the chart. Note that the row data starts in row 3. This is what are referring to when we say that the Alerts and Spreadsheets use different syntax. We are not sure what you are asking about in terms of the Color Bar Based on Alert Condition, or the reference to the Analysis window. If you need help with these, we need more information. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |