Discussions
»
Product and Service Development
»
Formula Assistance
»
data array with only values greater than last close
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/25/2009(UTC) Posts: 4
|
Could anyone help me to filter the data array to have just value than last close?
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 7/25/2005(UTC) Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi cegorj
If I understand your question correctly then yes, this can be done in a rather crude way. I'm just not sure why you'd want to though. Plot the indicator below as a medium to heavy dotted line. The last line generates an N/A result that allows zero value outputs from the second line to disappear from view in the chart window.
LV:=LastValue(C); If(C>LV,C,0); ValueWhen(1,0,0);
Roy
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
data array with only values greater than last close
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.