Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Gold Customer
Joined: 12/21/2004 Posts: 13
|
Sirs, I use the linear regression to make some judgements on stocks, both 3 month and 4 month linear regressions. I want to get the slope of those regression lines and use them in scans to select stocks.
Can you tell me how to write the formula for the slope of the linear regression line created by the Worden software or how I can obtain that value to use in my scans?
The slope should be the number that is the ratio of the 'rise over run', and consequently, its number will be the value of dollars gained in the stock per each day of trading, as measured by the linear regression.
thank you for your assistance........warren shepherd
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
An Indicator Formula for the slope of a 63-Period Linear Regression Line (about 3-months on a Daily Chart) would be:
(31 * C + 30 * C1 + 29 * C2 + 28 * C3 + 27 * C4 + 26 * C5 + 25 * C6 + 24 * C7 + 23 * C8 + 22 * C9 + 21 * C10 + 20 * C11 + 19 * C12 + 18 * C13 + 17 * C14 + 16 * C15 + 15 * C16 + 14 * C17 + 13 * C18 + 12 * C19 + 11 * C20 + 10 * C21 + 9 * C22 + 8 * C23 + 7 * C24 + 6 * C25 + 5 * C26 + 4 * C27 + 3 * C28 + 2 * C29 + C30 - C32 - 2 * C33 - 3 * C34 - 4 * C35 - 5 * C36 - 6 * C37 - 7 * C38 - 8 * C39 - 9 * C40 - 10 * C41 - 11 * C42 - 12 * C43 - 13 * C44 - 14 * C45 - 15 * C46 - 16 * C47 - 17 * C48 - 18 * C49 - 19 * C50 - 20 * C51 - 21 * C52 - 22 * C53 - 23 * C54 - 24 * C55 - 25 * C56 - 26 * C57 - 27 * C58 - 28 * C59 - 29 * C60 - 30 * C61 - 31 * C62) / 20832
An Indicator Formula for the slope of a 84-Period Linear Regression Line (about 4-months on a Daily Chart) would be:
(41.5 * C + 40.5 * C1 + 39.5 * C2 + 38.5 * C3 + 37.5 * C4 + 36.5 * C5 + 35.5 * C6 + 34.5 * C7 + 33.5 * C8 + 32.5 * C9 + 31.5 * C10 + 30.5 * C11 + 29.5 * C12 + 28.5 * C13 + 27.5 * C14 + 26.5 * C15 + 25.5 * C16 + 24.5 * C17 + 23.5 * C18 + 22.5 * C19 + 21.5 * C20 + 20.5 * C21 + 19.5 * C22 + 18.5 * C23 + 17.5 * C24 + 16.5 * C25 + 15.5 * C26 + 14.5 * C27 + 13.5 * C28 + 12.5 * C29 + 11.5 * C30 + 10.5 * C31 + 9.5 * C32 + 8.5 * C33 + 7.5 * C34 + 6.5 * C35 + 5.5 * C36 + 4.5 * C37 + 3.5 * C38 + 2.5 * C39 + 1.5 * C40 + .5 * C41 - .5 * C42 - 1.5 * C43 - 2.5 * C44 - 3.5 * C45 - 4.5 * C46 - 5.5 * C47 - 6.5 * C48 - 7.5 * C49 - 8.5 * C50 - 9.5 * C51 - 10.5 * C52 - 11.5 * C53 - 12.5 * C54 - 13.5 * C55 - 14.5 * C56 - 15.5 * C57 - 16.5 * C58 - 17.5 * C59 - 18.5 * C60 - 19.5 * C61 - 20.5 * C62 - 21.5 * C63 - 22.5 * C64 - 23.5 * C65 - 24.5 * C66 - 25.5 * C67 - 26.5 * C68 - 27.5 * C69 - 28.5 * C70 - 29.5 * C71 - 30.5 * C72 - 31.5 * C73 - 32.5 * C74 - 33.5 * C75 - 34.5 * C76 - 35.5 * C77 - 36.5 * C78 - 37.5 * C79 - 38.5 * C80 - 39.5 * C81 - 40.5 * C82 - 41.5 * C83) / 49385
Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 5/9/2011 Posts: 80
|
Bruce,
I have searched the database for previous LRL-SLOPE equations you have written already.
I am looking to find on for a 75 day period that goes with a 25 day period. Would you have produced
these equations already? Both equations are for CLOSE of Price.
Jim
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
An Indicator Formula for the slope of a 75-Period Linear Regression Line could be written as:
(37 * C + 36 * C1 + 35 * C2 + 34 * C3 + 33 * C4 + 32 * C5 + 31 * C6 + 30 * C7 + 29 * C8 + 28 * C9 + 27 * C10 + 26 * C11 + 25 * C12 + 24 * C13 + 23 * C14 + 22 * C15 + 21 * C16 + 20 * C17 + 19 * C18 + 18 * C19 + 17 * C20 + 16 * C21 + 15 * C22 + 14 * C23 + 13 * C24 + 12 * C25 + 11 * C26 + 10 * C27 + 9 * C28 + 8 * C29 + 7 * C30 + 6 * C31 + 5 * C32 + 4 * C33 + 3 * C34 + 2 * C35 + C36 - C38 - 2 * C39 - 3 * C40 - 4 * C41 - 5 * C42 - 6 * C43 - 7 * C44 - 8 * C45 - 9 * C46 - 10 * C47 - 11 * C48 - 12 * C49 - 13 * C50 - 14 * C51 - 15 * C52 - 16 * C53 - 17 * C54 - 18 * C55 - 19 * C56 - 20 * C57 - 21 * C58 - 22 * C59 - 23 * C60 - 24 * C61 - 25 * C62 - 26 * C63 - 27 * C64 - 28 * C65 - 29 * C66 - 30 * C67 - 31 * C68 - 32 * C69 - 33 * C70 - 34 * C71 - 35 * C72 - 36 * C73 - 37 * C74) / 35150
An Indicator Formula for the slope of a 25-Period Linear Regression Line could be written as:
(12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 5/9/2011 Posts: 80
|
Bruce,
Your service is simply the Best... Thank you,
Jim
|
|
Registered User Joined: 12/5/2007 Posts: 29
|
Dear Trainer
Using the example
An Indicator Formula for the slope of a 25-Period Linear Regression Line could be written as:
(12 * C + 11 * C1 + 10 * C2 + 9 * C3 + 8 * C4 + 7 * C5 + 6 * C6 + 5 * C7 + 4 * C8 + 3 * C9 + 2 * C10 + C11 - C13 - 2 * C14 - 3 * C15 - 4 * C16 - 5 * C17 - 6 * C18 - 7 * C19 - 8 * C20 - 9 * C21 - 10 * C22 - 11 * C23 - 12 * C24) / 1300
1. How is the divisor calculated for this or any other period.
2.In above example and other lenths of Linerar regression can other functions be substuted for C such as L, Min, MAX, AVG, XAVG,XAVG(XAVGC10,).
Hope I made myself clear, not a math guy.
Thank You, at your convience
Jeff
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis topic referenced in my first post explores the calculations of the divisor in the formula in a variety of ways. The most succinct would probably be a formula given in bustermu's Tuesday, April 04, 2006 12:12:34 PM ET post in the topic (the post itself is not short, but the formula is).
P*(P^2-1)/12
So we would get:
25 * (25 ^ 2 - 1) / 12
25 * (625 - 1) / 12
25 * 624 / 12
15600 / 12
1300
Yes, you can in general substitute other bars ago versions of indicators into the linear regression slope formula besides C to get the linear regression slope of something other than closing prices. The exact details of doing so would depend on the specific indicator for which you wanted to create a linear regression slope formula. In some cases, the resulting formula would be too long and slow to be practical or post in the forums.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/5/2007 Posts: 29
|
Bruce
Thank you very much, I did read the post, just a little too overwhelming for me
This helps,P*(P^2-1)/12
I'll figure the rest out on my own, there is enought information, for me to run with.
Best to You
Jeff
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |