|
Hi Bruce,
The other day you helped me with writing code to determine the slope of Linear Regression lines applied to moving averages. This methodology has worked out well.... Yet, can you apply slope criteria like a slope of "1" which would imply a 45 degree slope? Does this type of thinking work given the units we are trying to applying a graphical representation to chart image?
thanks Jim
|
|
Hi Bruce,
Can you help me with calculating the slope of a moving average using Linear Regression?
For instance, can we determine the slope of a 200 SMA for a 30 period and 180 periods and the same thing for 20 SMA 15 and 30 periods?
If the 180 periods is too long for the 200 SMA to calculate that slope, then we can convert that calculation using weeks...
Thanks, Jim
|
|
Thanks Bruce...very much appreciate all that you do- Jim
|
|
Bruce,
Much work for the weekend... Can you help me with an equation for RSI... need the equation for RSI both in Value and Linear Regression for a period of 9 and 18 periods. Plus, do you have the equation to calcuation the XAVG too again on a 9 period? It would be great if you could just post the equations so I have all weekend to work on fine tunning for correlating with imagery of the charts... the previous help you supplied for PPO and the offset feature is working well. Thank you much appreciate for that! Jim
|
|
Interesting how the values returned when using LR as Indicator do not feel right relative to the visual. I realize scaling of the various axis will affect the numerical values vs the visual... Jim
|
|
Bruce, the formulas below are for calculating the Linear Regression Slope values for periods of 83, 74, and 24... If we look specifically at the slope values of each equation, are the values of the slope equivalent to standard slope value calculations for standard linear lines that are typically expressed as y= mx + b where m is the slope? Thanks, Jim
(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 <
(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
AND
(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 <
(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
|
|
Thank you Bruce ... work to do this evening. Simply finding the geometrical patterns you need although many tools available, not always possible. Jim
|
|
Conditions created by clicking on an indicator and selecting Create Scan Condition are for the current bar. You can add 1 period moving average to the indicator, set the Offset of the moving average to the number of bars ago of interest and selecting Create Scan Condition to check for the condition being true offset bars ag
Can you supply and example of this methodology using the Create Scan Feature?
Thank you, Jim
|
|
And, is moving up and moving down smart a slope calculation? Or, is there more logic built into that condition? Thanks, Jim
|