Login Page - Create Account

Support Board

Date/Time: Sat, 19 Jan 2019 23:46:45 +0000

Spreasheet alerts from different sheets

Support Request:
[2017-12-15 16:52:25]
User98657 - Posts: 145
I'm in need of a spreadsheet on two different charts in the ES. both in the same CB.
For efficiency, i assumed to use one SpreadSheet Alert (SSA) study and allow the chart numbers to drive the sheet numbers (Sheet #1 and Sheet #12).
I assumed to build formulas on each sheet respectively, then assumed to use a color bar study on each chart to reference the subgraphs of the spreadsheet, and later a price/study overlay to get the results onto one chart.

I assumed each spreadsheet would have its own set of subrgraphs relative to each sheet/chart.

What i'm finding however, is that if Sheet 1 column K, L, M, N..., is true, the arrows show up on both charts. I can hide the SSA Study and not have the arrows show on the chart, but that's not my issue. My issue is that i don't want Chart 12 to see those subgraphs at all. I want Chart 12 to see columns K, L, M, N... from its own sheet.

On both charts In:59 is set to ByNumber, In:1 is set to its default "0", In:7 on Chart 1 is set to 1, and on Chart 12 it is set to 12.

Is this by design?

Obviously if this is the case one needs to use completely separate spreadsheet studies for each chart in order to reference different subgraph outputs.

Or, if I've missed something in the documentation I'd appreciate it if you could redirect me.
[2017-12-15 18:37:24]
Sierra Chart Engineering - Posts: 68081
Each of these Spreadsheet studies should all work independently from each other so long as they are using different Sheets and the Formula Source Sheet Number is different for each:


If there still is a problem, then it is not understood by us because what you are doing is complicated for us to understand from our perspective.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-15 18:37:40

To post a message in this thread, you need to login with your Sierra Chart account:


Login Page - Create Account