Support Board
Date/Time: Tue, 01 Jul 2025 02:05:21 +0000
Post From: Study: Max of a Range or Percentage of the Max of a Range
| [2021-03-10 18:52:39] |
| PeaceFrog - Posts: 105 |
|
THAT is cool! Thank you so much for your reply. Based on my initial question, I can understand why you're asking about a rolling max and whether it’s for prices or a study. I believe that I am looking for a rolling max and am looking for the new study to be applied to an already existing Sierra Charts study (Analysis->Tools->ADX), like you can with, for example the "Input Data" field in the "Settings and Inputs" tab of the "Momentum" study when the ADX Study is already applied to the chart. For me to clarify, it’s probably easiest if I give an example. For the data set: A B C D E 1 DATE TIME ADX 4-Bar Max ADX Previous ADX divided by 4-Bar Max ADX 2 10-03-2020 8:10:00 AM 40 =45 =Max(B3:B6) =35/45 =C3/D2 3 10-03-2020 8:09:00 AM 35 =45 =Max(B4:B7) =40/45 =C4/D3 4 10-03-2020 8:08:00 AM 40 =45 =Max(B5:B8) =45/45 =C5/D4 5 10-03-2020 8:07:00 AM 45 =40 =Max(B6:B9) =40/40 =C6/D5 6 10-03-2020 8:06:00 AM 40 =35 =Max(B7:B10) =35/35 =C7/D6 7 10-03-2020 8:05:00 AM 35 =30 =Max(B8:B11) =30/30 =C8/D7 8 10-03-2020 8:04:00 AM 30 =25 =Max(B9:B12) =25/25 =C9/D8 9 10-03-2020 8:03:00 AM 25 10 10-03-2020 8:02:00 AM 20 11 10-03-2020 8:01:00 AM 15 12 10-03-2020 8:00:00 AM 10 I suppose I am looking for two studies, 1 that produces Column D and one that produces Column E. I hope this helps clarify. Thank you again for your time and willingness to help. It is very much appreciated. |
 Example Data Set.PNG / V - Attached On 2021-03-10 18:51:22 UTC - Size: 20.72 KB - 261 views Attachment Deleted. |