• Technical Studies Reference
• Common Study Inputs (Opens a new page)
• Using Studies (Opens a new page)

Description

The Text Display from Spreadsheet is a study which is designed to give you a large text display of text from a specific cell in a specific sheet in a Sierra Chart Spreadsheet.

The Text Display from Spreadsheet study can access information from spreadsheets utilized in other charts.

Only text values can be displayed with this study. To convert a number to a text value use the CONCATENATE() function and reference a cell with a number value to convert it to text. Then reference the cell in which the CONCATENATE() function was used for the display. For example, to display the most recent Close value from a Spreadsheet Study (displayed in cell E3), you would enter the following in cell K3: =CONCATENATE(E3). Then reference cell K3 in this Text Display for Spreadsheet.

Setting the Text Font Size

To set the font size of the text, open the Study Settings window for this study. For instructions, refer to the Adding/Modifying Studies section.

Select the Subgraphs tab. Adjust the Width/Size setting for the Text Display Subgraph.

Inputs

• Horizontal Position From Left: This Input specifies the relative position from the left side of the chart where the spreasdheet text will appear at. The value can be from 1 to 150 where 1 is the far left edge and 150 is the far right edge.
• Vertical Position From Bottom: This Input specifies the relative position from the bottom of the Chart Region where the spreadsheet text will appear. The value can be from 1 to 100. 1 is at the bottom of the region and 100 as at the top of the region.
• Spreadsheet Name: This specifies the name of the spreadsheet for which the text display is desired. When using a Spreadsheet Study, the name of the spreadsheet is contained within the Spreadsheet Name on the Study Settings window.
• Sheet Name: This specifies the sheet name within the spreadsheet for which the text display is desired. The Sheet Name can be found in the upper left corner of the spreadsheet.
• Cell Reference: This specifies the cell for which the text display is desired.