• Download software • Tutorial videos
• Subscription & data-feed pricing • Class schedule


• New account application • Trading resources
• Margin rates • Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » PCFs, EasyScan and Custom Indicators » Offset Minimum and Maximum for past periods

Offset Minimum and Maximum for past periods Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
sruefer
Posted : Wednesday, April 18, 2018 8:38:10 PM
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

 
Back to top
StockGuy
Posted : Wednesday, April 18, 2018 11:49:04 PM

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
Back to top
sruefer
Posted : Thursday, April 19, 2018 8:43:10 PM
Registered User
Joined: 2/19/2018
Posts: 2

Thank you, much appreciated!
Back to top
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.