Support Board
Date/Time: Wed, 19 Mar 2025 13:57:45 +0000
[Programming Help] - Spreadsheet with Random Zeros
View Count: 377
| [2022-10-19 03:36:52] |
| User312841 - Posts: 26 |
|
https://www.sierrachart.com/image.php?Image=1666149611501.png Experiencing some strange behavior with Spreadsheet trading, arrows were not drawing in the right places and I see all these zeros. Column AA is a 5 period EMA. Also ID6 is a higher timeframe 3xMA. ID4 is the current timeframe, not sure why it is sitting in Column AD right above ID6.sg2?? TIA |
 Capture.PNG / V - Attached On 2022-10-19 03:30:22 UTC - Size: 991.57 KB - 97 views Attachment Deleted. |
| [2022-10-19 15:01:48] |
| Sawtooth - Posts: 4186 |
|
If you add, remove, or rearrange studies in the Studies to Graph list, data in newly unused columns is not cleared. You can clear the data by highlighting all columns AA and above, then do a Chart >> Recalculate. If you use alphanumeric cell references of study outputs in columns AA and above, and you add, remove, or rearrange studies in the Studies to Graph list, formula references will not follow the column changes; they will reference the wrong columns. It is recommended that you use this cell reference method instead (for referencing study output columns AA and above): Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study This will allow you to make these changes without misaligned references: - Add, remove, or rearrange studies in the Studies to Graph list. - Change the Number of Formula Columns setting. - Insert/Delete Formula Columns. |
To post a message in this thread, you need to log in with your Sierra Chart account: