Home >> Support Board

Support Board

Date/Time: Mon, 21 Apr 2025 13:20:23 +0000

How to Post a Message for Support

Spreadsheet Value is gone?

View Count: 122

[2025-03-05 19:46:47] #1 [Go To First Post]
User993067 - Posts: 174
Hello, Today I added NQTV data, I used existing chartbook renamed it, changed symbols. I left all studies on original charts unchanged. When I reopened existing chartbook ( and 3 other older versions with nearly same settings, just window rearrangement) a few columns are now spitting blanks in my spreadsheet studies, which imported delta and pullstack difference values from charts to DOM and values grid beneath price. I have checked and all studies all still sending data to spreadsheet study, and of course no formulas were changed ( the data is also missing in the spreadsheet study of chartbooks that havent been opened in weeks) any ideas on how to recoup? I have exited and rebooted multiple times, and no changes


snip11.PNG / V - Attached On 2025-03-05 19:46:21 UTC - Size: 543.01 KB - 22 views

[2025-03-05 21:42:44] #2 [Go To First Post]
John - SC Support - Posts: 39362
For that Spreadsheet Study, what is the Input for "Number of Formula Columns" set to? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-03-06 02:32:31] #3 [Go To First Post]
User993067 - Posts: 174
16 but did not touch that setting....data before and after the columns with missing data

[2025-03-06 03:56:32] #4 [Go To First Post]
User993067 - Posts: 174
resolved....somehow column shifted left and formulas were building in an uncalled column.... assuming the spreadsheet does not operate like excel, in that if a column is deleted( or not sent to the spreadsheet study) everything must be realigned/recalculated?

[2025-03-06 14:22:37] #5 [Go To First Post]
Sawtooth - Posts: 4209
somehow column shifted left and formulas were building in an uncalled column.... This is why it is recommended to use this reference method instead of AlphaNumeric cell references: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study If you use this reference method, you can do these actions and still maintain correct references: - Insert/Delete Formula Columns. - Increase/Decrease the Number of Formula Columns setting. - Add/Remove/Rearrange studies in the Studies to Graph list. Date Time Of Last Edit: 2025-03-06 14:25:10

[2025-03-06 21:09:41] #6 [Go To First Post]
User993067 - Posts: 174
appreciated!

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