Support Board
Date/Time: Tue, 11 Mar 2025 01:02:00 +0000
Add a study to spread sheet and have to recode everything
View Count: 411
| [2022-04-21 23:57:16] |
| buggsuperstar - Posts: 33 |
|
When I add a study to a spread sheet all the columns change and my previous formulas no longer work. Do I really have to rewrite the logic every time I add or remove a study to the spread sheet??
|
| [2022-04-22 02:33:47] |
| Sawtooth - Posts: 4181 |
|
Do I really have to rewrite the logic every time I add or remove a study to the spread sheet??
Not if you do one of these:1. Use this method of referencing study outputs instead of the alphanumeric column/row reference: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 2. Add all studies at the bottom of the list in the Studies to Graph list, and never remove or rearrange any study in the list, and never insert or delete a Formula Column. Option 1 is preferred because: - You can add, remove, rearrange studies in the Studies to Graph list without messing with formulas. - You can insert and delete Formula Columns without messing with formulas. Date Time Of Last Edit: 2022-04-22 22:04:48
|
To post a message in this thread, you need to log in with your Sierra Chart account: