Login Page - Create Account

Support Board


Date/Time: Sun, 19 Jan 2025 03:06:48 +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?
imagescreenshot1.png / V - Attached On 2018-03-05 22:27:57 UTC - Size: 37.76 KB - 263 views
Attachment Deleted.