Home >> Support Board

Support Board

Date/Time: Tue, 26 Aug 2025 18:17:32 +0000

How to Post a Message for Support

Text Display from Study

View Count: 528

[2025-03-10 00:34:25] #1 [Go To First Post]
User841161 - Posts: 297
In using Spreadsheet Study, I have in cell m3="Bearish". So I am tryingto have m3 cell text on my chart. I am trying to use Text Dipsplay For Study but it just returns 0.00 instead of "Bearish". Is there a way I can return text data rather than numeric, for i know numeric works just fine?

[2025-03-10 02:04:58] #2 [Go To First Post]
Sierra_Chart Engineering - Posts: 20740
We need to develop this. We will do that. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-03-10 15:37:07] #3 [Go To First Post]
User841161 - Posts: 297
Great, when should i expect that it may be done?

[2025-03-12 18:48:32] #4 [Go To First Post]
User841161 - Posts: 297
Any idea when this may be done?

[2025-03-12 21:35:53] #5 [Go To First Post]
Sierra_Chart Engineering - Posts: 20740
It will be done this week. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-03-13 06:50:24] #6 [Go To First Post]
Sierra_Chart Engineering - Posts: 20740
This is now released. It is in the latest release 2747. The name of the study is: Text Display from Spreadsheet. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-05-15 13:16:25] #7 [Go To First Post]
trader0222 - Posts: 32
Hi SC, Thanks for adding this study. I tried it but cant get it to work and the documentation is not up yet. Questions: 1. Input SpreadsheetName - must this include the extension scss? Is this case sensitive? 2. Input Sheet Name - I am assuming I have to enter 'Sheet1' and not just '1'?

[2025-05-15 14:40:13] #8 [Go To First Post]
John - SC Support - Posts: 41485
1. The spreadsheet name can either include or not include the extension of .scss. If you do include it, it is case sensitive, so you need to add it as '.scss'. 2. Yes, you need to enter the actual sheet name as it shows in the study, such as 'Sheet1'. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-06-02 09:16:46] #9 [Go To First Post]
trader0222 - Posts: 32
Hi John, Thank you for your reply. I followed your instructions but I couldnt get things to work. I am running v2761 and please see my attached screenshots. As you can see, I dont see the value 100 of cell A1 displayed in my chart. What could be wrong?


Private File Private File Attachment Deleted.

[2025-06-02 15:14:05] #10 [Go To First Post]
John - SC Support - Posts: 41485
One of the issues is that you will not get a value of 100 to display using the "Text Display from Spreadsheet". The item to be displayed needs to be text. So if you really want to show a value of "100" (no quotes), you would need to use the TEXT() function within the spreadsheet. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TEXT_Function Another item that you need to be aware of is that the spreadsheet needs to exist on the drive. For a Spreadsheet Study this occurs automatically, but for a standard Sierra Chart spreadsheet, you would need to save it one time before you will be able to get the text to show up. 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: