Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/23/2010(UTC)
Posts: 60
|
Using a Reverse Bar Count:
RBC = "LastValue(Cum(1))-Cum(1)"
I want to calculate a function on the day "RBC = 5" to be used as a constant.
For example; calculate a moving average for the day "RBC = 5" and use the value obtained in a calculation for the days when "RBC <=4". The value will always be calculated 5 days back from the current day, and used on days 4, 3, 2, and, 1 (the current day).
I did this using nested IF's which worked with small RBC values, but ran into trouble with compiler errors with large RBC values. So I need to find another way without multiple nested IF's.
Thank's,
Dennis
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
| 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.
