版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)
文檔簡(jiǎn)介
1、UN12G用VBA模擬對(duì)數(shù)正態(tài)分布價(jià)格的走勢(shì)按CtrlA運(yùn)行宏命令注意這里Application.screenupdating有一個(gè)很大的差異!股票開(kāi)始時(shí)間12:51:30運(yùn)行125ttitle天price停止時(shí)間12:51:30初始價(jià)格30對(duì)數(shù)正態(tài)分布價(jià)格的模擬030.00逝去時(shí)間00:00:00均值20%參數(shù):均值=20.00%標(biāo)準(zhǔn)差=20.00%130.05標(biāo)準(zhǔn)差20%229.29329.08429.17529.76629.747
2、28.80829.26928.801029.071129.401230.391330.241429.651529.021629.261729.701829.531930.142029.35注意:你可以調(diào)整運(yùn)行該模擬的圖形的Y軸刻度2129.432229.182329.072428.692528.852628.922728.722828.812928.763029.003128.673228.943329.323429.223529.01
3、3629.133728.323828.923928.894029.044128.914228.854328.874429.084529.564629.854729.214828.754928.075027.855128.035228.385328.395428.245527.795627.605727.535827.975927.566027.576127.946227.766327.696427.896527.726628.28672
4、8.156828.746928.527029.017128.587228.377328.567428.647528.807628.727728.427828.677928.638028.158128.078228.248327.448427.428527.948627.328727.338827.438927.579027.919127.869228.009327.759427.989528.069628.389728.369828.3
5、79928.6310029.2310128.8210228.3510328.4910428.5810528.6510628.5510728.5310828.6910928.9411028.6311128.3211228.5711328.1311427.9011528.0311628.1511727.9911827.9611927.9112028.1212128.3812227.6612327.2012426.8112526.441262
6、6.2712726.3112826.0412925.6413025.2913125.2513225.4313325.2713424.8713524.7013624.9913724.9613824.7513924.1314023.8214123.8114223.3914323.3314423.4214523.0014622.5814722.4214822.2514922.1715022.1315121.8215221.3515321.73
7、15421.5315521.5115621.5315721.7315821.7715921.6216021.2216121.0616221.0816321.3416421.7216522.0216621.3816721.1916820.7016920.8717020.9317121.2417221.4717321.0017421.3917521.5817621.1817721.5817821.5917922.0618022.221812
8、2.0618222.0218321.7918422.0618522.0218622.3718722.2218821.9218921.6619021.5019121.4119221.3419321.9719422.3419522.4419622.1319722.0219821.9819922.1820022.2020122.5020222.5320322.5920422.3520522.1820622.1520722.2420822.22
9、20921.8421021.8121121.8721221.3921321.4621421.4421521.5421621.5121721.5321821.4521921.2322021.3322121.1122221.1822321.5822421.2622521.2422621.0622721.0222821.1522921.0823021.2723121.7523221.5923321.6323421.6523522.052362
10、2.3023722.2523822.4523922.7124022.9024123.1824223.2724323.0724423.0624523.5624623.7524723.5524823.6724923.9825023.75對(duì)數(shù)正態(tài)分布價(jià)格的模擬3002502001501005002022242628303234天股票價(jià)格($)ABCDEFGHIJKLMNOP12345678910111213141516171819202122
11、2324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
12、1221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941
13、95196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257Page224tPage3LognmalPriceSimulat
溫馨提示
- 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 眾賞文庫(kù)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 22388.基于simulink的對(duì)數(shù)正態(tài)排隊(duì)網(wǎng)絡(luò)仿真及參數(shù)優(yōu)化
- wps中用excel做正態(tài)分析
- 可轉(zhuǎn)債價(jià)格與正股價(jià)格聯(lián)動(dòng)關(guān)系的實(shí)證分析.pdf
- 正態(tài)總體的抽樣分布
- 非正態(tài)數(shù)據(jù)轉(zhuǎn)換及過(guò)程能力分析
- 非正態(tài)過(guò)程能力分析與控制方法研究.pdf
- 59300.井間地震資料正演模擬技術(shù)與分析
- 論文關(guān)于小正鎮(zhèn)蔬菜價(jià)格的分析與建議
- 正態(tài)條件下回歸的推論
- 正態(tài)性檢驗(yàn)方法比較
- 有限正態(tài)總體的貝葉斯預(yù)測(cè).pdf
- 正態(tài)概率圖(normal-probability-plot)
- 正態(tài)模型的多變點(diǎn)檢測(cè)問(wèn)題研究.pdf
- 項(xiàng)目反應(yīng)模型的正態(tài)擬合檢驗(yàn)法.pdf
- 非正態(tài)驗(yàn)證性因子分析在基因整體效應(yīng)中的應(yīng)用.pdf
- 對(duì)色八重態(tài)電弱二重態(tài)模型的幺正約束
- 正態(tài)總體信噪比檢驗(yàn)和參數(shù)的同時(shí)檢驗(yàn).pdf
- 基于GLM的非正態(tài)響應(yīng)穩(wěn)健設(shè)計(jì)研究.pdf
- 對(duì)色八重態(tài)電弱二重態(tài)模型的幺正約束.pdf
- 基于非正態(tài)穩(wěn)定分布的投資組合研究.pdf
評(píng)論
0/150
提交評(píng)論