Registered User Joined: 2/19/2018 Posts: 2
|
Hi,
I am looking for a formula to calculate the following:
(Maximum high over last 180 days) minus (Minimum low from 1 year to 180 days ago).
I found MAX and MIN, but it only works for the number of recent bars. What I need is a formula that calculates last x bars and allows me to apply an offset, too.
Thank you for your help!
Steffen
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
MAXH180 - MINL180.180
Keep in mind the program only recognizes market days, so the last year is about 250 trading days. So you may want to use....
MAXH125 - MINL125.125
|
Registered User Joined: 2/19/2018 Posts: 2
|
Thank you, much appreciated!
|