Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 1/31/2019(UTC)
Posts: 5
Thanks: 1 times
|
I am having difficulty creating a formular that could reveal stocks that are say 20% of their 52 week high could anyone suggest a formular?
|
|
|
|
|
|
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)
|
Originally Posted by: 77Bundyrun  I am having difficulty creating a formular that could reveal stocks that are say 20% of their 52 week high could anyone suggest a formular?
Hello, There are a few ways you could write this, depending on the data arrays you want to compare, interval/periodicity of the data (Daily vs. Weekly, etc.) and whether you want to establish a min and max range on the data comparison. If you just want to establish a lower range of the Close price being at least 80% of the 52-Week High you could write something like: Code:C / Ref(HHV(C,250),-1) >= 0.8
|
 1 user thanked MS Support for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 1/31/2019(UTC)
Posts: 5
Thanks: 1 times
|
|
|
|
|
|
|
| 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.
