Login Page - Create Account

Support Board


Date/Time: Fri, 28 Feb 2025 10:23:18 +0000



Post From: Spreadsheet subgraphs interfere with other studies in the Chart Studies List?

[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