Home >> (Table of Contents) Studies and Indicators >> Technical Studies Reference >> Spreadsheet Formula

Technical Studies Reference

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

Spreadsheet Formula

Description
Inputs
Changing Data Display Style

Description

The Spreadsheet Formula study allows entering a formula and calculates the result. This result is then displayed on the chart in the selected Chart Region.

The Formula Input uses the same format as Alert Formulas, including Functions, Identifiers, and references to other Studies. Refer to Alert Condition Formula Format for complete details.

The Formula support the use of a range of data values. Refer to Referencing A Range of Data for further information.

Inputs

[Link] - [Top]

Formula: This contains the actual formula to be graphed. The formula does not need to be preceded with an =, although the presence of the = is acceptable.
Number of Bars to Calculate: This defines the number of bars for which the study will perform the calculation of the given Formula. Entering a 0 means that no calculation will be performed.
Draw Zero Values: When this Input is set to Yes then formulas that result in zero values will be displayed. Otherwise, when this is set to No then formulas that result in zero values will not be displayed.

Changing Data Display Style

[Link] - [Top]

By default, the data result from the Spreadsheet Formula is displayed as a line. The line style, color, width and other display settings are controlled in the Subgraphs tab on the Study Settings window.

For more information, refer to the Subgraphs Tab section of the Chart Studies documentation.