Support Board
Date/Time: Fri, 07 Feb 2025 04:40:32 +0000
Spreadsheet for trading : Adding new studies
View Count: 974
| [2018-05-16 15:58:26] |
| User623552 - Posts: 69 |
|
Hi, When I setup the Spreadsheet system for trading, it contains all the study data in columns on the spreadsheet For example, VWAP data in column BK So I organise my VWAP trading formulas according to the data in column BK However, if I add a new study, the data for that study is inserted at the beginning of the spreadsheet So all exisiting studies are suddenly moved to a different column So my VWAP data is no longer in column BK, and none of my formulas work This is very frustrating, because whenever I add a study, my entire spreadsheet becomes useless Is there any way to set the spreadsheet to add new study data to the END of the spreadsheet, so it doesn't affect the existing data ? (p.s. I have searched the board, but couldn't find a solution) Thanks |
| [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. |
| [2018-05-16 18:48:27] |
| |
|
To solve this, you need to refer to the Subgraphs directly, rather than using direct spreadsheet cell references. Refer to the following: Using the Spreadsheet Study: Preventing Effect of Changes to Study Order and Subgraphs Outputted on Formula References to Study Subgraphs Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-05-19 20:00:57
|
| [2020-05-19 14:45:00] |
| trading2themoon - Posts: 46 |
|
There is already a setting for maintaining the references when inserting rows/columns. When that is enabled one should be able to assume the references within formulas would be updated when adding/removing studies as well. This has caused me countless hours of frustration, yet could be supported in code with a find/replace operation run automatically.
|
| [2020-05-19 17:31:07] |
| ForgivingComputers.com - Posts: 995 |
|
Is there any way to set the spreadsheet to add new study data to the END of the spreadsheet, so it doesn't affect the existing data ?
Yes. Select the last study in the Studies to Graph list, and then add the new study. This will maintain the original order and place the study at the end of the list. This may present calculation order issues, but it will maintain the correct order. If the studies are not in the proper calculation order and precedence, you may end up with old data from the previous time the study was updated. |
| [2020-05-20 00:04:18] |
| |
|
one should be able to assume the references within formulas would be updated when adding/removing studies as well. No this is definitely not the case.For the proper solution, refer to: Using the Spreadsheet Study: Preventing Effect of Changes to Study Order and Subgraphs Outputted on Formula References to Study Subgraphs Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-05-20 00:04:28
|
To post a message in this thread, you need to log in with your Sierra Chart account: