Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 8/11/2005(UTC)
Posts: 104
|
Hi
I must be using “ValueWhen” incorrectly as I get unpredictable
results
Sometimes it works
correctly and sometimes incorrect
I wish to Start
Line Pivot Line & Target Line at the date of the LastValue(LLV(Low,Pds)) see screenshot below
Thank you in
advance,
Derek
Code:
Pds:=Input("
Periods ",1,2000,252);
Pivot:= LastValue(LLV(Low,Pds));
Rg:=(Sqrt((9 + 12* Pivot))+3)/6;
Inc:=Input("Enter Increment or
Decremnt",-12,100,1.5);
Target:=(Power((((Rg+Inc)*6)
-3),2) -9)/12;
Start:=ValueWhen(1,Low=Pivot,Cum(1));
Pivot:=ValueWhen(1,Start,Pivot);
Pivot;
Target:=ValueWhen(1,Start,Target);
Target;
|
|
|
|
|
|
| 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.
