Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 21:23:42 +0000



Post From: Color Bar Based On A Range Of Data

[2019-09-21 19:31:40]
User240019 - Posts: 112
In order to reference a range of data within a specific Subgraph, use the format IDx.SGy[b:e] where x is the ID of the particular study, y is the Subgraph number of the study (or chart), b is the beginning data reference, and e is the ending data reference.

For example, to calculate the average of the last 10 bars for the Open of the Main Price Graph, the formula would be AVERAGE(ID0.SG1[0:-10]).

When the data being referenced is part of the given chart, then it is not necessary to use the ID portion of the formula. For example, if writing a Chart alert from the Chart >> Chart Settings >> Alerts tab, and comparing the Average of the Open prices in the Main Price Graph against a constant, you could enter just the following: =AVERAGE(SG1[0:-10]) > 100 or =AVERAGE(O[0:-10]) > 100.

This does not work with this formula as I'm getting a #VALUE! error. I'm trying to color a renko bar the moment my calculated values hits a certain threshold.
=ID20.SG13[0:-10] >=1300

I'm referencing numbers bars calculated values of the total volume.