Home >> (Table of Contents) Studies and Indicators >> Technical Studies Reference >> Spreadsheet Formula Bar
Technical Studies Reference
- Technical Studies Reference
- Common Study Inputs (Opens a new page)
- Using Studies (Opens a new page)
Spreadsheet Formula (Bar)
Description
The Spreadsheet Formula (Bar) study allows entering four formulas and calculates and displays the results as bars with an Open, High, Low, and Close. This result is then displayed on the chart in the selected Chart Region.
The Formula Inputs use the same format as Alert Formulas, including Functions, Identifiers, and references to other Studies. Refer to Alert Condition Formula Format for complete details.
The formulas support the use of a range of data values. Refer to Referencing A Range of Data for further information.
Formulas do not need to be preceded with an equals (=) sign, although the presence of the equals sign is acceptable.
Inputs
- Open Formula: This contains the formula to be graphed as the Open for each bar.
- High Formula: This contains the formula to be graphed as the High for each bar.
- Low Formula: This contains the formula to be graphed as the Low for each bar.
- Close Formula: This contains the formula to be graphed as the Close for each bar.
- Number of Bars to Calculate: This defines the number of bars for which the study will perform the calculation of the given Formulas. 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
By default, the data result from the Spreadsheet Formula (Bar) is displayed as a Candlestick bar. The Graph Draw Type 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.
*Last modified Friday, 14th March, 2025.