Discussions
»
Product and Service Development
»
Formula Assistance
»
how to find highest high value of high in the range (from- to)
Rank: Newbie
Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/4/2014(UTC)
Posts: 3
Thanks: 2 times
|
Dear everyone,
How can i find highest value of High price in the range between of barsince 15 days ago - 5 barsince days ago? please kindly help assist
example : if current day( today) is date 25 dec 14, So i would like to know highest value high price since 10Dec14 (backward 15day) to 20Dec14 (backward 5 day)
Thanks very much for all assist
Regards
|
|
|
|
|
|
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 REF (reference) function allows you to go forward or backward in the data set. It would appear that you simply need to set your starting point back 5 periods using REF(Condition,-5) or more specifically:
Ref(HHV(H,10),-5)
|
 1 user thanked MS Support for this useful post.
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
how to find highest high value of high in the range (from- to)
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.
