Login Page - Create Account

Support Board


Date/Time: Tue, 31 Mar 2020 02:11:01 +0000



[User Discussion] - Spreadsheet Study

[2014-10-09 13:05:51]
User16114 - Posts: 153 | Ending Date: 2015-09-27 [Expired]
In a custom spreadsheet study I am using "Cumulative Sum of Study" on the "Volume" study for the ES and the "Cumulative Sum of Study" is outputted to spreadsheet column AD.

Then, I am using column AD data in a formula in column K which I think is causing an issue with calculation precedence.

1. Is there a way to get "Cumulative Sum of Study" outputted in column K or to the left of L?

Or

2. Is there a way to output column AD from one spreadsheet to column K in a second spreadsheet?

Thanks!
[2014-10-09 13:27:08]
tomgilb - Posts: 2427 | Ending Date: 2020-03-31
1) You can use =AD3 in K3.

2) This is possible, but not in the New Spreadsheets versions. However, you probably don't need to do resort to this solution.

To post a message in this thread, you need to login with your Sierra Chart account:

Login

Login Page - Create Account