Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 2/19/2005(UTC)
Posts: 17
|
Hello,
I don't know to write an exploration with:
Col A: Linear Regression Trendline between the period ref(C,-10) and ref(C,-5)
AND
Col B: Linear Regression Trendline between the period ref(C,-5) and C
What i want to determinate is the security will make a figure like a "V".
Thanks for your help
Patrick
:?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey Patoche-
What about something like this? If you can modify it to meet your needs please post back your final code.
[code:1:22bc698e3d]ColA [LR10]
LR:=Highest(LinearReg(C,1));
LR5:=Ref(LR,-5);
LR10:=Ref(LR,-10);
LR10-LR5
ColB [LR10]
LR:=Highest(LinearReg(C,1));
LR5:=Ref(LR,-5);
LR10:=Ref(LR,-10);
LR5-LR[/code:1:22bc698e3d]
|
|
|
|
|
|
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)
|
Or what about using the ZigZag() function?
jose '-)
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 2/19/2005(UTC)
Posts: 17
|
The code is good, but how to have a Linear regression trendline, and not a curve ?
Jose speaks about a ZigZag function, but the function moves with a percentage pre-defined, and it is impossible with a feedback.
:shock:
Pat
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 2/19/2005(UTC)
Posts: 17
|
Jose,
Thanks , you are the best.
Your Web site is great.
Pat.
:D
|
|
|
|
|
|
| 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.
