Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/20/2005(UTC)
Posts: 3
|
Hi
In one of the columns of an exploration I have the highest high for the year (just as a quick visual reference against the close). In order get around errors on issues with less than a year of history I tried this: Bars:=LastValue(Min(Cum(1)-1,260)); If(Bars<260,0,HHV(C,260)); to no avail. I still get: Error in column B: Invalid time period (zero or negative) passed to HHV() function.
Is it possible to get around this problem, preferably without inputting a new date with every exploration.
Thanks in advance
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth
Was thanked: 2 time(s) in 2 post(s)
|
Try this code:
pds:=252; {year's periods}
AdjPds:=LastValue(Min(pds,Cum(1)));
HHV(C,AdjPds)
jose '-)
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/20/2005(UTC)
Posts: 3
|
Many thanks Jose
No more invalid time period errors
|
|
|
|
|
|
| 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.
