V. 21:10 (42-49): Sidebar: Calculating Offset Correlation, OSC1 by Norman J. Brown
Product Description
Sidebar: Calculating Offset Correlation, OSC1 by Norman J. Brown
The well-known Pearson’s correlation coefficient r relates two series of parameters and yields a measure of the “likeness” of those two series. It can be informative in comparing two mutual funds to see how similar they are to each other. Another way to use r is to compare one fund to itself by entering the rate of change (ROC) of the fund in column X and the same ROC in column Y, delayed one day (dropped down one cell in Excel). Using the Excel “CORREL” command (or for graphs, displaying a trendline) will result in an r coefficient that offers a comparison between the X series and Y series.
The well-known Pearson’s correlation coefficient r relates two series of parameters and yields a measure of the “likeness” of those two series. It can be informative in comparing two mutual funds to see how similar they are to each other. Another way to use r is to compare one fund to itself by entering the rate of change (ROC) of the fund in column X and the same ROC in column Y, delayed one day (dropped down one cell in Excel). Using the Excel “CORREL” command (or for graphs, displaying a trendline) will result in an r coefficient that offers a comparison between the X series and Y series.
FOR THOSE ORDERING ARTICLES SEPARATELY:
*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.
| Take Control of Your Trading. |
| Professional Traders' Starter Kit |
| All these items shown below only $299.99! |
| Click Here to Order |