Rank: Newbie
Groups: Registered Users, Subscribers, Unverified Users
Joined: 11/10/2016(UTC)
Posts: 2
Thanks: 1 times
|
Looking for a scan that shows the stocks that have made a new 60 day high in the past 2 days. So not just Cross(C,Ref(HHV(H,60),-1)) because that only shows those that where the close is greater than the HHV of the last 60 days.
I am looking to the new high in the last 2 days. So today's high could be lower than yesterday, but either today's high or yesterday's high is greater than the high of the last 60 days.
Also looking for the same on the low side. Stock that have made a new 60 day low in the past 2 days.
Thanks. Edited by user Thursday, November 10, 2016 8:06:31 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Column A: High
Alert(H > Ref(HHV(H,60),-1),2)
Column B: Low
Alert(L < Ref(LLV(L,60),-1),2)
Filter:
ColA OR ColB
|
 1 user thanked MS Support for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered Users, Subscribers, Unverified Users
Joined: 11/10/2016(UTC)
Posts: 2
Thanks: 1 times
|
Perfect. You've got it spot on.
Thanks.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
