Support Board
Date/Time: Mon, 13 Jan 2025 05:39:24 +0000
Text display from spread sheet
View Count: 781
| [2017-04-09 15:34:33] |
| User93534 - Posts: 30 |
|
Hi, I am trying to display text on the chart from a spread sheet formula like this: =IF(AND(BA3>0,ID0.SG4@3>AN3),"LGS UP",IF(AND(BA3>0,ID0.SG4@3<AN3),"MM UP",IF(AND(BA3<0,ID0.SG4@3<AN3),"LGS DOWN",IF(AND(BA3<0,ID0.SG4@3>AN3),"MM DOWN",0)))) the formula works fine and returns desired text in the cell but the text display from study just returns 0.00 on the chart. Is it possible to print the text on the chart or do I need to make numerical value like 1-4 and assign a color or some other work around? Would prefer words. |
| [2017-04-10 10:33:22] |
| |
|
The Spreadsheet study only works with numerical values from the Sheet. You have to use this Study Subgraph Draw Style to do text: Chart Studies: Text (ACSIL: DRAWSTYLE_TEXT) 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, *change* to 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: