Support Board
Date/Time: Sat, 01 Nov 2025 01:26:52 +0000
Post From: Spreadsheet - Formula Rows extending beyond data
| [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 - 327 views Attachment Deleted. |