Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 02:02:26 +0000
Default Spreadsheet Study - Issues referencing past values
View Count: 706
| [2018-12-19 09:25:38] |
| User833285 - Posts: 4 |
|
Dear Sierra Chart Team, I am trying to add together certain values based on a dynamically calcualeted range length in my spreadsheet study. While formula (1): =SUM(BC3:INDIRECT(R3)) with R3 being =ADDRESS(3,COLUMN(BC3)+M3,4) works just fine in the row that is the most recent, copying down the formula (applying it to past values) does not yield the same result. For example referencing the previous row: =SUM(BC4:INDIRECT(R4)) returns a #REF! error. I was looking up the documentation about the INDIRECT(...) Formula wich outlines certain limitations. Is the issue I am experiencing related to this or is there a diffrent mistake? Would be very grateful for your support, thank you for this great programm. Best Grinsend Date Time Of Last Edit: 2018-12-19 19:46:23
|
 Spreadshet_Indirect_REF.PNG / V - Attached On 2018-12-19 09:25:01 UTC - Size: 34.78 KB - 255 views Attachment Deleted. |
| [2018-12-19 19:27:30] |
| |
|
The problem is that after the first row, the results are trying to sum backwards, which is not allowed. For example, in Row 4 the result of the INDIRECT would give: SUM(BC4:BE3). Since row 4 is greater than row 3, it does not know what data you want to sum. Also, keep in mind that when summing across columns it only uses the square of data that is between the upper left hand corner defined by the first parameter and the bottom left hand corner defined by the second parameter. And the upper left hand corner must be a lower row number than the lower right hand corner. 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 |
| [2018-12-19 19:34:24] |
| User833285 - Posts: 4 |
|
Thank you for your reply and support. Your explanation helped me solve it! |
To post a message in this thread, you need to log in with your Sierra Chart account: