Login Page - Create Account

Support Board


Date/Time: Fri, 28 Feb 2025 04:28:31 +0000



[User Discussion] - Combine ATR

View Count: 362

[2021-08-09 16:25:03]
User377189 - Posts: 203
I have two different time-period ATR on my chart

ATR-30
ATR-100

How can i achieve the following desired results?

I would like to see:
1) ONLY the largest of the two ATR's for the day on the chart
2) If the ATR is in decimals would like to see whole number
[2021-08-09 17:35:29]
Sawtooth - Posts: 4177
How can i achieve the desired results?
Try this:
Add the Spreadsheet Formula study:

- Use a formula like this in its Formula field:
=MAX(ID4.SG1,ID5.SG1)
where ID4 and ID5 are the two ATR studies.

- Set the Value Format to 1.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account