chapter41

Index Value: 14,009.43Trade Time: 12:58PM ETChange: Down 37.88 (0.27%)Prev Close: 14,047.31Open: 14,038.86Days Range: 13,973.50 - 14,038.9452wk Range: 11,608.20 - 14,166.20Date,Open,High,Low,Close,Volume,Adj Close2007-05-04,46.77,46.89,46.42,46.63,93591800,46.572007-05-03,46.51,46.72,46.43,46.59,98003600,46.532007-05-02,46.09,46.58,46.05,46.42,91971600,46.362007-05-01,45.97,46.14,45.66,46.11,135044400,46.052007-04-30,46.49,46.53,45.92,45.96,93290500,45.902007-04-27,46.37,46.70,46.29,46.57,96536500,46.51HISTORICAL VOLATILITY - REV1Date,Open,High,Low,Close,Volume,Adj Close2007-05-04,46.77,46.89,46.42,46.63,93591800,46.572007-05-03,46.51,46.72,46.43,46.59,98003600,46.532007-05-02,46.09,46.58,46.05,46.42,91971600,46.362007-05-01,45.97,46.14,45.66,46.11,135044400,46.052007-04-30,46.49,46.53,45.92,45.96,93290500,45.902007-04-27,46.37,46.70,46.29,46.57,96536500,46.51HISTORICAL VOLATILITY - REV1Date,Open,High,Low,Close,Volume,Adj Close2007-05-04,46.77,46.89,46.42,46.63,93591800,46.572007-05-03,46.51,46.72,46.43,46.59,98003600,46.532007-05-02,46.09,46.58,46.05,46.42,91971600,46.362007-05-01,45.97,46.14,45.66,46.11,135044400,46.052007-04-30,46.49,46.53,45.92,45.96,93290500,45.902007-04-27,46.37,46.70,46.29,46.57,96536500,46.51HISTORICAL VOLATILITY - REV1Date,Open,High,Low,Close,Volume,Adj Close2007-05-04,46.77,46.89,46.42,46.63,93591800,46.572007-05-03,46.51,46.72,46.43,46.59,98003600,46.532007-05-02,46.09,46.58,46.05,46.42,91971600,46.362007-05-01,45.97,46.14,45.66,46.11,135044400,46.052007-04-30,46.49,46.53,45.92,45.96,93290500,45.902007-04-27,46.37,46.70,46.29,46.57,96536500,46.51HISTORICAL VOLATILITY - REV1TEXTHISTORICAL VOLATILITY - REV1TEXTDate Open High Low Close Volume Adj Close2007/5/4 46.77 46.89 46.42 46.63 93591800 46.572007/5/3 46.51 46.72 46.43 46.59 98003600 46.532007/5/2 46.09 46.58 46.05 46.42 91971600 46.362007/5/1 45.97 46.14 45.66 46.11 135044400 46.052007/4/30 46.49 46.53 45.92 45.96 93290500 45.92007/4/27 46.37 46.7 46.29 46.57 96536500 46.51HISTORICAL VOLATILITY - REV2HISTORICAL VOLATILITY - REV2Date Open High Low Close Volume Adj Close2007/5/4 46.77 46.89 46.42 46.63 93591800 46.572007/5/3 46.51 46.72 46.43 46.59 98003600 46.532007/5/2 46.09 46.58 46.05 46.42 91971600 46.362007/5/1 45.97 46.14 45.66 46.11 135044400 46.052007/4/30 46.49 46.53 45.92 45.96 93290500 45.92007/4/27 46.37 46.7 46.29 46.57 96536500 46.51HISTORICAL VOLATILITY - REV3HISTORICAL VOLATILITY - REV3Date Open High Low Close Volume Adj Close2007/10/2 52.04 52.06 51.72 52.01 71023000 52.012007/10/1 51.45 52.16 51.38 52 100404100 522007/9/28 51.54 51.68 51.18 51.41 75546000 51.412007/9/27 51.62 51.65 51.36 51.58 73423200 51.582007/9/26 51.36 51.51 51.12 51.32 96124600 51.322007/9/25 50.42 51.07 50.36 51.07 101102200 51.072007/9/24 50.49 50.96 50.33 50.59 107226800 50.592007/9/21 50.28 50.52 50.01 50.36 86829500 50.362007/9/20 50.06 50.26 49.92 50.03 109970600 502007/9/19 50.29 50.59 49.98 50.17 127025800 50.142007/9/18 49.09 50.08 48.83 50.04 151452100 50.012007/9/17 49 49.1 48.59 48.81 84882300 48.782007/9/14 48.8 49.31 48.73 49.22 99801200 49.192007/9/13 49.29 49.35 48.94 49.18 80807500 49.152007/9/12 48.84 49.37 48.78 48.94 93993400 48.912007/9/11 48.51 48.99 48.43 48.93 103064500 48.92007/9/10 48.62 48.75 47.81 48.2 125199400 48.172007/9/7 48.53 48.6 47.95 48.23 152438000 48.22007/9/6 49.23 49.36 48.81 49.14 99222600 49.112007/9/5 49.56 49.65 48.87 49.18 114049300 49.152007/9/4 48.93 50 48.91 49.68 98480900 49.65HISTORICAL VOLATILITY - REV4HISTORICAL VOLATILITY - REV4Date Open High Low Close Volume Adj Close2007/10/2 33 33.13 32.87 33.01 31426300 33.012007/10/1 33.01 33.33 32.97 32.99 42086900 32.992007/9/28 33.14 33.38 32.97 33.13 32664600 33.132007/9/27 33.02 33.29 32.85 33.23 38079100 33.232007/9/26 32.65 33 32.6 32.99 64886200 32.99Here we have run the macro forCisco stock (symbol CSCO).2007/9/25 31.75 32.53 31.65 32.44 47893500 32.442007/9/24 32.22 32.43 31.75 31.88 41171000 31.882007/9/21 32.56 32.56 32.19 32.3 56843000 32.32007/9/20 31.99 32.39 31.91 32.21 33249100 32.212007/9/19 32.23 32.48 32.05 32.09 49602000 32.092007/9/18 31.58 32.04 31.41 32.04 56156300 32.04这里我们针对Cisco公司股票(代码 CSCO)运行了的这个宏。Here we have run the macro forCisco stock (symbol CSCO).这里我们针对Cisco公司股票(代码 CSCO)运行了的这个宏。HISTORICAL VOLATILITY - REV5Date Open High Low Close Volume Adj Close2007/10/2 52.04 52.06 51.72 52.01 71023000 52.012007/10/1 51.45 52.16 51.38 52 100404100 522007/9/28 51.54 51.68 51.18 51.41 75546000 51.412007/9/27 51.62 51.65 51.36 51.58 73423200 51.582007/9/26 51.36 51.51 51.12 51.32 96124600 51.322007/9/25 50.42 51.07 50.36 51.07 101102200 51.072007/9/24 50.49 50.96 50.33 50.59 107226800 50.592007/9/21 50.28 50.52 50.01 50.36 86829500 50.362007/9/20 50.06 50.26 49.92 50.03 109970600 502007/9/19 50.29 50.59 49.98 50.17 127025800 50.142007/9/18 49.09 50.08 48.83 50.04 151452100 50.01HISTORICAL VOLATILITY - GETRETURNSPut cursor on destination cell (A2)初始光标位置放在目标单元格(A2)上Put cursor on destination cell (A2)初始光标位置放在目标单元格(A2)上HISTORICAL VOLATILITY - GETRETURNS-0.0069458120.0001922890.011411013-0.0033012940.005053461Put cursor on destination cell (A2)0.0048832990.0094433120.0045567190.007174204-0.002796087初始光标位置放在目标单元格(A2)上HISTORICAL VOLATILITY - GETVOLATILITYPut cursor on destination cell (A2)初始光标位置放在目标单元格(A2)上Put cursor on destination cell (A2)初始光标位置放在目标单元格(A2)上HISTORICAL VOLATILITY - GETVOLATILITY0.089438Put cursor on destination cell (A2)初始光标位置放在目标单元格(A2)上