- Katılım
- 23 Eki 2020
- Mesajlar
- 1,828
Linear Regression Line Motion #3
Pe:=Input("Periods",3,1000,10);
Ref((LastValue(Ref(LinearReg(C,Pe),-20))-
(LastValue(Ref(LinRegSlope(C,Pe),-20))*
(LastValue(Ref(Cum(1),-20))-Ref(Cum(1),-20))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-20))-Pe+20)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-20))-Pe+20))),20);
Ref((LastValue(Ref(LinearReg(C,Pe),-21))-
(LastValue(Ref(LinRegSlope(C,Pe),-21))*
(LastValue(Ref(Cum(1),-21))-Ref(Cum(1),-21))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-21))-Pe+21)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-21))-Pe+21))),21);
Ref((LastValue(Ref(LinearReg(C,Pe),-22))-
(LastValue(Ref(LinRegSlope(C,Pe),-22))*
(LastValue(Ref(Cum(1),-22))-Ref(Cum(1),-22))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-22))-Pe+22)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-22))-Pe+22))),22);
Ref((LastValue(Ref(LinearReg(C,Pe),-23))-
(LastValue(Ref(LinRegSlope(C,Pe),-23))*
(LastValue(Ref(Cum(1),-23))-Ref(Cum(1),-23))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-23))-Pe+23)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-23))-Pe+23))),23);
Ref((LastValue(Ref(LinearReg(C,Pe),-24))-
(LastValue(Ref(LinRegSlope(C,Pe),-24))*
(LastValue(Ref(Cum(1),-24))-Ref(Cum(1),-24))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-24))-Pe+24)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-24))-Pe+24))),24);
Ref((LastValue(Ref(LinearReg(C,Pe),-25))-
(LastValue(Ref(LinRegSlope(C,Pe),-25))*
(LastValue(Ref(Cum(1),-25))-Ref(Cum(1),-25))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-25))-Pe+25)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-25))-Pe+25))),25);
Ref((LastValue(Ref(LinearReg(C,Pe),-26))-
(LastValue(Ref(LinRegSlope(C,Pe),-26))*
(LastValue(Ref(Cum(1),-26))-Ref(Cum(1),-26))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-26))-Pe+26)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-26))-Pe+26))),26);
Ref((LastValue(Ref(LinearReg(C,Pe),-27))-
(LastValue(Ref(LinRegSlope(C,Pe),-27))*
(LastValue(Ref(Cum(1),-27))-Ref(Cum(1),-27))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-27))-Pe+27)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-27))-Pe+27))),27);
Ref((LastValue(Ref(LinearReg(C,Pe),-28))-
(LastValue(Ref(LinRegSlope(C,Pe),-28))*
(LastValue(Ref(Cum(1),-28))-Ref(Cum(1),-28))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-28))-Pe+28)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-28))-Pe+28))),28);
Ref((LastValue(Ref(LinearReg(C,Pe),-29))-
(LastValue(Ref(LinRegSlope(C,Pe),-29))*
(LastValue(Ref(Cum(1),-29))-Ref(Cum(1),-29))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-29))-Pe+29)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-29))-Pe+29))),29)
Pe:=Input("Periods",3,1000,10);
Ref((LastValue(Ref(LinearReg(C,Pe),-20))-
(LastValue(Ref(LinRegSlope(C,Pe),-20))*
(LastValue(Ref(Cum(1),-20))-Ref(Cum(1),-20))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-20))-Pe+20)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-20))-Pe+20))),20);
Ref((LastValue(Ref(LinearReg(C,Pe),-21))-
(LastValue(Ref(LinRegSlope(C,Pe),-21))*
(LastValue(Ref(Cum(1),-21))-Ref(Cum(1),-21))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-21))-Pe+21)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-21))-Pe+21))),21);
Ref((LastValue(Ref(LinearReg(C,Pe),-22))-
(LastValue(Ref(LinRegSlope(C,Pe),-22))*
(LastValue(Ref(Cum(1),-22))-Ref(Cum(1),-22))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-22))-Pe+22)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-22))-Pe+22))),22);
Ref((LastValue(Ref(LinearReg(C,Pe),-23))-
(LastValue(Ref(LinRegSlope(C,Pe),-23))*
(LastValue(Ref(Cum(1),-23))-Ref(Cum(1),-23))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-23))-Pe+23)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-23))-Pe+23))),23);
Ref((LastValue(Ref(LinearReg(C,Pe),-24))-
(LastValue(Ref(LinRegSlope(C,Pe),-24))*
(LastValue(Ref(Cum(1),-24))-Ref(Cum(1),-24))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-24))-Pe+24)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-24))-Pe+24))),24);
Ref((LastValue(Ref(LinearReg(C,Pe),-25))-
(LastValue(Ref(LinRegSlope(C,Pe),-25))*
(LastValue(Ref(Cum(1),-25))-Ref(Cum(1),-25))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-25))-Pe+25)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-25))-Pe+25))),25);
Ref((LastValue(Ref(LinearReg(C,Pe),-26))-
(LastValue(Ref(LinRegSlope(C,Pe),-26))*
(LastValue(Ref(Cum(1),-26))-Ref(Cum(1),-26))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-26))-Pe+26)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-26))-Pe+26))),26);
Ref((LastValue(Ref(LinearReg(C,Pe),-27))-
(LastValue(Ref(LinRegSlope(C,Pe),-27))*
(LastValue(Ref(Cum(1),-27))-Ref(Cum(1),-27))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-27))-Pe+27)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-27))-Pe+27))),27);
Ref((LastValue(Ref(LinearReg(C,Pe),-28))-
(LastValue(Ref(LinRegSlope(C,Pe),-28))*
(LastValue(Ref(Cum(1),-28))-Ref(Cum(1),-28))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-28))-Pe+28)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-28))-Pe+28))),28);
Ref((LastValue(Ref(LinearReg(C,Pe),-29))-
(LastValue(Ref(LinRegSlope(C,Pe),-29))*
(LastValue(Ref(Cum(1),-29))-Ref(Cum(1),-29))))+
Ref(C,(0-(LastValue(Ref(Cum(1),-29))-Pe+29)))-
Ref(C,(0-(LastValue(Ref(Cum(1),-29))-Pe+29))),29)
Source / From: |