logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
77Bundyrun  
#1 Posted : Tuesday, January 7, 2020 8:28:28 AM(UTC)
77Bundyrun

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?

MS Support  
#2 Posted : Tuesday, January 7, 2020 5:05:19 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,622

Thanks: 51 times
Was thanked: 130 time(s) in 126 post(s)
Originally Posted by: 77Bundyrun Go to Quoted Post

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

thanks 1 user thanked MS Support for this useful post.
77Bundyrun on 1/9/2020(UTC)
77Bundyrun  
#3 Posted : Thursday, January 9, 2020 7:13:22 AM(UTC)
77Bundyrun

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 1/31/2019(UTC)
Posts: 5

Thanks: 1 times

Thank you

Users browsing this topic
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.