Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 04:37:35 +0000



Post From: Notice: New Sierra Chart Spreadsheet Functionality

[2014-05-22 03:27:21]
Sierra Chart Engineering - Posts: 104368
Another limitation of the new non-CLR spreadsheets is that it is not possible to reference data across Spreadsheets by specifying the name of the Spreadsheet in a cell reference. Only within Sheets within the Spreadsheet. And it is not likely this functionality will ever be added.

There are ways of designing your use of Spreadsheets, so this is not required. The main solution is to use the Chart Data Output Sheet Number to control what Sheet within the Spreadsheet the data is outputted to and is used by the Spreadsheet study.

Spreadsheets support 60 formula columns and you can also have multiple window views into the same Spreadsheet Sheet.

These limitations, exist because of the very high degree of complexity to implement them and to support them. Spreadsheets are complicated enough without adding unnecessary complexity. We have a responsibility to ensure the spreadsheets are fast and are reliable and can be properly maintained and supported. So these limitations are likely to always be limitations but they really are not limitations because the core spreadsheet functionality is provided and it executes very fast. And accurately.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2014-05-22 03:27:41