download multi stock DOW

Document Sample
download multi stock DOW Powered By Docstoc
					 1
 2
 3
 4
 5
 6

 **

 **




Note:


Note:




Note:


Note:


P.S.
Type in a bunch of stock symbols, in column A of the Download sheet.
Type in an End date in cell B3 of the Download sheet.
Enter a bunch of calculations** (based upon the downloaded data) in cells O6 to Z6 of the Download sheet.
Enter some explanatory headings in cells N5 to Z5.
Click the Download button on the Download sheet.
Pray … then see your calculations for each stock that you entered on the Calculations sheet.

You can use the space to the right of column O and below row 6 to aid your calculations


Sample calculations:
=AVERAGE(INDEX($I$8:$I$600,$I$1):INDEX($I$8:$I$600,$I$1-O$5))                            gives the 20-day moving average
=INDEX(I8:I600,I1)         gives the closing price
=(INDEX(I8:I600,I1)/I8)^((MAX(C8:C600)-C8)/365)-1                  gives the Compound Annual Growth Rate
=STDEVP(M8:M600)*SQRT(I1)                 gives the "annualized" volatility

Invent your own thing and stick the formula into one of the cells O6 to Z6, along with some h
When the smoke has cleared, your calculations will show up on the Calculations sheet
… along with your headings.


If Yahoo doesn't have a year's worth of stock data, you're screwed in trouble !!
The downloading will stop ...


If'n you're lucky, you can enter hundreds of stock symbols in column A.
Maybe the components of the S&P500 ? The current entries are from XIU.TO on the TSE.

However, if you want the Stock Names, you're limited to about 200 stocks.

The chart doesn't (necessarily) show the stock named on the chart. That name is the stock currently being downloade
When the smoke has cleared, then the name and the chart are consistent.


You may also want to download some Market data first, then compare the other stocks.
When you download the Market, the returns are stored in column O for your use … like calculating Beta (or whatever) as each of the other stocks are downlo

Tho' most of the calculation cells, O6 to Z6, are used by this spreadsheet, you can change any or all.
nload sheet.




, along with some headings in row 5.
ions sheet




rently being downloaded !!




h of the other stocks are downloaded.
                                               31                      stocks                                                                                                                                                   250
        Start:    13-Sep-11                                                 ^DJI                                                                                                                                         12915
   End:          12-Sep-12                  ^DJI                    Downloading ^DJI                                                                                                                                     10599
 Stock:             ^DJI                         d




Stocks                                      Date                           Open                            High                        Low                        Close                       Volume                 Adj Close

 PFE
                                          ^DJI
                                          13-Mar-06                   11067.61                   11157.82                        11019.75                        11076.02                  2,070,330,000             11076.02
  VZ                                      14-Mar-06                   11076.02                   11190.96                        11030.23                        11151.34                  2,165,270,000             11151.34
 MO                                       15-Mar-06                   11149.76                   11258.28                        11097.23                        11209.77                  2,293,000,000             11209.77
  T                                       16-Mar-06                   11210.97                     11324.8                       11176.07                        11253.24                  2,292,180,000             11253.24
                 $12,599.00
  C                                       17-Mar-06                   11294.94                   11294.94                        11253.23                        11279.65                  2,549,620,000             11279.65
 MRK                                      20-Mar-06                   11278.93                   11350.73                        11208.33                        11274.53                  1,976,830,000             11274.53
 GM                                       21-Mar-06                   11275.89                   11364.34                        11188.56                        11235.47                  2,147,370,000             11235.47
  DD                                      22-Mar-06                   11234.51                   11358.01                        11200.22                        11317.43                  2,039,810,000             11317.43
  GE                                      23-Mar-06                   11317.35                   11363.46                        11207.85                        11270.29                  1,980,940,000             11270.29
 JPM                                      24-Mar-06                   11270.61                   11353.21                        11197.21                        11279.97                  2,326,070,000             11279.97
  KO             $12,099.00               27-Mar-06                   11280.13                   11314.96                        11194.07                        11250.11                  2,029,700,000             11250.11
 MMM                                      28-Mar-06                   11250.11                   11312.31                        11132.05                        11154.54                  2,148,580,000             11154.54
 JNJ                                      29-Mar-06                   11154.94                   11283.97                        11117.48                        11215.7                   2,143,540,000              11215.7
 MCD                                      30-Mar-06                   11195.36                   11259.08                        11118.12                        11150.7                   2,294,560,000              11150.7
  HD                                      31-Mar-06                   11151.34                   11229.47                        11069.78                        11109.32                  2,236,710,000             11109.32
 HON                                      3-Apr-06                       11113                   11287.02                        11101.07                        11144.94                  2,494,080,000             11144.94
  AA                                      4-Apr-06                    11142.54                   11269.17                        11094.03                        11203.85                  2,147,660,000             11203.85
 INTC            $11,599.00               5-Apr-06                    11203.21                     11290.3                       11141.82                        11239.55                  2,420,020,000             11239.55
 CAT                                      6-Apr-06                    11233.01                     11294.3                       11137.57                        11216.5                   2,281,680,000              11216.5
  PG                                      7-Apr-06                     11228.1                   11268.92                        11108.75                        11120.04                  2,082,470,000             11120.04
 UTX                                      10-Apr-06                   11119.88                   11211.37                        11083.06                        11141.33                  1,898,320,000             11141.33
 XOM                                      11-Apr-06                   11141.33                   11220.98                        11017.99                        11089.63                  2,232,880,000             11089.63
  BA                                      12-Apr-06                   11089.47                        11194                      11052.17                        11129.97                  1,938,100,000             11129.97
 WMT                                      13-Apr-06                   11130.13                   11210.73                        11053.29                        11137.65                  1,891,940,000             11137.65
                 $11,099.00
 MSFT                                     17-Apr-06                   11137.33                   11203.13                        11017.43                        11073.78                  1,794,650,000             11073.78
 IBM                                      18-Apr-06                   11074.58                     11302.3                       11064.01                        11268.77                  2,595,440,000             11268.77
 AXP                                      19-Apr-06                    11265.4                   11379.79                        11181.84                        11278.77                  2,447,310,000             11278.77
 AIG                                      20-Apr-06                   11278.53                   11429.25                             11221.3                    11342.89                  2,512,920,000             11342.89
 DIS                                      21-Apr-06                   11343.45                   11468.16                        11272.61                        11347.45                  2,392,630,000             11347.45
 HPQ                                      24-Apr-06                   11346.81                   11420.05                        11246.35                        11336.32                  2,117,330,000             11336.32
 ^DJI            $10,599.00               25-Apr-06                   11336.56                   11401.32                        11213.05                        11283.25                  2,366,380,000             11283.25
                                                                                                              11-Jun-06

                                                                                                                          26-Jun-06




                                                                                                                                                                   10-Aug-06

                                                                                                                                                                               25-Aug-06

                                                                                                                                                                                              9-Sep-06

                                                                                                                                                                                                         24-Sep-06
                                                                                                                                         11-Jul-06

                                                                                                                                                     26-Jul-06




                                                                                                                                                                                                                                      24-Oct-06
                                                        12-Apr-06

                                                                       27-Apr-06




                                                                                                                                                                                                                     9-Oct-06
                              13-Mar-06

                                            28-Mar-06




                                                                                               27-May-06
                                                                                   12-May-06




                                                                                                                                                                                                                                                  8-Nov-06


                                          26-Apr-06                   11283.25                   11428.77                        11256.12                        11354.49                  2,502,690,000             11354.49
                                          27-Apr-06                   11349.53                   11465.75                        11220.74                        11382.51                  2,772,010,000             11382.51
                                          28-Apr-06                   11358.33                   11462.95                        11278.13                        11367.14                  2,419,920,000             11367.14
                                          1-May-06                    11367.78                   11476.96                             11304.3                    11343.29                  2,437,040,000             11343.29
                                          2-May-06                    11372.74                   11427.43                        11343.28                        11416.44                  2,403,470,000             11416.44
                                          3-May-06                    11414.69                   11472.96                        11308.55                        11400.28                  2,395,230,000             11400.28
                                          4-May-06                     11401.8                   11512.18                        11366.82                        11438.86                  2,431,450,000             11438.86
                                          5-May-06                    11440.62                   11616.16                        11440.62                        11577.74                  2,294,760,000             11577.74
                                          8-May-06                    11576.37                   11665.14                        11504.09                        11584.54                  2,151,300,000             11584.54
                                          9-May-06                    11584.62                   11684.28                        11535.71                        11639.77                  2,157,290,000             11639.77
                                          10-May-06                   11630.48                   11709.09                        11545.64                        11642.65                  2,268,550,000             11642.65
                                          11-May-06                   11639.29                   11660.58                        11449.74                        11500.73                  2,531,520,000             11500.73
                                          12-May-06                   11500.01                     11551.4                       11336.96                        11380.99                  2,567,970,000             11380.99
15-May-06   11380.43   11485.61   11273.65   11428.77   2,505,660,000   11428.77
16-May-06   11428.21   11520.42   11334.64   11419.89   2,386,210,000   11419.89
17-May-06   11410.13   11412.28   11139.17   11205.61   2,830,200,000   11205.61
18-May-06   11206.17   11301.26   11096.35   11128.29   2,537,490,000   11128.29
19-May-06   11124.37   11254.6    11009.98   11144.06   2,982,300,000   11144.06
22-May-06   11092.9    11175.03   11040.16   11125.32   2,773,010,000   11125.32
23-May-06   11126.29   11254.68   11068.49   11098.35   2,605,250,000   11098.35
24-May-06   11100.11   11241.15   10980.29   11117.32   2,999,030,000   11117.32
25-May-06   11114.96   11258.12   11089.55   11211.05   2,372,730,000   11211.05
26-May-06   11211.69   11329.36   11177.43   11278.61   1,814,020,000   11278.61
30-May-06   11277.25   11277.25   11071.7    11094.43   2,176,190,000   11094.43
31-May-06   11091.15   11225.78   11050.4    11168.31   2,692,160,000   11168.31
1-Jun-06    11169.03   11290.86   11115.4    11260.28   2,360,160,000   11260.28
2-Jun-06    11260.52   11329.28   11158.06   11247.87   2,295,540,000   11247.87
5-Jun-06    11247.55   11259.96   11025.75   11048.72   2,313,470,000   11048.72
6-Jun-06    11048.24   11140.45   10890.24   11002.14   2,697,650,000   11002.14
7-Jun-06    11002.06   11107.48   10897.76   10930.9    2,644,170,000   10930.9
8-Jun-06    10929.7    11032.15   10726.15   10938.82   3,543,790,000   10938.82
9-Jun-06    10939.14   11015.67   10842.89   10891.92   2,214,000,000   10891.92
12-Jun-06    10892     10969.32   10767.61   10792.58   2,247,010,000   10792.58
13-Jun-06   10783.14   10893.04   10653.23   10706.14   3,215,770,000   10706.14
14-Jun-06   10713.1    10816.99   10699.25   10816.91   2,667,990,000   10816.91
15-Jun-06   10817.48   11049.85   10788.34   11015.19   2,775,480,000   11015.19
16-Jun-06   11009.1    11045.04   10984.29   11014.54   2,783,390,000   11014.54
19-Jun-06   11014.87   11098.99   10886.63   10942.11   2,517,200,000   10942.11
20-Jun-06   10942.03   11066.73   10895.28   10974.84   2,232,950,000   10974.84
21-Jun-06   10975.24   11165.91   10952.43   11079.46   2,361,230,000   11079.46
22-Jun-06   11077.78   11127.73   10954.83   11019.11   2,148,180,000   11019.11
23-Jun-06   11019.19   11098.67   10932.82   10989.09   2,017,270,000   10989.09
26-Jun-06   10990.29   11089.07   10937.06   11045.28   1,878,580,000   11045.28
27-Jun-06   11048.24   11064.09   10920.73   10924.74   2,203,130,000   10924.74
28-Jun-06   10925.3    11026.07   10869.02   10973.56   2,085,490,000   10973.56
29-Jun-06   10974.36   11225.06   10974.36   11190.8    2,621,250,000   11190.8
30-Jun-06   11190.8    11288.86   11100.11   11150.22   3,049,560,000   11150.22
 3-Jul-06   11149.34   11277.09   11146.06   11228.02   1,114,470,000   11228.02
 5-Jul-06   11225.06   11239.47   11083.94   11151.82   2,165,070,000   11151.82
 6-Jul-06   11147.12   11301.58   11117.16   11225.3    2,009,160,000   11225.3
 7-Jul-06   11224.18   11227.62   11040.32   11090.67   1,988,150,000   11090.67
10-Jul-06   11130.53   11174.47   11090.1    11103.55   1,854,590,000   11103.55
11-Jul-06   11102.59   11186.32   10987.33   11134.77   2,310,850,000   11134.77
12-Jul-06   11133.97   11181.12   10973.37   11013.18   2,250,450,000   11013.18
13-Jul-06   11012.62   11015.19   10790.82   10846.29   2,545,760,000   10846.29
14-Jul-06   10846.53   10892.64   10664.43   10739.35   2,467,120,000   10739.35
17-Jul-06   10739.35   10858.22   10668.35   10747.36   2,146,410,000   10747.36
18-Jul-06   10745.84   10867.02   10658.35   10799.23   2,481,750,000   10799.23
19-Jul-06   10854.22   11038.16   10796.74   11011.42   2,701,980,000   11011.42
20-Jul-06   11007.26   11098.75   10884.47   10928.1    2,345,580,000   10928.1
21-Jul-06   10937.94   10995.73   10778.58   10868.38   2,704,090,000   10868.38
24-Jul-06   10868.7    11096.35   10868.7    11051.05   2,312,720,000   11051.05
25-Jul-06   11037.59   11133.73   11000.05   11103.71   2,563,930,000   11103.71
26-Jul-06   11102.91   11208.09   10987.41   11102.51   2,667,710,000   11102.51
27-Jul-06   11104.19   11245.47   11040.8    11100.43   2,776,710,000   11100.43
28-Jul-06   11102.11   11282.05   11102.11   11219.7    2,480,420,000   11219.7
31-Jul-06   11218.9    11265.8    11115.24   11185.68   2,461,300,000   11185.68
1-Aug-06    11184.8    11210.65   11035.92   11125.73   2,527,690,000   11125.73
2-Aug-06    11167.91   11228.98   11124.52   11199.92   2,610,750,000   11199.92
3-Aug-06    11195.28   11304.78   11101.55   11242.59   2,728,440,000   11242.59
4-Aug-06    11244.59   11367.94   11165.11   11240.35   2,530,970,000   11240.35
7-Aug-06    11239.47   11294.14   11143.02   11219.38   2,045,660,000   11219.38
8-Aug-06    11218.18   11319.51   11117.8    11173.59   2,457,840,000   11173.59
9-Aug-06    11168.47   11296.22   11044.64   11076.18   2,555,180,000   11076.18
10-Aug-06   11073.14   11176.47   10998.06   11124.37   2,402,190,000   11124.37
11-Aug-06   11103.55   11121.4    11042.88   11088.02   2,004,540,000   11088.02
14-Aug-06   11089.07   11242.83   11049.68   11097.87   2,118,020,000   11097.87
15-Aug-06   11098.03   11271.25   11098.03   11230.26   2,334,100,000   11230.26
16-Aug-06   11224.91   11373.78   11207.85   11327.12   2,554,570,000   11327.12
17-Aug-06   11321.19   11372.34   11298.54   11334.96   2,458,340,000   11334.96
18-Aug-06   11333.76   11437.66   11273.49   11381.47   2,033,910,000   11381.47
21-Aug-06   11353.29   11381.46   11322.31   11345.04   1,759,240,000   11345.04
22-Aug-06   11344.41   11426.13   11279.25   11339.84   1,908,740,000   11339.84
23-Aug-06   11337.12   11394.75   11238.67   11297.9    1,893,670,000   11297.9
24-Aug-06   11297.82   11386.59   11232.83   11304.46   1,930,320,000   11304.46
25-Aug-06   11301.22   11350.09   11218.66   11284.05   1,667,580,000   11284.05
28-Aug-06   11285.33   11411.24   11240.91   11352.01   1,834,920,000   11352.01
29-Aug-06   11352.65   11432.38   11255.88   11369.94   2,093,720,000   11369.94
30-Aug-06   11365.98   11452.95   11309.99   11382.91   2,060,690,000   11382.91
31-Aug-06   11383.47   11451.03   11326.8    11381.15   1,974,540,000   11381.15
1-Sep-06    11427.41   11476.4    11381.14   11464.15   1,800,520,000   11464.15
5-Sep-06    11461.83   11533.87   11385.95   11469.28   2,114,480,000   11469.28
6-Sep-06    11421.33   11469.27   11395.15   11406.2    2,329,870,000   11406.2
7-Sep-06    11405.16   11443.66   11273.89   11331.44   2,325,850,000   11331.44
8-Sep-06    11332.24   11448.3    11295.18   11392.11   2,132,890,000   11392.11
11-Sep-06   11389.87   11468.88   11295.9    11396.84   2,506,430,000   11396.84
12-Sep-06   11412.52   11512.74   11396.83   11498.09   2,791,580,000   11498.09
13-Sep-06   11487.69   11605.59   11423.73   11543.32   2,597,220,000   11543.32
14-Sep-06   11508.82   11548.84   11495.77   11527.39   2,351,220,000   11527.39
15-Sep-06   11528.75   11661.38   11504.57   11560.77   3,198,030,000   11560.77
18-Sep-06   11538.35   11588.22   11528.43    11555     2,325,080,000    11555
19-Sep-06   11554.6    11605.67   11450.3    11540.91   2,390,850,000   11540.91
20-Sep-06   11542.28   11680.19   11514.5    11613.19   2,543,070,000   11613.19
21-Sep-06   11611.67   11677.39   11471.76   11533.23   2,627,440,000   11533.23
22-Sep-06   11532.91   11588.62   11423.57   11508.1    2,162,880,000   11508.1
25-Sep-06   11536.67   11616.23    11486     11575.81   2,710,240,000   11575.81
26-Sep-06   11575.73   11723.74   11517.54   11669.39   2,673,350,000   11669.39
27-Sep-06   11670.19   11775.6    11595.75   11689.24   2,749,190,000   11689.24
28-Sep-06   11689.4    11775.36   11625.92   11718.45   2,397,820,000   11718.45
29-Sep-06   11718.05   11782.49   11642.17   11679.07   2,273,430,000   11679.07
2-Oct-06    11678.99   11773.6    11608.79   11670.35   2,154,480,000   11670.35
3-Oct-06    11670.11   11794.41   11608.23   11727.34   2,682,690,000   11727.34
4-Oct-06    11722.94   11879.18   11654.02   11850.61   3,019,880,000   11850.61
5-Oct-06    11832.51   11869.33   11821.55   11866.69   2,817,240,000   11866.69
6-Oct-06    11865.49   11921.04   11743.35   11850.21   2,523,000,000   11850.21
9-Oct-06    11849.56   11923.53   11759.36   11857.81   1,935,170,000   11857.81
10-Oct-06   11857.73   11930.33   11778.09   11867.17   2,376,140,000   11867.17
11-Oct-06   11865.49   11907.6    11762.72   11852.13   2,521,000,000   11852.13
12-Oct-06   11896.63   11959.14   11852.12   11947.7    2,514,350,000   11947.7
13-Oct-06   11947.22   12009.97   11862.29   11960.51   2,482,920,000   11960.51
16-Oct-06   11957.7    11996.92   11945.7    11980.59   2,305,920,000   11980.59
17-Oct-06   11977.4    12024.54   11849.16   11950.02   2,519,620,000   11950.02
18-Oct-06   11947.62   12108.91   11900.79   11992.68   2,658,840,000   11992.68
19-Oct-06   11988.92   12082.33   11911.44   12011.73   2,619,830,000   12011.73
20-Oct-06   12013.01   12087.38   11881.34   12002.37   2,526,410,000   12002.37
23-Oct-06   12001.33   12177.35   11940.41   12116.91   2,480,430,000   12116.91
24-Oct-06   12116.51   12204.8    12028.14   12127.88   2,876,890,000   12127.88
25-Oct-06   12127.24   12212.16   12017.66   12134.68   2,953,540,000   12134.68
26-Oct-06   12134.84   12236.1    12037.99   12163.66   2,793,350,000   12163.66
27-Oct-06   12164.78   12202.72   12024.78   12090.26   2,458,450,000   12090.26
30-Oct-06   12074.01   12117.07   12050.23   12086.49   2,770,440,000   12086.49
31-Oct-06   12086.18   12160.46   11986.84   12080.73   2,803,030,000   12080.73
1-Nov-06    12080.25   12160.7    11972.99   12031.02   2,821,160,000   12031.02
2-Nov-06    12023.98   12070.25   11938.89   12018.54   2,646,180,000   12018.54
3-Nov-06    12018.3    12095.3    11928.97   11986.04   2,419,730,000   11986.04
6-Nov-06    11985.16   12146.45   11973.23   12105.55   2,533,550,000   12105.55
7-Nov-06    12104.75   12239.94   12065.2    12156.77   2,636,390,000   12156.77
8-Nov-06    12147.38   12233.54   12051.6    12176.54   2,814,820,000   12176.54
9-Nov-06    12174.7    12236.1    12039.59   12103.3    3,012,050,000   12103.3
10-Nov-06   12102.74   12173.08   12074.01   12108.43   2,290,200,000   12108.43
13-Nov-06   12084.89   12164.22   12084.89   12131.88   2,386,340,000   12131.88
14-Nov-06   12132.44   12261.15   12051.68   12218.01   3,027,480,000   12218.01
15-Nov-06   12214.37   12326.07   12156.37   12251.71   2,831,130,000   12251.71
16-Nov-06   12250.05   12375.37    12204     12305.82   2,835,730,000   12305.82
17-Nov-06   12293.49   12342.55   12278.2    12342.55   2,726,100,000   12342.55
20-Nov-06   12340.71   12400.1    12257.34   12316.54   2,546,710,000   12316.54
21-Nov-06   12312.13   12409.31   12233.94   12321.59   2,597,940,000   12321.59
22-Nov-06   12321.91   12403.54   12238.43   12326.95   2,237,710,000   12326.95
24-Nov-06   12321.71   12340.89   12219.28   12280.17   832,550,000     12280.17
27-Nov-06   12279.13   12303.32   12079.01   12121.71   2,711,210,000   12121.71
28-Nov-06   12095.27   12148.78   12073.4    12136.44   2,639,750,000   12136.44
29-Nov-06   12134.4    12283.05   12119.7    12226.73   2,790,970,000   12226.73
30-Nov-06   12226.73   12317.1    12118.42   12221.93   4,006,230,000   12221.93
1-Dec-06    12220.97   12289.3    12070.52   12194.13   2,800,980,000   12194.13
4-Dec-06    12195.57   12349.87   12149.27   12283.85   2,766,320,000   12283.85
5-Dec-06    12283.69   12398.57   12218.24   12331.6    2,755,700,000   12331.6
6-Dec-06    12328.72   12390.88   12239.95   12309.25   2,725,280,000   12309.25
7-Dec-06    12310.13   12396.33   12233.06   12278.41   2,743,150,000   12278.41
8-Dec-06    12256.21   12332.16   12243.31   12307.48   2,440,460,000   12307.48
11-Dec-06   12306.21   12399.54   12245.32   12328.48   2,289,900,000   12328.48
12-Dec-06   12328.24   12396.01   12222.65   12315.58   2,738,170,000   12315.58
13-Dec-06   12312.71   12411.55   12263.19   12317.5    2,552,260,000   12317.5
14-Dec-06   12317.5    12472.76   12271.44   12416.76   2,729,700,000   12416.76
15-Dec-06   12417.96   12536.37   12377.35   12445.52   3,229,580,000   12445.52
18-Dec-06   12446.24   12545.74   12372.3    12441.27   2,568,140,000   12441.27
19-Dec-06   12439.51   12517.78   12348.5    12471.32   2,717,060,000   12471.32
20-Dec-06   12471.32   12549.35   12393.45   12463.87   2,387,630,000   12463.87
21-Dec-06   12461.62   12526.59   12369.97   12421.25   2,322,410,000   12421.25
22-Dec-06   12407.87   12417.96   12341.77   12343.21   1,647,590,000   12343.21
26-Dec-06   12341.94   12439.19   12301.4    12407.63   1,310,310,000   12407.63
27-Dec-06   12463.46   12518.34   12407.62   12510.57   1,667,370,000   12510.57
28-Dec-06   12510.57   12566.17   12440.23   12501.52   1,508,570,000   12501.52
29-Dec-06   12500.48   12560.16   12423.81   12463.15   1,678,200,000   12463.15
3-Jan-07    12459.54   12630.34   12373.82   12474.52   3,429,160,000   12474.52
4-Jan-07    12467.32   12510.26   12405.47   12480.69   3,004,460,000   12480.69
5-Jan-07    12480.05   12504.4    12326.79   12398.01   2,919,400,000   12398.01
8-Jan-07    12393.93   12445.37   12337.53   12423.49   2,763,340,000   12423.49
9-Jan-07    12424.77   12516.66   12337.85   12416.6    3,038,380,000   12416.6
10-Jan-07    12417     12487.18   12313.01   12442.16   2,764,660,000   12442.16
11-Jan-07   12442.96   12586.12   12413.72   12514.98   2,857,870,000   12514.98
12-Jan-07   12514.66   12616.08   12432.3    12556.08   2,686,480,000   12556.08
16-Jan-07   12555.84   12638.27   12489.9    12582.59   2,599,530,000   12582.59
17-Jan-07   12563.53   12613.28   12550.95   12577.15   2,690,270,000   12577.15
18-Jan-07   12575.06   12674.16   12487.9    12567.93   2,822,430,000   12567.93
19-Jan-07   12567.93   12649.89   12462.5    12565.53   2,777,480,000   12565.53
22-Jan-07   12566.33   12619.04   12389.68   12477.16   2,540,120,000   12477.16
23-Jan-07   12467.96   12553.44   12467.96   12533.81   2,975,070,000   12533.81
24-Jan-07   12534.37   12659.42   12489.98   12621.77   2,783,180,000   12621.77
25-Jan-07   12621.77   12670.48   12461.54   12502.56   2,994,330,000   12502.56
26-Jan-07   12503.28   12582.67   12391.44   12487.02   2,626,620,000   12487.02
29-Jan-07   12487.1    12599.74   12422.93   12490.78   2,730,480,000   12490.78
30-Jan-07   12484.7    12538.06   12463.07   12523.31   2,706,250,000   12523.31
31-Jan-07   12520.03   12685.54   12461.3    12621.69   2,976,690,000   12621.69
1-Feb-07    12617.2    12741.3    12563.85   12673.68   2,914,890,000   12673.68
2-Feb-07    12673.84   12740.65   12582.99   12653.49   2,569,450,000   12653.49
5-Feb-07    12641.08   12681.06   12630.5    12661.75   2,439,430,000   12661.75
6-Feb-07    12661.66   12738.41   12586.44   12666.31   2,608,710,000   12666.31
7-Feb-07    12656.86   12748.99   12589.56   12666.87   2,618,820,000   12666.87
8-Feb-07    12639.16   12666.88   12576.59   12637.63   2,816,180,000   12637.63
9-Feb-07    12638.03   12725.59   12518.58   12580.83   2,951,810,000   12580.83
12-Feb-07   12595.9    12605.11   12536.77   12552.56   2,395,680,000   12552.56
13-Feb-07   12549.19   12702.36   12549.19   12654.85   2,652,150,000   12654.85
14-Feb-07   12676.97   12759.16   12650.69   12741.86   2,699,290,000   12741.86
15-Feb-07   12741.7    12828.38   12681.85   12765.01   2,490,920,000   12765.01
16-Feb-07   12764.13   12829.42   12685.86   12767.57   2,399,450,000   12767.57
20-Feb-07   12766.85   12845.76   12675.04   12786.64   2,337,860,000   12786.64
21-Feb-07   12782.87   12813.88   12662.79   12782.87   2,606,980,000   12782.87
22-Feb-07   12735.77   12792.97   12621.93   12686.02   1,950,770,000   12686.02
23-Feb-07   12679.89   12726.79   12578.51   12647.48   2,579,950,000   12647.48
26-Feb-07   12647.88   12746.34   12562.72   12632.26   2,822,170,000   12632.26
27-Feb-07   12628.9    12628.9    12078.85   12216.24   4,065,230,000   12216.24
28-Feb-07   12214.92   12396.81   12122.03   12268.63   3,925,250,000   12268.63
1-Mar-07    12265.59   12338.89   11996.17   12234.34   3,874,910,000   12234.34
2-Mar-07    12233.78   12293.15   12064.91   12114.1    3,312,260,000   12114.1
5-Mar-07    12111.61   12220.16   11973.58   12050.41   3,444,390,000   12050.41
6-Mar-07    12051.17   12252.61   12051.17   12207.59   3,358,160,000   12207.59
7-Mar-07    12204.46   12315.18   12122.11   12192.45   3,141,350,000   12192.45
8-Mar-07    12193.33   12355.47   12183.79   12260.7    3,014,850,000   12260.7
9-Mar-07    12262.06   12379.51   12200.62   12276.32   2,623,050,000   12276.32
                                                                                                            Put any calculations you like into the cells below: O6 to Z6
                                                                                                            They get moved to the Calculations sheet.


           ^GSPC                                                                                            Moving Averages                                      "Annual" Volume/
                                                                                     days =                    20         50         100    CLOSE       CAGR     Volatility     1000
                                                                                         ^DJI               ######## ######## ######## ########         10.71%    10.0%       2,623,050
             Date                    Adj Close               Returns                 Delayed                 Mkt Rtns

           13-Mar-06                 11076.02                0.08%                   Returns                  0.72%
           14-Mar-06                 11151.34                0.68%                    0.08%                   0.57%
           15-Mar-06                 11209.77                0.52%                    0.68%                   0.75%
           16-Mar-06                 11253.24                0.39%                    0.52%                   0.31%
           17-Mar-06                 11279.65                0.23%                    0.39%                   -0.71%
           20-Mar-06                 11274.53                -0.05%                   0.23%                   -0.63%
           21-Mar-06                 11235.47                -0.35%                  -0.05%                   0.18%
           22-Mar-06                 11317.43                0.73%                   -0.35%                   0.12%
           23-Mar-06                 11270.29                -0.42%                   0.73%                   0.48%
           24-Mar-06                 11279.97                0.09%                   -0.42%                   0.85%
           27-Mar-06                 11250.11                -0.26%                   0.09%                   -0.77%
           28-Mar-06                 11154.54                -0.85%                  -0.26%                   -0.30%
           29-Mar-06                 11215.7                 0.55%                   -0.85%                   1.61%
           30-Mar-06                 11150.7                 -0.58%                   0.55%                   0.00%
           31-Mar-06                 11109.32                -0.37%                  -0.58%                   -0.97%
           3-Apr-06                  11144.94                0.32%                   -0.37%                   1.14%
           4-Apr-06                  11203.85                0.53%                    0.32%                   -0.34%
           5-Apr-06                  11239.55                0.32%                    0.53%                   1.07%
           6-Apr-06                  11216.5                 -0.21%                   0.32%                   0.29%
           7-Apr-06                  11120.04                -0.86%                  -0.21%                   -0.90%
           10-Apr-06                 11141.33                0.19%                   -0.86%                   0.35%
           11-Apr-06                 11089.63                -0.46%                   0.19%                   -0.98%
           12-Apr-06                 11129.97                0.36%                   -0.46%                   -0.18%
           13-Apr-06                 11137.65                0.07%                    0.36%                   0.72%
           17-Apr-06                 11073.78                -0.57%                   0.07%                   0.38%
           18-Apr-06                 11268.77                1.76%                   -0.57%                   1.30%
           19-Apr-06                 11278.77                0.09%                    1.76%                   0.16%
           20-Apr-06                 11342.89                0.57%                    0.09%                   -1.40%
           21-Apr-06                 11347.45                0.04%                    0.57%                   1.02%
           24-Apr-06                 11336.32                -0.10%                   0.04%                   -0.79%
           25-Apr-06                 11283.25                -0.47%                  -0.10%                   -0.15%
                                                              22-Jan-07
                                      23-Dec-06

                                                  7-Jan-07




                                                                                     21-Feb-07
                          8-Dec-06




                                                                          6-Feb-07
8-Nov-06

              23-Nov-06




                                                                                                 8-Mar-07




           26-Apr-06                 11354.49                0.63%                   -0.47%                   0.07%
           27-Apr-06                 11382.51                0.25%                    0.63%                   -0.98%
           28-Apr-06                 11367.14                -0.14%                   0.25%                   -0.16%
           1-May-06                  11343.29                -0.21%                  -0.14%                   0.27%
           2-May-06                  11416.44                0.64%                   -0.21%                   0.29%
           3-May-06                  11400.28                -0.14%                   0.64%                   -0.57%
           4-May-06                  11438.86                0.34%                   -0.14%                   -0.59%
           5-May-06                  11577.74                1.21%                    0.34%                   1.38%
           8-May-06                  11584.54                0.06%                    1.21%                   0.06%
           9-May-06                  11639.77                0.48%                    0.06%                   0.12%
           10-May-06                 11642.65                0.02%                    0.48%                   0.04%
           11-May-06                 11500.73                -1.22%                   0.02%                   -1.52%
           12-May-06                 11380.99                -1.04%                  -1.22%                   -0.61%
15-May-06   11428.77   0.42%    -1.04%   -1.61%
16-May-06   11419.89   -0.08%   0.42%    0.03%
17-May-06   11205.61   -1.88%   -0.08%   -1.50%
18-May-06   11128.29   -0.69%   -1.88%   -0.95%
19-May-06   11144.06   0.14%    -0.69%   0.33%
22-May-06   11125.32   -0.17%   0.14%    -0.62%
23-May-06   11098.35   -0.24%   -0.17%   -0.90%
24-May-06   11117.32   0.17%    -0.24%   2.26%
25-May-06   11211.05   0.84%    0.17%    0.88%
26-May-06   11278.61   0.60%    0.84%    0.73%
30-May-06   11094.43   -1.63%   0.60%    -1.57%
31-May-06   11168.31   0.67%    -1.63%   0.92%
1-Jun-06    11260.28   0.82%    0.67%    0.61%
2-Jun-06    11247.87   -0.11%   0.82%    0.30%
5-Jun-06    11048.72   -1.77%   -0.11%   -1.89%
6-Jun-06    11002.14   -0.42%   -1.77%   -0.05%
7-Jun-06    10930.9    -0.65%   -0.42%   -1.57%
8-Jun-06    10938.82   0.07%    -0.65%   -0.36%
9-Jun-06    10891.92   -0.43%   0.07%    -0.58%
12-Jun-06   10792.58   -0.91%   -0.43%   -1.50%
13-Jun-06   10706.14   -0.80%   -0.91%   -2.26%
14-Jun-06   10816.91   1.03%    -0.80%   0.70%
15-Jun-06   11015.19   1.83%    1.03%    2.18%
16-Jun-06   11014.54   -0.01%   1.83%    -0.13%
19-Jun-06   10942.11   -0.66%   -0.01%   -1.82%
20-Jun-06   10974.84   0.30%    -0.66%   0.10%
21-Jun-06   11079.46   0.95%    0.30%    0.86%
22-Jun-06   11019.11   -0.54%   0.95%    0.32%
23-Jun-06   10989.09   -0.27%   -0.54%   0.83%
26-Jun-06   11045.28   0.51%    -0.27%   1.19%
27-Jun-06   10924.74   -1.09%   0.51%    -0.77%
28-Jun-06   10973.56   0.45%    -1.09%   0.38%
29-Jun-06   11190.8    1.98%    0.45%    1.83%
30-Jun-06   11150.22   -0.36%   1.98%    1.13%
 3-Jul-06   11228.02   0.70%    -0.36%   0.66%
 5-Jul-06   11151.82   -0.68%   0.70%    -0.94%
 6-Jul-06   11225.3    0.66%    -0.68%   -0.20%
 7-Jul-06   11090.67   -1.20%   0.66%    0.45%
10-Jul-06   11103.55   0.12%    -1.20%   0.60%
11-Jul-06   11134.77   0.28%    0.12%    1.28%
12-Jul-06   11013.18   -1.09%   0.28%    -0.44%
13-Jul-06   10846.29   -1.52%   -1.09%   -1.65%
14-Jul-06   10739.35   -0.99%   -1.52%   0.29%
17-Jul-06   10747.36   0.07%    -0.99%   -1.30%
18-Jul-06   10799.23   0.48%    0.07%    0.06%
19-Jul-06   11011.42   1.96%    0.48%    1.57%
20-Jul-06   10928.1    -0.76%   1.96%    -1.27%
21-Jul-06   10868.38   -0.55%   -0.76%   -0.51%
24-Jul-06   11051.05   1.68%    -0.55%   2.01%
25-Jul-06   11103.71   0.48%    1.68%    1.04%
26-Jul-06   11102.51   -0.01%   0.48%    0.87%
27-Jul-06   11100.43   -0.02%   -0.01%   -1.02%
28-Jul-06   11219.7    1.07%    -0.02%   0.73%
31-Jul-06   11185.68   -0.30%   1.07%    -0.25%
1-Aug-06    11125.73   -0.54%   -0.30%   0.60%
2-Aug-06    11199.92   0.67%    -0.54%   0.55%
3-Aug-06    11242.59   0.38%    0.67%    -0.18%
4-Aug-06    11240.35   -0.02%   0.38%    -0.15%
7-Aug-06    11219.38   -0.19%   -0.02%   0.57%
8-Aug-06    11173.59   -0.41%   -0.19%   0.40%
9-Aug-06    11076.18   -0.87%   -0.41%   -0.37%
10-Aug-06   11124.37   0.44%    -0.87%   -0.13%
11-Aug-06   11088.02   -0.33%   0.44%    -0.89%
14-Aug-06   11097.87   0.09%    -0.33%   1.38%
15-Aug-06   11230.26   1.19%    0.09%    0.40%
16-Aug-06   11327.12   0.86%    1.19%    0.38%
17-Aug-06   11334.96   0.07%    0.86%    -0.16%
18-Aug-06   11381.47   0.41%    0.07%    0.88%
21-Aug-06   11345.04   -0.32%   0.41%    0.61%
22-Aug-06   11339.84   -0.05%   -0.32%   -0.13%
23-Aug-06   11297.9    -0.37%   -0.05%   -0.72%
24-Aug-06   11304.46   0.06%    -0.37%   -0.06%
25-Aug-06   11284.05   -0.18%   0.06%    0.50%
28-Aug-06   11352.01   0.60%    -0.18%   -1.16%
29-Aug-06   11369.94   0.16%    0.60%    0.07%
30-Aug-06   11382.91   0.11%    0.16%    -0.16%
31-Aug-06   11381.15   -0.02%   0.11%    0.71%
1-Sep-06    11464.15   0.73%    -0.02%   0.47%
5-Sep-06    11469.28   0.04%    0.73%    -1.90%
6-Sep-06    11406.2    -0.55%   0.04%    -0.84%
7-Sep-06    11331.44   -0.66%   -0.55%   -0.30%
8-Sep-06    11392.11   0.54%    -0.66%   -1.38%
11-Sep-06   11396.84   0.04%    0.54%    0.35%
12-Sep-06   11498.09   0.89%    0.04%    0.71%
13-Sep-06   11543.32   0.39%    0.89%    -1.19%
14-Sep-06   11527.39   -0.14%   0.39%    0.20%
15-Sep-06   11560.77   0.29%    -0.14%   1.19%
18-Sep-06    11555     -0.05%   0.29%    -0.41%
19-Sep-06   11540.91   -0.12%   -0.05%   -0.26%
20-Sep-06   11613.19   0.63%    -0.12%   -0.03%
21-Sep-06   11533.23   -0.69%   0.63%    -0.54%
22-Sep-06   11508.1    -0.22%   -0.69%   0.41%
25-Sep-06   11575.81   0.59%    -0.22%   0.44%
26-Sep-06   11669.39   0.81%    0.59%    1.09%
27-Sep-06   11689.24   0.17%    0.81%    0.73%
28-Sep-06   11718.45   0.25%    0.17%    -0.38%
29-Sep-06   11679.07   -0.34%   0.25%    0.24%
2-Oct-06    11670.35   -0.07%   -0.34%   -2.00%
3-Oct-06    11727.34   0.49%    -0.07%   1.00%
4-Oct-06    11850.61   1.05%    0.49%    0.78%
5-Oct-06    11866.69   0.14%    1.05%    -0.39%
6-Oct-06    11850.21   -0.14%   0.14%    0.33%
9-Oct-06    11857.81   0.06%    -0.14%   -1.41%
10-Oct-06   11867.17   0.08%    0.06%    0.78%
11-Oct-06   11852.13   -0.13%   0.08%    1.66%
12-Oct-06   11947.7    0.81%    -0.13%   1.10%
13-Oct-06   11960.51   0.11%    0.81%    -0.60%
16-Oct-06   11980.59   0.17%    0.11%    -0.45%
17-Oct-06   11950.02   -0.26%   0.17%    0.90%
18-Oct-06   11992.68   0.36%    -0.26%   -0.34%
19-Oct-06   12011.73   0.16%    0.36%    0.67%
20-Oct-06   12002.37   -0.08%   0.16%    0.76%
23-Oct-06   12116.91   0.95%    -0.08%   1.14%
24-Oct-06   12127.88   0.09%    0.95%    0.13%
25-Oct-06   12134.68   0.06%    0.09%    -0.63%
26-Oct-06   12163.66   0.24%    0.06%    -0.04%
27-Oct-06   12090.26   -0.60%   0.24%    0.79%
30-Oct-06   12086.49   -0.03%   -0.60%   -1.54%
31-Oct-06   12080.73   -0.05%   -0.03%   1.27%
1-Nov-06    12031.02   -0.41%   -0.05%   0.70%
2-Nov-06    12018.54   -0.10%   -0.41%   0.54%
3-Nov-06    11986.04   -0.27%   -0.10%   -0.14%
6-Nov-06    12105.55   1.00%    -0.27%   0.85%
7-Nov-06    12156.77   0.42%    1.00%    0.28%
8-Nov-06    12176.54   0.16%    0.42%    -0.59%
9-Nov-06    12103.3    -0.60%   0.16%    0.01%
10-Nov-06   12108.43   0.04%    -0.60%   -0.25%
13-Nov-06   12131.88   0.19%    0.04%    1.03%
14-Nov-06   12218.01   0.71%    0.19%    -0.53%
15-Nov-06   12251.71   0.28%    0.71%    0.03%
16-Nov-06   12305.82   0.44%    0.28%    0.38%
17-Nov-06   12342.55   0.30%    0.44%    1.34%
20-Nov-06   12316.54   -0.21%   0.30%    -0.37%
21-Nov-06   12321.59   0.04%    -0.21%   0.90%
22-Nov-06   12326.95   0.04%    0.04%    -0.42%
24-Nov-06   12280.17   -0.38%   0.04%    -0.76%
27-Nov-06   12121.71   -1.29%   -0.38%   0.04%
28-Nov-06   12136.44   0.12%    -1.29%   0.94%
29-Nov-06   12226.73   0.74%    0.12%    0.60%
30-Nov-06   12221.93   -0.04%   0.74%    0.12%
1-Dec-06    12194.13   -0.23%   -0.04%   0.68%
4-Dec-06    12283.85   0.74%    -0.23%   0.47%
5-Dec-06    12331.6    0.39%    0.74%    0.03%
6-Dec-06    12309.25   -0.18%   0.39%    0.09%
7-Dec-06    12278.41   -0.25%   -0.18%   -0.12%
8-Dec-06    12307.48   0.24%    -0.25%   -0.15%
11-Dec-06   12328.48   0.17%    0.24%    0.03%
12-Dec-06   12315.58   -0.10%   0.17%    0.43%
13-Dec-06   12317.5    0.02%    -0.10%   0.66%
14-Dec-06   12416.76   0.81%    0.02%    -0.97%
15-Dec-06   12445.52   0.23%    0.81%    -0.93%
18-Dec-06   12441.27   -0.03%   0.23%    -0.07%
19-Dec-06   12471.32   0.24%    -0.03%   0.12%
20-Dec-06   12463.87   -0.06%   0.24%    -0.30%
21-Dec-06   12421.25   -0.34%   -0.06%   -0.23%
22-Dec-06   12343.21   -0.63%   -0.34%   1.38%
26-Dec-06   12407.63   0.52%    -0.63%   0.49%
27-Dec-06   12510.57   0.83%    0.52%    -0.11%
28-Dec-06   12501.52   -0.07%   0.83%    0.26%
29-Dec-06   12463.15   -0.31%   -0.07%   -1.57%
3-Jan-07    12474.52   0.09%    -0.31%   -1.12%
4-Jan-07    12480.69   0.05%    0.09%    -0.55%
5-Jan-07    12398.01   -0.66%   0.05%    0.64%
8-Jan-07    12423.49   0.21%    -0.66%   -0.85%
9-Jan-07    12416.6    -0.06%   0.21%    -0.06%
10-Jan-07   12442.16   0.21%    -0.06%   0.24%
11-Jan-07   12514.98   0.59%    0.21%    1.36%
12-Jan-07   12556.08   0.33%    0.59%    0.41%
16-Jan-07   12582.59   0.21%    0.33%    -0.23%
17-Jan-07   12577.15   -0.04%   0.21%    0.04%
18-Jan-07   12567.93   -0.07%   -0.04%   -1.04%
19-Jan-07   12565.53   -0.02%   -0.07%   0.89%
22-Jan-07   12477.16   -0.70%   -0.02%   -0.27%
23-Jan-07   12533.81   0.45%    -0.70%   1.72%
24-Jan-07   12621.77   0.70%    0.45%    0.79%
25-Jan-07   12502.56   -0.94%   0.70%    -0.65%
26-Jan-07   12487.02   -0.12%   -0.94%   0.40%
29-Jan-07   12490.78   0.03%    -0.12%   -0.31%
30-Jan-07   12523.31   0.26%    0.03%    0.68%
31-Jan-07   12621.69   0.79%    0.26%    0.08%
1-Feb-07    12673.68   0.41%    0.79%    0.97%
2-Feb-07    12653.49   -0.16%   0.41%    -0.42%
5-Feb-07    12661.75   0.07%    -0.16%   0.40%
6-Feb-07    12666.31   0.04%    0.07%    0.12%
7-Feb-07    12666.87   0.00%    0.04%    -0.42%
8-Feb-07    12637.63   -0.23%   0.00%    0.32%
9-Feb-07    12580.83   -0.45%   -0.23%   -0.84%
12-Feb-07   12552.56   -0.22%   -0.45%   -0.31%
13-Feb-07   12654.85   0.81%    -0.22%   1.13%
14-Feb-07   12741.86   0.69%    0.81%    0.24%
15-Feb-07   12765.01   0.18%    0.69%    0.55%
16-Feb-07   12767.57   0.02%    0.18%    0.24%
20-Feb-07   12786.64   0.15%    0.02%    -0.35%
21-Feb-07   12782.87   -0.03%   0.15%    0.35%
22-Feb-07   12686.02   -0.76%   -0.03%   0.05%
23-Feb-07   12647.48   -0.30%   -0.76%   -0.31%
26-Feb-07   12632.26   -0.12%   -0.30%   0.16%
27-Feb-07   12216.24   -3.29%   -0.12%   0.50%
28-Feb-07   12268.63   0.43%    -3.29%   -2.71%
1-Mar-07    12234.34   -0.28%   0.43%    0.16%
2-Mar-07    12114.1    -0.98%   -0.28%   -0.83%
5-Mar-07    12050.41   -0.53%   -0.98%   -0.79%
6-Mar-07    12207.59   1.30%    -0.53%   -0.98%
7-Mar-07    12192.45   -0.12%   1.30%    1.29%
8-Mar-07    12260.7    0.56%    -0.12%   0.65%
9-Mar-07    12276.32   0.13%    0.56%    0.63%
                                0.13%    0.20%
           Annual Risk-free Rate =   4.0%     << for calculating Sharpe Ratio



  Serial         Avg      Market     Sharpe        ?
Correlation Daily Rtn      Beta      Ratio         ?
   5.2%         0.04%      0.32       0.69         ?
                      <<< Click here to get (up to 200) stock names

                                   Moving Averages                                             "Annual"
                          days =        20          50         100       CLOSE         CAGR    Volatility

      PFIZER INC           PFE         25.74       25.99       26.11         25.41      1.7%    18.8%
  VERIZON COMMUN            VZ         37.50       37.45       36.30         36.45     15.2%    16.3%
  ALTRIA GROUP INC         MO          85.12       86.42       84.12         86.86     21.7%    16.7%
       AT&T INC.             T         36.80       36.08       34.87         36.55     40.5%    17.4%
    CITIGROUP INC            C         52.30       53.49       51.93         50.33     11.7%    14.7%
    MERCK CO INC          MRK          43.68       44.04       43.92         44.61     31.2%    19.0%
     GEN MOTORS            GM          33.58       32.23       32.14         30.99     49.0%    38.5%
  DU PONT E I DE NE         DD         51.43       50.08       48.22         51.14     26.9%    16.4%
  GEN ELECTRIC CO           GE         35.16       36.12       35.65         34.32      5.0%    12.3%
JP MORGAN CHASE C          JPM         50.06       49.52       48.31         48.82     22.3%    17.1%
 COCA COLA CO THE           KO         47.29       47.88       47.34         47.57     14.1%    10.5%
     3M COMPANY           MMM          74.92       76.16       77.29         74.73      6.1%    18.4%
JOHNSON AND JOHNS          JNJ         63.76       65.16       65.66         62.14      7.6%    10.1%
   MCDONALDS CP           MCD          44.59       44.33       43.07         44.15     31.4%    18.0%
   HOME DEPOT INC           HD         40.15       40.07       38.76         38.67     -4.3%    19.0%
 HONEYWELL INTL IN        HON          46.85       45.74       44.08         47.23     15.6%    17.7%
      ALCOA INC             AA         33.70       31.93       30.45         33.20     16.4%    27.0%
       INTEL CP           INTC         20.34       20.65       20.83         19.10     -1.1%    24.8%
  CATERPILLAR INC          CAT         65.50       62.94       62.45         64.40     -7.7%    27.3%
 PROCTER GAMBLE             PG         63.82       64.28       63.67         62.16      2.4%    14.1%
     UNITED TECH           UTX         66.39       65.41       64.97         64.50     12.9%    18.2%
   EXXON MOBIL CP         XOM          73.45       73.58       73.30         71.12     21.2%    19.3%
      BOEING CO             BA         89.22       88.61       87.15         89.51     21.1%    22.6%
  WAL MART STORES         WMT          48.43       47.93       47.71         47.42      6.2%    17.4%
    MICROSOFT CP          MSFT         28.50       29.50       29.25         27.28      2.1%    21.0%
 INTL BUSINESS MAC         IBM         96.17       97.26       94.62         93.28     15.3%    14.7%
 AMER EXPRESS INC          AXP         57.29       58.32       58.56         56.90      6.7%    16.1%
 AMER INTL GROUP I         AIG         68.85       69.72       69.46         69.07      2.5%    13.2%
 WALT DISNEY-DISNE         DIS         34.54       34.75       33.67         34.37     21.2%    18.4%
HEWLETT PACKARD C         HPQ          40.88       41.62       40.54         40.11     21.3%    23.1%
DOW JONES INDUSTR          ^DJI      12,478.87   12,507.11   12,353.69     12,276.32   10.7%    10.0%
          Sort on column      a


Volume/      Serial          Avg       Market   Sharpe   ?
 1000      Correlation     Daily Rtn    Beta     Ratio   ?

25754.5        8.81%         0.01%      0.26    -0.03    ?
11721.6       -6.75%         0.06%      0.31     0.70    ?
 19918       -11.40%         0.09%      0.11     1.03    ?
14731.5       10.81%         0.14%      0.36     1.81    ?
15701.2        5.51%         0.05%      0.27     0.54    ?
 8270.7      -11.32%         0.12%      0.26     1.40    ?
 7476.5       10.44%         0.18%      0.54     1.06    ?
 2480.1        8.91%         0.11%      0.36     1.39    ?
34229.8        8.92%         0.02%      0.11     0.14    ?
 9452.9        3.88%         0.08%      0.43     0.98    ?
13063.6       13.02%         0.05%      0.19     0.92    ?
 3346.2        2.80%         0.03%      0.32     0.17    ?
10011.5       11.30%         0.03%      0.12     0.34    ?
 6217.7       -2.23%         0.11%      0.33     1.37    ?
11988.6        5.04%        -0.01%      0.29    -0.33    ?
 4082.3        7.47%         0.06%      0.40     0.62    ?
 9092.1        7.94%         0.07%      0.79     0.52    ?
51056.7        4.18%         0.00%      0.39    -0.13    ?
 3267.7        7.80%        -0.02%      0.40    -0.33    ?
 9194.4       -6.27%         0.01%      0.13    -0.06    ?
 2560.1       18.42%         0.06%      0.40     0.55    ?
 28671         1.66%         0.08%      0.59     0.89    ?
 2820.6        5.47%         0.09%      0.49     0.77    ?
13950.5       10.80%         0.03%      0.23     0.20    ?
 80114        -5.21%         0.02%      0.35     0.00    ?
  6333         0.85%         0.06%      0.20     0.81    ?
 3819.8       -6.80%         0.03%      0.31     0.17    ?
 7437.1        7.13%         0.01%      0.18    -0.03    ?
11403.1       -5.29%         0.09%      0.30     0.99    ?
17411.4       -3.09%         0.09%      0.30     0.83    ?
2623050        5.23%         0.04%      0.32     0.69    ?

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:9/12/2012
language:English
pages:26