Rank: Member
Groups: Registered, Registered Users
Joined: 3/24/2008(UTC)
Posts: 22
|
How can i write a formula on:
1)Histogram drops,getting lower & lower consecutively for the past 9 days.
2)Today's histogram is higer than yesterday histogram.
3)Histogram went up higher & higher consecutively for the past 5 days
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79
|
bull&bear wrote:
1)Histogram drops,getting lower & lower consecutively for the past 9 days. x:=Histogram; x<ref(x,-1)<ref(x,-2)<ref(x,-3)<ref(x,-4)<ref(x,-5)<ref(x,-6)<ref(x,-7)<ref(x,-8)<ref(x,-9); bull&bear wrote:
2)Today's histogram is higer than yesterday histogram.
x:=Histogram; x>ref(x,-1); bull&bear wrote:
3)Histogram went up higher & higher consecutively for the past 5 days
x:=Histogram; x>ref(x,-1)>ref(x,-2)>ref(x,-3)>ref(x,-4)>ref(x,-5);
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Instead of piling up Ref() functions, have a look at the Sum() function.
wabbit [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79
|
wabbit wrote:Instead of piling up Ref() functions, have a look at the Sum() function.
wabbit [:D]
It is like this: (1) x:=Histogram; y:=x<ref(x,-1); sum(y,8)=8; (3) x:=Histogram; y:=x>ref(x,-1); sum(y,4)=4; ?
|
|
|
|
|
|
| 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.
