Support Board
Date/Time: Sun, 22 Dec 2024 05:28:52 +0000
New Spreadsheets Iterations
View Count: 845
[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: