Login Page - Create Account

Technical Studies Reference

Spreadsheet Formula

The Spreadsheet Formula study allows a spreadsheet-style formula, that returns a in a numeric value, to be entered and is then displayed on the chart.

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.


  • Formula: This contains the actual formula to be graphed. The formula does not need to be preceeded with an =, although the presence of the = is acceptable.

    This Input does not support the use of data arrays. Therefore, in order to reference a series of data you need to reference them by their relative position to the current bar, such as ID1.SG1[-1] to get the previous bar data for Study 1, Subgraph 1. For example, to smooth out a Moving Average study that has been put on as the first study (ID1) in the chart by averaging three values, enter the following formula: AVERAGE(ID1.SG1, ID1.SG1[-1], ID1.SG1[-2]).

    Support for ranges of identifier values, will be supported in an upcoming release.
  • 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.

Changing Data Display Style

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.

*Last modified Tuesday, 24th October, 2017.