Login Page - Create Account

Support Board


Date/Time: Sat, 12 Jul 2025 06:16:36 +0000



[User Discussion] - Combine ATR

View Count: 410

[2021-08-09 16:25:03]
User377189 - Posts: 216
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: 4238
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