Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 20:38:21 +0000



[User Discussion] - Spreadsheet Study

View Count: 978

[2014-10-09 13:05:51]
User16114 - Posts: 153
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]
Sawtooth - Posts: 4120
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 log in with your Sierra Chart account:

Login

Login Page - Create Account