Support Board
Date/Time: Mon, 25 Nov 2024 21:33:23 +0000
Study Overlay Alert not listing in Spreadsheet
View Count: 360
| [2024-01-25 17:04:36] |
| User299107 - Posts: 55 |
|
Hi folks, I have an overbought alert for a Standard deviation study on Chart 1 that I overlay on Chart 2 and it prints on the chart as a dot above the price graph. However, when I send the Chart 2 study to the spreadsheet, it won't list the Alert (Subgraph 1). It will list subgraph 2 and 3, but not subgraph 1. Ideally, I would like it to list as a 1 or 0. If someone can assist, I would be most grateful. Thanks in advance, Eliza |
| [2024-01-25 17:43:38] |
| John - SC Support - Posts: 36280 |
|
Exactly what studies are you using for this? What is the study on Chart 1 that you are overlaying to Chart 2 and are you using the "Study/Price Overlay" to do the overlay or something else?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-26 03:53:57] |
| User299107 - Posts: 55 |
|
I am using a Standard Deviation Bands on Chart 1 which I have paired with a Color Bar Study to paint a dot above the price graph (Chart 1). I've then Study Overlayed this Color Bar onto Chart 2. The overlay works perfectly and paints a dot above the price graph. However, the Spreadsheet related to this study only lists subgraph 2 and subgraph3, not Subgraph1 which is the one that presents the YES/NO condition to paint the bar. Hope this makes things cleareer. Eliza |
| [2024-01-26 15:24:03] |
| John - SC Support - Posts: 36280 |
|
In the Study/Price Overlay study, select the "Subgraphs" tab and then select the first subgraph (which should be "Color Bar" from what we understand). Make sure the option towards the bottom for "Include in Spreadsheet" has a checkmark next to it.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-28 15:00:29] |
| User299107 - Posts: 55 |
|
SO, the advice did populate the Spreadsheet, and I've referenced that column in a formula. The cells calculate accurately, BUT when I add the Spreadsheet Study to the chart (with that column selected) nothing occurs. Any ideas would be MOST welcome Eliza |
| [2024-01-29 17:11:27] |
| John - SC Support - Posts: 36280 |
|
We need more information on what is occurring. We really do not understand what you mean by "when I add the Spreadsheet Study to the chart (with that column selected) nothing occurs." Selecting a column does not do anything in particular. What are you wanting to have happen?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-30 05:54:11] |
| User299107 - Posts: 55 |
|
To recap, I followed your instructions and the column appeared in the Spreadsheet. I then used that data to create data in another column. I have added that final data' column to a spreadsheet study and added it to the Chart - with the relevant subgraph selected. So, I have the correct Spreadsheet Chart selected. I have the correct column selected. The data is within the chart range. It is set to display on Chart 1. End result is I don't know what I've missed. If you don't understand, I'll just leave it. Thanks, Eliza |
| [2024-01-30 16:12:47] |
| John - SC Support - Posts: 36280 |
|
What column contains the data in the spreadsheet? Keep in mind only columns K, L, M, and N are set to display by default, so if you are using a different formula column, you would have to set the subgraph information appropriately. What Region are you having this displayed in? You do state that "The data is within the chart range", but please double check this. Make sure the values of the spreadsheet are such that they will display properly in the selected region. You may want to put the Spreadsheet Study in a separate region to start with to ensure that this is not a scaling issue. Then if you are able to view the data properly in a separate region, then you can move it to Region 1. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-30 16:52:46] |
| User299107 - Posts: 55 |
|
Close this ticket - thanks
|
To post a message in this thread, you need to log in with your Sierra Chart account: