Support Board
Date/Time: Tue, 26 Nov 2024 10:30:56 +0000
Post From: In need of some scanner help
| [2023-12-15 18:03:03] |
| John - SC Support - Posts: 36286 |
|
CLOSE, LOW, HIGH, etc are not recognized as special items. The O/H/L/C that can be used with the Alerts is also not recognized by the Spreadsheets. Although Spreadsheets and Alerts do share some common functions, the syntaxes are slightly different. Within the spreadsheet you can either reference the bar items by referencing the columns (column B is Open, Column is High, etc.) or by using the Subgraph nomenclature where the Main Price Graph is ID0 and SG1 is the Open, SG2 is the High, etc. (if you expand the columns in the Spreadsheet you will see these items listed). You would then use the Study/Subgraph reference for spreadsheets by entering an item as ID0.SG1@3. Refer to the following: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For the Main Price Graph what method you use is not terribly important, but for other studies you should use the method outlined in the link above, as this will keep the references correct if the order of the studies is changed (or a study is added) as that will change the columns that the data is in. This all said, your formula for the above in a spreadsheet is the following =(ID0.SG4@3 - ID0.SG3@3) / (ID0.SG2@3 - ID0.SG3@3) * 100 For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |