Home >> Support Board

Support Board

Date/Time: Sat, 03 Oct 2026 17:16:02 +0000

How to Post a Message for Support

Text Display from Study

View Count: 1686

[2025-03-10 00:34:25] #1 [Go To First Post]
User841161 - Posts: 356
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: 25042
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: 356
Great, when should i expect that it may be done?

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

[2025-03-12 21:35:53] #5 [Go To First Post]
Sierra_Chart Engineering - Posts: 25042
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: 25042
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: 48095
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: 48095
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

[2025-09-22 20:34:42] #11 [Go To First Post]
User841161 - Posts: 356
If I have a date in a cell inside spreadsheet, is there a way to have it display on chart?

[2025-09-22 20:48:53] #12 [Go To First Post]
John - SC Support - Posts: 48095
Is this in a Spreadsheet Study or in a regular Sierra Chart Spreadsheet? What cell contains the date you want to display? How are you wanting to display it? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-09-22 23:24:59] #13 [Go To First Post]
User841161 - Posts: 356
yes, right now i am using cell m3, wanting to just display as date on chart, ex. 11-21-2025 or 11-21-2025.

[2025-09-23 15:34:57] #14 [Go To First Post]
John - SC Support - Posts: 48095
How you access this depends on whether this is in a standard spreadsheet (started by selecting "File >> New Spreadsheet") or if this is one of the Spreadsheet Studies. Once you let us know then we can tell you how to display it as you want. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-09-23 16:54:42] #15 [Go To First Post]
User841161 - Posts: 356
Started with Spreadsheet Study..

[2025-09-23 17:27:24] #16 [Go To First Post]
John - SC Support - Posts: 48095
In this case, you can access the subgraph directly from the Spreadsheet Study and set the "Value Format" in the study you are using to reference it as "Date". Specifically, for the "Text Display for Study" set the "Study and Subgraph to Display" to be the Spreadsheet Study and the M column subgraph. Then set the "Value Format" to "Date". That is all you need to do. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2026-09-16 03:25:27] #17 [Go To First Post]
User841161 - Posts: 356
From the Spreadsheet Study “FedFundsSS”, on Sheet1, cell L3 contains the date 2026-09-30. I’m trying to display that date on the chart using Text Display for Study from Spreadsheet, but the date is not appearing. I have the study’s Value Format set to Date, and column L in the spreadsheet is also formatted as a date. Is there another setting I need to change in order for the date from cell L3 to display on the chart?


Screenshot 2026-09-15-1.png / V - Attached On 2026-09-16 03:23:53 UTC - Size: 47.34 KB - 26 views Screenshot 2026-09-15 2.png / V - Attached On 2026-09-16 03:25:20 UTC - Size: 6.09 KB - 19 views

[2026-09-16 13:36:31] #18 [Go To First Post]
Sawtooth - Posts: 4355
I’m trying to display that date on the chart using Text Display for Study from Spreadsheet The Text Display from Spreadsheet study will only display text from rows 1 and 2. So the value in L3 needs to be converted to text. Try this in cell L2: =CONCATENATE(YEAR(L3),"-",MONTH(L3),"-",DAY(L3)) Then in the Text Display from Spreadsheet study, set the Cell Reference to L2.

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