Support Board
Date/Time: Mon, 25 Nov 2024 08:22:00 +0000
Spreadsheet function use in spreadsheet study vs spreadsheet formula study
View Count: 253
| [2024-03-19 20:00:27] |
| AndyB - Posts: 101 |
|
Hi SC, Are there any spreadsheet study functions listed in your documentation here Spreadsheet Functions: Available Functions that are NOT available for use with the standalone "spreadsheet formula" study as opposed to the "spreadsheet study" study? in particular, v/h lookup, getcorresponding match, etc etc. If not, is there any documentation listing the functions that are solely for "spreadsheet study" and NOT "spreadsheet formula" study to use? If they ARE all available, how would one go about referencing other studies with functions that use numerical values for dictating how far left or right to look for a particular cell? If the question isnt clear, let me know and ill do my best to be more specific. Thank you |
| [2024-03-20 15:13:53] |
| John - SC Support - Posts: 36238 |
|
To start with, the "Spreadsheet Formula", despite its name, does not use the Spreadsheet syntax, rather it uses the Alert syntax. So any function that works with the Alerts will work with the Spreadsheet Formula. That being said, we do not have an exact list of which functions work with the Alerts and which are only for Spreadsheets. The general rule, however, is that if the function references cells or ranges, then it will only work with the Spreadsheet (v/h lookup and getcorrespondingmatch fall into this category). Otherwise, it might work with Alerts, you would have to try and see. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: