Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/4/2012(UTC)
Posts: 12
Thanks: 4 times
|
Hi Roy
Need your help again.
How do you code for Explorer scan for stocks which closed at or above the 80th percentile of the High-Low Range.? Also for stocks which closed at or below the 20th percentile of the High-Low Range?
Appreciate your kind assistance
Regards
Stinkray
|
|
|
|
|
|
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)
|
Hi,
There might be a few different ways to write this. I would think you could use the following (although Roy or others may have a different solution):
**80th Percentile or Higher**
(C-L)/(H-L) >= 0.8
**20th Percentile or Lower**
(C-L)/(H-L) <= 0.2
|
 1 user thanked MS Support for this useful post.
|
|
|
|
| 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.
