Support Board
Date/Time: Fri, 31 Oct 2025 18:49:05 +0000
Spreadsheet - Formula Rows extending beyond data
View Count: 856
| [2018-03-05 22:28:51] |
| knoxville1915 - Posts: 38 |
|
I keep running into this issue of my formula columns extending beyond the available data in a spreadsheet study. This occurs when I change symbols and there are fewer bars in the data file than there were previously. I've attached a screenshot to illustrate the issue. Is there a way for the spreadsheet formulas to calculate only for the available data? Alternatively, is there a way to ensure that all new symbols loaded into the chart, even if they have a stored data file, are loaded with the same time scope as was previously set in the chart settings? |
 screenshot1.png / V - Attached On 2018-03-05 22:27:57 UTC - Size: 37.76 KB - 326 views Attachment Deleted. |
| [2018-03-06 03:45:35] |
| |
|
We will see if it is practical to clear the formulas that go beyond the Number of Rows setting.
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: