Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 05:02:46 +0000



Post From: Spreadsheet for trading : Adding new studies

[2018-05-16 18:38:26]
Sawtooth - Posts: 4173
The solution is to use the ID#.SG#@row# reference, instead of the traditional alphanumeric column/cell reference.
Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study

Another less useful solution is to always add studies to the bottom of the Studies to Graph list (and never rearrange studies in the list) because studies' outputs to the spreadsheet study appear in the same order as the list. However, this solution does not solve the same problem if you increase/decrease the Number of Formula Columns, or if you Insert/Delete columns.