Support Board
Date/Time: Fri, 28 Feb 2025 04:59:10 +0000
Spreadsheet subgraphs interfere with other studies in the Chart Studies List?
View Count: 389
| [2021-08-07 21:11:14] |
| Dyoung - Posts: 11 |
|
I am having trouble(3 hours of trying) with the "Spreadsheet system for trading" subgraphs which seem to interfere with the regular Studies order and how they are populated on the chart. The Spreadsheet study is at the bottom of the Studies order in the Studies window. I am using a "Moving Averages Study" that lets me enter 3 moving averages in one study which are populated in the chart ok. The data is translated to the Spreadsheet ok. I created a formula between the 2nd and 3rd MAs with a Stoch %K in columns W, X, Y & Z of the spreadsheet. I then go to the subgraph window of the spreadsheet and set these columns for bar hollow and candle fill. Question 1: With the bars colored, the chart populates with the MAs behind the bars and I can't see the MA crossover. However, If I move the Spreadsheet order in the Studies window above the MA and stoch study, it works fine. Will this create a problem when I try to set up an auto trade system with studies below the Spreadsheet Study? Question 2: In the spreadsheet subgraph window, I have tried (for example) to have the MAs plot in the chart from the spreadsheet instead of the study. For example, spreadsheet AN3 is an MA. If I go to the subgraph window of the spreadsheet and choose "line" for AN3, it does not work. Can you explain why it does not work? Thanks in advance, Dennis Young
|
| [2021-08-09 14:35:24] |
| John - SC Support - Posts: 38259 |
|
Question 1: The order of the studies in the list is the order in which they are drawn. Therefore, when the Spreadsheet study is lower in the list than the MAs, it will draw the MAs first, then the Spreadsheet study on top of them. You should not have any issues with an auto-trade system that is setup below the Spreadsheet study. Question 2: You can only display the columns that are set as "Formula Columns". This is controlled by the Input on the Spreadsheet Study for Number of Formula Columns. Note that increasing this value will just push the data columns further back. Therefore, it is not possible to actually display the data from the other studies directly. To do this, you would need to reference the data in one of the formula columns and then display that formula column. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: