Discussions
»
Product and Service Development
»
Formula Assistance
»
Finding percent change from "highest high" to "lowest low" within a 5-week period
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles
Thanks: 4 times
|
Is there something that can locate the "highest high" and also the "lowest low" within a 4-week period, only when there is at least a 20% difference between them?
|
|
|
|
|
|
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,
If using Daily data, something like this should work:
100 - ((LLV(L,20) / HHV(H,20)) * 100) >= 20
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles
Thanks: 4 times
|
Thank you for this formula. I will test it out.
I am curious, though. What does the "100 - " do at the beginning of the formula?
Originally Posted by: MS Support  Hi,
If using Daily data, something like this should work:
100 - ((LLV(L,20) / HHV(H,20)) * 100) >= 20
|
|
|
|
|
|
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)
|
The other part of the formula returns the percentage of the low compared to the high (i.e. 80% means the low is 80% of the high. Subtracting this from 100 gives you the percent difference between the two instead, 20%.
You could also simply write the formula as:
LLV(L,20) / HHV(H,20) <= 0.8
Both measure a 20% difference.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Finding percent change from "highest high" to "lowest low" within a 5-week period
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.
