Hmm... BTW, what's the difference between a simple MA and a Linear regression... From a practical point of view? They look very much alike when plotted!
Thanks again! Louis 2008/9/5 Louis P. <[EMAIL PROTECTED]> > @Tomasz: I plotted this code on a 2-minute chart, and unfortunately half > the result was 1.#INF On a daily chart, however, got results between 0 and > 2. Still wondering how to use this stuff, but thanks anyway. > > @Ara: I will work on your step 4 and 5. I know nothing about how to use > LinearReg so that will be lot of fun I guess. But that's a good place to > start I believe and thank you for your help. I just don't know yet how to > incorporate the linear reg and the C<0.9*HHV part to be honest. But I will > try... > > > Thanks, > > Louis > > 2008/9/5 Ara Kaloustian <[EMAIL PROTECTED]> > >> I think the best solution would come from linear regression ... along >> with some help from smoothing perhaps. >> >> The concept would be that you first qualify a setup. >> Exapmle: >> You want 10% drop from HHV in a particular amount of time ... maximum >> number of bars. (MinBars to MaxBars) >> >> 1. Close < 0.9 * HHV(High,Maxbars); // 10 % drop in less then >> Numbars bars >> 2. BarsPast = HHVBars(High,Maxbars); // Bars since HHV >> 3. MinBars < BarsPast; // Insure that a minimum >> number of bars since HHV >> 4. Draw regression line - Plot(LinearReg(array,period) .... ) >> 5. Evaluate slope of regression line >> slope = RL - Ref(RL,-1) / Ref(RL,-1); // Slope at any point on the >> line >> 6. You can decide how to alternately evaluate to slope .... max or min >> slope value ...etc >> >> You may also use a smoothed price array instead of actual prices by using >> price = (H+L+C+O) / 4 or (H+L) / 2 . >> >> Hope this gets you closer to your objective. >> >> >> ----- Original Message ----- >> *From:* Louis P. <[EMAIL PROTECTED]> >> *To:* [email protected] >> *Sent:* Friday, September 05, 2008 11:00 AM >> *Subject:* Re: [amibroker] How to calculate a slope % with Rsquared >> without a loop? >> >> Hi, >> >> @Joe Landry: Thanks for the tips. I'm not sure how the K-ratio can help >> on this, but if it can help... >> >> @Ara: I'm sorry if what I said was not clear. What I want to do is to >> calculate a % pullback from a HHV of a stock but I want the slope to be >> "smooth", that is, I am not happy to see a 5 or 10% pullback but would like >> to see a 5 or 10% pullback with a particular slope inclination. That is: >> if the stock dropped 10% in a day is not the same as if it quietly lost 0.5% >> for 20 days (would not be exactly 10%, but this is an image). You >> understand what I mean? I want the slope to be as smooth as possible with a >> particular inclation %. Is this possible? >> >> Thanks, >> >> Louis >> >> >> >> 2008/9/5 Ara Kaloustian <[EMAIL PROTECTED]> >> >>> Louis, >>> >>> I am not quite sure what you mean by "a smooth slope". >>> >>> Do you want to have a plot of prices that are smoothed ... as you would >>> gt with a filter?? >>> >>> OR do you want a computed value of slope at some particular point? ... if >>> so at what point ... or do you want a plot of the slope ... etc >>> >>> If you can be moe specific that would be halpful! >>> >>> A >>> >>> ** >>> >>> >>> ----- Original Message ----- >>> *From:* Louis P. <[EMAIL PROTECTED]> >>> *To:* [email protected] >>> *Sent:* Friday, September 05, 2008 8:41 AM >>> *Subject:* Re: [amibroker] How to calculate a slope % with Rsquared >>> without a loop? >>> >>> Hi, >>> >>> Linear function is my big problem. I'm so weak using that. What is the >>> difference between using this and doing it the other way? >>> >>> BTW, how would you set the number of bars in the current: >>> >>> HHVBars(Var,period); // Find number of bars - distance from HHV to >>> current bar >>> %slope = ((Highest high - currentclose) / Highest high) / number of bars >>> * 100; >>> >>> Thanks, >>> >>> Louis >>> >>> >>> 2008/9/4 Ara Kaloustian <[EMAIL PROTECTED]> >>> >>>> You can also use linearray to draw a stright line from HHV to >>>> current point. >>>> >>>> Look up LinearReg function >>>> >>>> ----- Original Message ----- >>>> *From:* Ara Kaloustian <[EMAIL PROTECTED]> >>>> *To:* [email protected] >>>> *Sent:* Thursday, September 04, 2008 10:37 AM >>>> *Subject:* Re: [amibroker] How to calculate a slope % with Rsquared >>>> without a loop? >>>> >>>> Try this: >>>> >>>> HHV(Var,period); // find value of highest high >>>> HHVBars(Var,period); // Find number of bars - distance from HHV to >>>> current bar >>>> %slope = ((Highest high - currentclose) / Highest high) / number of bars >>>> * 100; >>>> >>>> You may choose to define slope in a different way, but this is the basic >>>> structure >>>> >>>> A >>>> >>>> ----- Original Message ----- >>>> *From:* Louis P. <[EMAIL PROTECTED]> >>>> *To:* [email protected] >>>> *Sent:* Thursday, September 04, 2008 9:34 AM >>>> *Subject:* Re: [amibroker] How to calculate a slope % with Rsquared >>>> without a loop? >>>> >>>> Hi, >>>> >>>> Thanks for your response. I should have said I want to calculate a >>>> slope from a high point; I'd like to get a smooth slope from a HHV... How >>>> would you do that? >>>> >>>> Thanks a lot! >>>> Louis >>>> >>>> 2008/9/4 Ara Kaloustian <[EMAIL PROTECTED]> >>>> >>>>> %slope = (variable - Ref(Variable,-x) ) / Ref(Variable,-x) * 100; >>>>> >>>>> ----- Original Message ----- >>>>> *From:* Louis P. <[EMAIL PROTECTED]> >>>>> *To:* [email protected] >>>>> *Sent:* Thursday, September 04, 2008 9:20 AM >>>>> *Subject:* [amibroker] How to calculate a slope % with Rsquared >>>>> without a loop? >>>>> >>>>> Hi, >>>>> >>>>> I was wondering how to calculate the % of a slope without doing any >>>>> loop. Anybody has any idea? >>>>> >>>>> Thanks, >>>>> >>>>> Louis >>>>> >>>>> >>>> >>> >> >> > >
