Login Page - Create Account

Support Board


Date/Time: Sat, 21 Dec 2024 18:30:01 +0000



New Spreadsheets Iterations

View Count: 844

[2015-07-22 20:58:18]
CMG - Posts: 179
Hi There,
Are iterations available in the new spreadsheets? The option for calculations is grayed out in the Spreadsheet menu. Couldn't find it anywhere else.
Thanks
[2015-07-22 21:02:17]
Sierra Chart Engineering - Posts: 104368
When there are circular references, this is where recalculating those references a certain number of iterations is used. Circular references are not supported with New Spreadsheets. They will result in an error.
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
[2015-07-22 21:42:40]
CMG - Posts: 179
Thanks, what is the replacement for a circular reference on the new spreadsheets? or do I have to go back to the old ones?
[2015-07-23 04:07:04]
Sierra Chart Engineering - Posts: 104368
There is not. Although it is completely fine for a cell to reference itself. That will work.

If you are using New Spreadsheets and you are running the latest version and you are not getting any reference errors, then New Spreadsheets should work with the formulas you are using. Otherwise, use Old Spreadsheets.
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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account