Rank: Newbie
Groups: Registered, Registered Users
Joined: 1/11/2011(UTC)
Posts: 8
|
|
|
|
|
|
|
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 Djakarta
The Life() function can be used (probably in a password-protected formula) to invalidate or modify the result of a formula. This function generates an N/A result once the remaining number of days reaches zero. Combining it with an IsDefined() or IsUndefined() function provides some additional flexibility for its use.
Be aware that password protection of formulas is not foolproof and can be broken by someone with the necessary skills or tools.
Roy
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 1/11/2011(UTC)
Posts: 8
|
thank you for his opinion
|
|
|
|
|
|
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 Kasim
Here's a simple example using a 5-period SMA.
Enable:=IsDefined(Life(100331));
SMA:=Mov(C,5,S);
ValueWhen(1,Enable,SMA);
That could be reduced further to just two lines, like this.
Enable:=IsDefined(Life(100331));
ValueWhen(1,Enable,Mov(C,5,S));
Roy
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 1/11/2011(UTC)
Posts: 8
|
hi Boss Roy thanks very much :((
I've tried & successfully... :-bd
I really thank you
Lord let your good reply :)
Kind Regards
Djakarta
|
|
|
|
|
|
| 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.
