OK, so how do I fix it? Do I have to write some code that will calculate a least squares regression from scratch? I think that will be really hairy to try to figure out. Are there any examples of formulas written to do the same thing or something similar? None of the linearreg formulas on the AB website helped.
--- In [email protected], "Fred" <[EMAIL PROTECTED]> wrote: > > From the doc ... > > SYNTAX LinRegIntercept( ARRAY, periods ) > > RETURNS ARRAY > > --- In [email protected], "Charles J. Dudek" <trader@> > wrote: > > > > And how do I fix it. I'm getting a type mismatch error, but I > can't > > see where I'm trying to put an entire array into one cell. > > > > aL[i] = LinRegIntercept( C [i] , Longcount[i] ); > > > > Does LinRegIntercept create an array? If so, how do I get around > > that? I'm trying to create trendlines at various points throughout > > the history that start and end based on other calculations. This > is > > driving me CRAZY!!! > > > > Are there any examples of this kind of thing I could refer to? I > know > > I could use LineArray, but I also need to calculate standard > > deviations based on the same periods, so I don't think that will > help > > me, will it? > > > > Chuck > > >
