Support Board
Date/Time: Sat, 23 Nov 2024 17:57:22 +0000
INDIRECT(CONCATENATE in spreadsheet formula study
View Count: 117
| [2024-08-18 08:20:36] |
| ninjus - Posts: 29 |
|
Is it possible to use a formula like this in a spreadsheet formula study: MAX(INDIRECT(CONCATENATE("H[0:-",ID9.SG1))]) ? And if not is it possible to add the functionality? Id rather not have to add a spreadsheet study to achieve this. |
| [2024-08-19 15:20:06] |
| John - SC Support - Posts: 36238 |
|
No, this does not work with the Spreadsheet Formula, and no, this is not something that will change. You have to use the Spreadsheet Study to do what you want. Despite its name, the Spreadsheet Formula uses the Alert syntax - it does not use the Spreadsheet Syntax, which is why the formula you are suggesting does not work, as INDIRECT is not a function that works with Alerts. 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: