Discussions
»
Product and Service Development
»
Formula Assistance
»
to move the diagram behind and only adding the closing...
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 8/23/2007(UTC)
Posts: 25
|
but someone succeeds to make this:
pezzo1: =Ref (C, 400);
pez: =If (Ref (C, 400) =true, 1,0);
pezzo2: =Ref (LastValue (C), - 400);
pezzo3: =IsDefined (Ref (C, 400));
pezzo4: =IsDefined (LastValue (pezzo1));
pezzo5: =ValueWhen (1, pezzo3=1, Ref (C, 400));
pezzo6: =ValueWhen (1, pezzo3=0, LastValue (pezzo1));
pezzo5; pezzo6
but me alone two distinguished pointers I would want some to only create one
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/28/2004(UTC)
Posts: 110
|
Can you rephrase your question? Maybe explain what you wish to do.
Pezzo1 is a forward reference. All this does is move the close back 400 bars.
Pez is meaningless unless the forward referenced close were to equal "true" or a value of one. The value of this line is likely to always be zero.
Pez and Pezzo2 are never referenced again...why are they there?
Preston
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 8/23/2007(UTC)
Posts: 25
|
scusami they were tests however the formula is this
pezzo1: =Ref (C, 400);
pezzo2: =Ref (LastValue (c), - 400);
pezzo3: =IsDefined (Ref (C, 400));
pezzo4: =IsDefined (LastValue (pezzo1));
pezzo5: =ValueWhen (1, pezzo3=1, Ref (C, 400));
pezzo6: =ValueWhen (1, pezzo3=0, LastValue (pezzo1));
pezzo5; pezzo6
I do not succeed to create an only pointer! I would want to attack to the data capacities behind, “pezzo1” l last closing for the lacking period to complete the diagram
|
|
|
|
|
|
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:
{pezzo1:=Ref(C,400);}
{pezzo2:=Ref(LastValue(C),-400);}
pezzo3:=IsDefined(Ref(C,400));
{pezzo4:=IsDefined(LastValue(pezzo1));}
pezzo5:=ValueWhen(1,pezzo3=1,Ref(C,400));
{pezzo6:=ValueWhen(1,pezzo3=0,LastValue(pezzo1));}
LastValue(pezzo5+PREV-PREV){;pezzo6}
Or simply:
LastValue(Ref(C,400)+PREV-PREV)
jose '-)
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
to move the diagram behind and only adding the closing...
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.
