Support Board

Date/Time: Thu, 25 Apr 2024 12:57:19 +0000

Spreadsheets and Studies - Cross-Referencing

[2020-03-27 20:57:40] #1 [Go To First Post]
a Gem Tree - Posts: 60
This is not necessarily a support issue. I understand what that means. This is a spreadsheet coding issue - involving the use of the cumulative sum study. --I have created an spreadsheet which outputs data to column X. --Cumulative sum study then adds all of the data in column X, and creates the summed up data in column Y. --Then I alter the data in column Y again, yielding column Z. --Then I create Moving Averages of this summed up data, and reference the MAs using color bars. Currently when I alter the original equation which creates column X, changes are not loading correctly into the MAs. As I change parts of the formula for column X - the MAs repeatedly do not change OR they have different results for the same input data (after being changed a few times). *Am I making a mistake by referencing a spreadsheet column, into a cumulative sum study, and back into the spreadsheet? That is my only guess...* I must use this cumulative sum study. Is there a way to sum up bars in spreadsheets that doesn't involve using the SUM function? (that annihilates my processor speed) Seriously, any help is much appreciated. Thank you.

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