[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Excel help (again)



PureBytes Links

Trading Reference Links

Well, if the classic method is to take the difference between the data point
and your measure of trend (moving average, line fit, etc.) and divide that
by the running standard deviation at that point.

You can take a look at Excel's TREND() function and the STDEV() function.

>
> Thanks Gary. Got it working. Any ideas how to construct different
> categories for values away from a trendline? I'm trying to come up with
> a way that (arbitrarily) measures the (in)significance of values from
> the trendline.