steenth Member Posts: 12 Joined: 5/12/2006  User Profile | I would like to add a new Criteria Rule to Custom List I have created. I have noticed that when MOM (21) is near the 100 line a shift in direction is more likely. I am having trouble writing my new rule. For Example, to further refine a buy indication I want the MOM(21) to be within 25% of the max the indicator has been in the last 180 days. So If MOM lowest reading in the last 180 days was 80, then this rule would fire true if the reading were between 95 and 100. Could you help me with writing this? I am not sure how to use MAX in the formula. thanks | |
