Support Board
Date/Time: Mon, 25 Nov 2024 08:43:57 +0000
Post From: Spreadsheet function use in spreadsheet study vs spreadsheet formula study
| [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 |