matlab金融计算课件及作业帝国理工大学商学院

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><dimension ref="A1:AE2642"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"/></sheetViews><sheetFormatPr defaultRowHeight="14.4" x14ac:dyDescent="0.3"/><sheetData><row r="1" spans="1:31" x14ac:dyDescent="0.3"><c r="A1" t="s"><v>0</v></c><c r="B1" t="s"><v>1</v></c><c r="C1" t="s"><v>2</v></c><c r="D1" t="s"><v>3</v></c><c r="E1" t="s"><v>4</v></c><c r="F1" t="s"><v>5</v></c><c r="G1" t="s"><v>6</v></c><c r="H1" t="s"><v>7</v></c><c r="I1" t="s"><v>8</v></c><c r="J1" t="s"><v>9</v></c><c r="K1" t="s"><v>10</v></c><c r="L1" t="s"><v>11</v></c><c r="M1" t="s"><v>12</v></c><c r="N1" t="s"><v>13</v></c><c r="O1" t="s"><v>14</v></c><c r="P1" t="s"><v>15</v></c><c r="Q1" t="s"><v>16</v></c><c r="R1" t="s"><v>17</v></c><c r="S1" t="s"><v>18</v></c><c r="T1" t="s"><v>19</v></c><c r="U1" t="s"><v>20</v></c><c r="V1" t="s"><v>21</v></c><c r="W1" t="s"><v>22</v></c><c r="X1" t="s"><v>23</v></c><c r="Y1" t="s"><v>24</v></c><c r="Z1" t="s"><v>25</v></c><c r="AA1" t="s"><v>26</v></c><c r="AB1" t="s"><v>27</v></c><c r="AC1" t="s"><v>28</v></c><c r="AD1" t="s"><v>29</v></c><c r="AE1" t="s"><v>30</v></c></row><row r="2" spans="1:31" x14ac:dyDescent="0.3"><c r="A2" s="1"><v>38355</v></c><c r="B2"><v>25.78828</v></c><c r="C2"><v>1023.77982</v></c><c r="D2"><v>41.620629000000001</v></c><c r="E2"><v>40.029105999999999</v></c><c r="F2"><v>401.04748699999999</v></c><c r="G2"><v>36.486939</v></c><c r="H2"><v>31.784984999999999</v></c><c r="I2"><v>23.771298999999999</v></c><c r="J2"><v>25.252261999999899</v></c><c r="K2"><v>44.52</v></c><c r="L2"><v>32.978808999999998</v></c><c r="M2"><v>27.255262999999999</v></c><c r="N2"><v>18.054787000000001</v></c><c r="O2"><v>80.657336000000001</v></c><c r="P2"><v>16.991786999999999</v></c><c r="Q2"><v>45.887515</v></c><c r="R2"><v>29.528275000000001</v></c><c r="S2"><v>15.332331999999999</v></c><c r="T2"><v>23.128425</v></c><c r="U2"><v>62.715681999999902</v></c><c r="V2"><v>8.0424799999999994</v></c><c r="W2"><v>20.353895999999999</v></c><c r="X2"><v>21.179006999999999</v></c><c r="Y2"><v>17.006594</v></c><c r="Z2"><v>41.031473999999903</v></c><c r="AA2"><v>93.245154999999997</v></c><c r="AB2"><v>40.810813000000003</v></c><c r="AC2"><v>21.460249999999998</v></c><c r="AD2"><v>42.517553999999997</v></c><c r="AE2"><v>38.885368999999997</v></c></row><row r="3" spans="1:31" x14ac:dyDescent="0.3"><c r="A3" s="1"><v>38356</v></c><c r="B3"><v>25.322277</v></c><c r="C3"><v>1027.1908880000001</v></c><c r="D3"><v>40.995317999999997</v></c><c r="E3"><v>39.251612000000002</v></c><c r="F3"><v>397.641029</v></c><c r="G3"><v>36.083958000000003</v></c><c r="H3"><v>31.099072999999901</v></c><c r="I3"><v>23.515241</v></c><c r="J3"><v>24.948601</v></c><c r="K3"><v>42.139998999999897</v></c><c r="L3"><v>32.557966999999998</v></c><c r="M3"><v>26.768836999999898</v></c><c r="N3"><v>17.934708999999899</v></c><c r="O3"><v>79.790937</v></c><c r="P3"><v>16.652982999999999</v></c><c r="Q3"><v>45.741608999999997</v></c><c r="R3"><v>29.223936999999999</v></c><c r="S3"><v>15.118254</v></c><c r="T3"><v>23.317408</v></c><c r="U3"><v>62.205737999999997</v></c><c r="V3"><v>8.0981929999999895</v></c><c r="W3"><v>20.26925</v></c><c r="X3"><v>21.258210999999999</v></c><c r="Y3"><v>17.006594</v></c><c r="Z3"><v>40.518489000000002</v></c><c r="AA3"><v>92.640992999999995</v></c><c r="AB3"><v>40.339309</v></c><c r="AC3"><v>21.242944999999999</v></c><c r="AD3"><v>42.413952000000002</v></c><c r="AE3"><v>38.621423999999998</v></c></row><row r="4" spans="1:31" x14ac:dyDescent="0.3"><c r="A4" s="1"><v>38357</v></c><c r="B4"><v>25.17249</v></c><c r="C4"><v>1044.2461330000001</v></c><c r="D4"><v>40.614834999999999</v></c><c r="E4"><v>39.903450999999997</v></c><c r="F4"><v>402.626082</v></c><c r="G4"><v>35.393138</v></c><c r="H4"><v>30.684935999999901</v></c><c r="I4"><v>23.387207999999902</v></c><c r="J4"><v>24.796769000000001</v></c><c r="K4"><v>41.77</v></c><c r="L4"><v>32.259551000000002</v></c><c r="M4"><v>26.691628000000001</v></c><c r="N4"><v>18.011903</v></c><c r="O4"><v>79.625912</v></c><c r="P4"><v>16.490945</v></c><c r="Q4"><v>45.712426999999998</v></c><c r="R4"><v>29.284806</v></c><c r="S4"><v>15.048126</v></c><c r="T4"><v>23.135693</v></c><c r="U4"><v>61.444625000000002</v></c><c r="V4"><v>8.0836009999999998</v></c><c r="W4"><v>20.405985000000001</v></c><c r="X4"><v>21.210688999999999</v></c><c r="Y4"><v>16.890858999999999</v></c><c r="Z4"><v>40.942259999999997</v></c><c r="AA4"><v>92.223416999999998</v></c><c r="AB4"><v>40.038182999999997</v></c><c r="AC4"><v>21.211141999999999</v></c><c r="AD4"><v>42.469738</v></c><c r="AE4"><v>38.419584999999998</v></c></row><row r="5" spans="1:31" x14ac:dyDescent="0.3"><c r="A5" s="1"><v>38358</v></c><c r="B5"><v>25.280669</v></c><c r="C5"><v>1045.95161999999</v></c><c r="D5"><v>40.405946</v></c><c r="E5"><v>39.644284999999897</v></c><c r="F5"><v>406.531025</v></c><c r="G5"><v>35.915092999999999</v></c><c r="H5"><v>30.678465999999901</v></c><c r="I5"><v>23.421343</v></c><c r="J5"><v>24.996910999999901</v></c><c r="K5"><v>41.049999</v></c><c r="L5"><v>31.777493</v></c><c r="M5"><v>26.514043999999998</v></c><c r="N5"><v>17.977592999999999</v></c><c r="O5"><v>79.378367999999995</v></c><c r="P5"><v>16.542501999999999</v></c><c r="Q5"><v>45.843742999999897</v></c><c r="R5"><v>29.452189000000001</v></c><c r="S5"><v>15.173619</v></c><c r="T5"><v>23.317408</v></c><c r="U5"><v>62.000233999999999</v></c><c r="V5"><v>8.0265620000000002</v></c><c r="W5"><v>20.549229999999898</v></c><c r="X5"><v>21.186927999999899</v></c><c r="Y5"><v>16.903718999999999</v></c><c r="Z5"><v>41.142994000000002</v></c><c r="AA5"><v>93.493932999999998</v></c><c r="AB5"><v>40.061954999999998</v></c><c r="AC5"><v>21.165652999999999</v></c><c r="AD5"><v>43.075423000000001</v></c><c r="AE5"><v>38.908658000000003</v></c></row><row r="6" spans="1:31" x14ac:dyDescent="0.3"><c r="A6" s="1"><v>38359</v></c><c r="B6"><v>25.538636</v></c><c r="C6"><v>1047.8122109999999</v></c><c r="D6"><v>40.107526</v></c><c r="E6"><v>39.510778000000002</v></c><c r="F6"><v>404.204677</v></c><c r="G6"><v>35.838332999999999</v></c><c r="H6"><v>30.65258</v></c><c r="I6"><v>23.190887</v></c><c r="J6"><v>24.845078999999998</v></c><c r="K6"><v>42.32</v></c><c r="L6"><v>31.693324</v></c><c r="M6"><v>26.41367</v></c><c r="N6"><v>17.874669000000001</v></c><c r="O6"><v>79.031811000000005</v></c><c r="P6"><v>16.792922999999998</v></c><c r="Q6"><v>45.675950999999998</v></c><c r="R6"><v>29.216329999999999</v></c><c r="S6"><v>15.192074</v></c><c r="T6"><v>23.164767999999999</v></c><c r="U6"><v>62.639571999999902</v></c><c r="V6"><v>8.1446199999999997</v></c><c r="W6"><v>20.26925</v></c><c r="X6"><v>21.123564999999999</v></c><c r="Y6"><v>16.910146999999998</v></c><c r="Z6"><v>41.574197999999903</v></c><c r="AA6"><v>93.094116</v></c><c r="AB6"><v>39.630071999999998</v></c><c r="AC6"><v>21.090729</v></c><c r="AD6"><v>43.027608000000001</v></c><c r="AE6"><v>38.652476999999998</v></c></row><row r="7" spans="1:31" x14ac:dyDescent="0.3"><c r="A7" s="1"><v>38362</v></c><c r="B7"><v>25.355561999999999</v></c><c r="C7"><v>1049.672802</v></c><c r="D7"><v>40.189588000000001</v></c><c r="E7"><v>40.036959000000003</v></c><c r="F7"><v>401.62906099999998</v></c><c r="G7"><v>35.508272999999903</v></c><c r="H7"><v>30.697877999999999</v></c><c r="I7"><v>23.284776999999998</v></c><c r="J7"><v>24.782965999999998</v></c><c r="K7"><v>41.84</v></c><c r="L7"><v>31.984089999999998</v></c><c r="M7"><v>26.328738000000001</v></c><c r="N7"><v>17.848936999999999</v></c><c r="O7"><v>78.949297999999999</v></c><c r="P7"><v>16.851845000000001</v></c><c r="Q7"><v>