Login Page - Create Account

Support Board


Date/Time: Tue, 16 Apr 2024 13:22:35 +0000



SymbolDisplay Issues

View Count: 538

[2018-10-03 17:54:34]
jmt816 - Posts: 45
If I use the TextDisplayForStudy and reference the SymbolDisplayStudy.SG1, it displays 0.00 not the text. Same result using TextDisplayForStudyFromChart.

I also tried using spreadsheet study and creating an absolute reference to the symbol ($J$40), then trying to use the two TextDisplayForStudy as above, and got the same result of it displaying a zero.

What I really want to accomplish is to be able to retrieve the symbol for the current chart to be able to use in a lookup to spreadsheet values, so am not attached to using SymbolDisplay. Seems like this should be a simple thing to accomplish, but can't figure out how. I know there's a ASCIL function to get the symbol, but am hoping to avoid writing a custom DLL if what i want to accomplish can be done with spreadsheet studies.
[2018-10-04 14:56:11]
John - SC Support - Posts: 30870
From what you are stating, it sounds like you need to use the Spreadsheet Study and reference cell J40, as you have tried to do, in an IF statement, or some other spreadsheet function. For example, if you want to display the Low values if the symbol is ESZ18, then you would put the following IF statement in cell K3: =IF($J$40 = "ESZ18", D3, 0)

Since the K column is automatically set to display, this would plot the Low values in a new Region in your chart.

You should be able to use this as a start and build upon it.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2018-10-04 15:28:44]
jmt816 - Posts: 45
Thanks for the formula, will play with that, b4 I resort to dusting off my C++ compiler and going that route.

Just to clarify tho, is the fact that TextDisplayForStudy does NOT return the text, but only numeric values, a bug or the intention of that study?
Since when i reference the SG1 (column K) where i have "calculated" a text value, it returns 0 rather than the text.
[2018-10-04 16:10:37]
John - SC Support - Posts: 30870
It is not a bug, it is simply how that study works. Subgraphs are floating point values, so the text is not actually stored with that Subgraph, it is just using the colors and information from that Subgraph for how to display the text that makes up the symbol. Therefore what you were trying to do with the Symbol Study and the Text Display for Study would not work.
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:

Login

Login Page - Create Account