您的当前位置:首页正文

国外优秀表格

2020-03-13 来源:步旅网
Input

?????Modify Correlation MatrixRisk free Rate:Min Constraint:Max Constraint:Current Units:BenchmarkProduct Name:1-Jan-101-Feb-101-Mar-101-Apr-101-May-101-Jun-101-Jul-101-Aug-101-Sep-101-Oct-101-Nov-101-Dec-101-Jan-111-Feb-111-Mar-111-Apr-111-May-111-Jun-111-Jul-111-Aug-111-Sep-111-Oct-111-Nov-111-Dec-111-Jan-121-Feb-121-Mar-121-Apr-121-May-121-Jun-121-Jul-121-Aug-121-Sep-121-Oct-121-Nov-121-Dec-121-Jan-131-Feb-131-Mar-131-Apr-131-May-131-Jun-131-Jul-131-Aug-131-Sep-131-Oct-13^GSPC1073.91104.51169.41186.71089.41030.71101.61049.31141.21183.31180.61257.61286.11327.21325.81363.61345.21320.61292.31218.91131.41253.31247.01257.61312.41365.71408.51397.91310.31362.21379.31406.61440.71412.21416.21426.21498.11514.71569.21597.61630.71606.31685.71633.01681.61756.50.36%Data in Prices ReturnsAll Long?Target0.00%100.00%2.00AAPL25.827.531.535.034.533.834.532.638.140.441.843.345.547.446.847.046.745.052.451.651.254.351.354.361.372.880.578.477.578.482.089.789.980.279.272.061.760.160.360.361.654.462.067.265.872.1?1.00% Position0.00%100.00%36.00MSFT24.424.925.526.522.520.122.520.621.523.422.324.624.523.622.623.022.423.224.523.922.424.023.223.526.829.029.429.226.828.127.128.527.526.424.824.925.626.126.931.133.032.730.131.831.733.70.00%100.00%1.00GOOGL265.2263.7283.8263.1243.1222.7242.7225.2263.2307.2278.1297.3300.5307.0293.7272.3264.8253.4302.1270.8257.8296.6300.0323.3290.3309.4320.9302.7290.7290.3316.8342.9377.6340.5349.5354.0378.2401.0397.5412.7436.0440.6444.3423.9438.4515.8??Risk Overall DeviationResult Minimum Risk0.00%100.00%23.00ADBE32.334.735.433.632.126.428.727.726.228.227.830.833.034.533.233.534.631.527.725.224.229.427.428.331.032.934.333.531.032.430.931.332.434.034.637.737.839.343.545.142.945.647.345.851.954.20.00%100.00%42.00YHOO15.015.316.516.515.313.813.913.114.216.515.816.616.116.416.717.716.515.013.113.613.215.615.716.115.514.815.215.515.215.815.814.716.016.818.819.919.621.323.524.726.325.128.127.133.232.9Historic Observation Periods?Page 1

Input

1-Nov-131-Dec-131-Jan-141-Feb-141-Mar-141-Apr-141-May-141-Jun-141-Jul-141-Aug-141-Sep-141-Oct-141-Nov-141-Dec-141-Jan-151-Feb-151-Mar-151-Apr-151-May-151-Jun-151-Jul-151805.81848.41782.61859.41872.31883.91923.61960.21930.72003.41972.32018.12067.62058.91995.02104.52067.92085.52107.42063.12108.677.277.969.573.574.982.488.991.394.0101.299.5106.7118.0109.5116.2127.9123.9124.6130.3125.4122.436.635.936.337.139.739.139.940.642.044.545.446.047.245.839.943.640.448.346.944.246.9530.3560.9591.1608.4557.8534.9571.7584.7579.5582.4588.4567.9549.1530.7537.5562.6554.7548.8545.3540.0664.637.040.436.038.735.936.034.735.135.838.540.846.051.750.544.044.344.442.642.939.337.456.859.959.268.665.761.764.572.469.371.969.270.173.772.770.179.173.976.179.181.081.3Page 2

Input

Overall Deviation (Sharpe)Minimum Risk?0.00%100.00%46.00INTC16.117.218.719.218.116.417.415.016.317.118.118.018.418.617.520.019.619.319.517.718.821.622.121.523.524.125.225.423.324.023.222.620.619.718.018.919.319.420.322.222.822.721.920.821.723.20.00%100.00%69.00DELL12.512.814.515.712.911.712.811.412.513.912.813.112.715.314.015.015.616.115.714.413.715.315.214.216.716.716.115.811.912.111.510.29.69.09.410.013.013.714.213.213.213.212.613.713.813.9Capital 10,0000.00%100.00%32.00ORCL21.823.324.324.521.420.322.420.725.527.925.729.830.531.331.834.332.631.429.226.827.531.430.024.627.128.128.028.325.528.629.130.530.330.031.132.434.533.231.431.832.829.831.531.132.332.80.00%100.00%5.00IBM109.6114.4115.4116.1113.3111.7116.1111.9121.9130.5129.1134.0147.9148.4149.4156.3155.5157.9167.4158.9161.7170.7174.5170.7178.8183.3194.4193.0180.5183.0183.4183.1195.0182.8179.4180.8191.7190.4202.2192.0198.1182.0185.7174.4177.2171.50.00%100.00%48.00CSCO20.121.723.224.020.719.020.617.819.520.417.118.118.916.615.415.715.014.014.414.113.916.716.816.317.818.019.218.314.815.614.617.417.415.817.518.219.119.319.419.522.522.724.121.922.021.40.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 3

Input

34.537.436.238.440.140.241.439.939.941.037.838.742.044.541.643.542.843.543.340.239.7172.9180.5170.0179.1186.2190.1179.4176.4186.5188.2185.8160.9159.8158.1151.1160.7159.3170.0169.6162.7161.022.824.823.423.924.925.726.630.133.034.234.133.336.735.832.633.031.032.334.530.428.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.913.920.121.320.920.821.422.323.723.924.524.324.623.927.027.226.029.127.328.629.127.228.3Page 4

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 5

Input

Page 6

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 7

Input

Page 8

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 9

Input

Page 10

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 11

Input

Page 12

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 13

Input

Page 14

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 15

Input

Page 16

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 17

Input

Page 18

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 19

Input

Page 20

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 21

Input

Page 22

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.00Page 23

Input

Page 24

Input

0.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.00%100.00%1.000.048129860.058414180.010808-0.0954769-0.09543660.07531209-0.08109670.081154080.09176856-0.04622390.070915920.023422240.01275768-0.03279540.04508007-0.0187865-0.0342927-0.0156323-0.0499839-0.01785710.14828634-0.015294-0.01715860.075549010.034125030.0301277-0.0099018-0.0953780.04376677-0.02003470.02219080.0079131-0.02529940.019863680.041948470.047451480.025582050.041038460.041957830.03887752-0.01372530.02012108-0.01703330.063633990.03130949

Page 25

Input

0.036877750.05048957-0.02951310.052637030.00523822-0.00184340.021360960.036577390.018357930.03333789-0.00297750.008371730.06385516-0.0091486-0.06512240.06395169-0.03770630.04287070.01269469-0.04841790.01236692

Page 26

Input

FALSE0.052377450.0381470.01349068-0.03190549-0.051292040.047973-0.04249770.074574110.07217561-0.005684560.051977740.083128330.01898829-0.007664250.032911790.00066147-0.015859630.03861602-0.05152532-0.001073740.09290953-0.009655110.002403250.071071890.059569970.06217197-0.01331182-0.059687950.02029386-0.001073940.016865760.04524625-0.04640153-0.008357290.008975030.016009420.001611560.05964108-0.019374380.01566052-0.055922460.04318756-0.027698060.035734150.0080887726711756.49Overall Deviatio

1All Long0

Downside Devia

0All Short

Semi-Deviation (Sortino)Long/Short

Calculation Data

0.065396410.02214569-0.00592520.019986680.072755510.06895060.14847030.021625460.076537570.07968654

0.020779130.043001980.111021210.04267667-0.07303570

-0.05004240.00815246-0.0161248-0.1513944-0.0762221-0.0719904-0.045238-0.1275609-0.0208266-0.1081395-0.0837675-0.0977836-0.1761222-0.04918030.022740760.121686160.0896730.002890170.086643930.10394628-0.0550049-0.0858117-0.0718366-0.0554755-0.0355153-0.07614210.167215070.043459790.168370310.08085431-0.05595670.229395540.060722420.089015930.1671960.163726180.076481840.096239340.03378979-0.0470489-0.0944925-0.0406307-0.0124334-0.07930560.036670420.104908980.068848940.051200950.107194320.157116440.05195932-0.00644940.01075806-0.03066740.073749120.024966320.04093468-0.03580580.021720380.017369660.043872950.02716214-0.0133065-0.0447705-0.04343010.01707317-0.03884060.016109330.004648440.02087436-0.07270430.061151140.011761130.07760815-0.006569-0.0287834-0.0277155-0.06497190.03219082-0.048387-0.03495940.03958419-0.0427962-0.0912386-0.0918279-0.03828170.163285270.053846080.19216801-0.1289894-0.118919-0.0691536-0.0144694-0.0230697-0.10391090.0389313-0.0891375-0.0820798-0.0091208-0.0642858-0.0479149-0.0323292-0.0423930.023868870.061523030.069907570.150667910.187547460.216797680.14250245-0.0557834-0.03219590.011389740.0044757-0.0676641-0.04333240.05965460.014855340.077595590.02673450.03099927-0.18181820.127111260.13751922-0.1018579-0.04091750.094800180.102260960.188310540.081915110.06574613-0.04137040.062681680.036866390.105283490.016383040.037185680.026298040.04317428-0.0030769-0.0259695-0.0074395-0.05674950.02102497-0.0221510.01028099-0.0107023-0.0824005-0.0396627-0.019305-0.0745157-0.09965990.010852770.04796158-0.00136010.038713910.042512080.122025060.04582191-0.03661330.091195870.00063171-0.04603030.018939460.093876820.052737520.08234199-0.07512630.012629570.048013210.00279605-0.03439330.101315180.090784980.03741602-0.0060032-0.1076002-0.0409946-0.09834330.053817270.04901357-0.010141-0.0123745-0.05960960.026561790.114608080.017043840.03539255-0.09074280.003380860.012901510.060202450.088702660.041221-0.14408940.027705030.06829424-0.01356790.003980940.06572624-0.0252860.021135290.060223170.08558330.03912236-0.03576460.002854530.02913677-0.00874940.104176540.1070974-0.05578270.000271230.156938020.03825280.050998680.035845630.013918850.022419060.061774260.056574970.0634856-0.04813670.03050646-0.1182932-0.01031520.01050254-0.04448670.06175719-0.09088220.14122515-0.07817030.008382770.117787550.037752370.057428560.083766810.05638683-0.0460152-0.0345318-0.0323604-0.0151468-0.0214894-0.00359290.034254370.223082480.135300520.041117290.09638190.064002450.176582-0.00693390.043896840.01360805

Page 27

Input

0.028070420.04033235-0.055692710.073624950.018176440.01674356-0.009763390.020060880.031380580.02783493-0.01683885-0.06182780.02711456-0.02159145-0.026819860.08087692-0.024775940.047825050.01451178-0.02888215-0.00851467

0.012338740.047247211.1336869

0.070052640.00890172-0.10769660.057510710.019952860.099396380.078709360.027661840.028731290.07750883-0.01707310.071960260.10597873-0.0718910.061424190.10077655-0.03137170.005786430.04533907-0.0372275-0.02439610.08498098-0.01888280.011494270.020012570.06995556-0.01439370.02051520.018563830.035011940.059169320.020471090.012726460.02474017-0.0284459-0.13024760.09312032-0.07274790.19626162-0.0303343-0.05783180.061834630.028149220.057682660.053769480.0293657-0.0831983-0.0411120.068744430.0227761-0.00875710.004848580.01038874-0.0349076-0.0330885-0.03354710.012983860.04665616-0.0140945-0.0106904-0.0062868-0.00968240.230575560.122647270.09356406-0.1095450.07386837-0.07163170.00139273-0.03616130.013852780.019356670.075397850.058166760.130061330.12356141-0.0237728-0.12908330.006592340.00361337-0.04207920.00869154-0.0850023-0.04759490.047215010.05459673-0.01152310.15948637-0.0421099-0.06160630.046198770.12116517-0.04297960.03826718-0.03769120.013441260.05077006-0.0133008-0.03535080.12790534-0.06523380.028671840.039836950.024276220.003456350.053432910.08415978-0.0324780.059891590.046024020.002245850.02788648-0.0354594-0.00055310.02822478-0.07825670.023272420.086043570.06036316-0.06596180.04607307-0.01528980.01443594-0.0029803-0.0733502-0.0124587

Page 28

Input

1All Long

0.043620760.008571820.005848-0.0240151-0.01421040.0398444-0.03629190.08941770.0705234-0.01052480.037466220.103843060.003215740.007351060.04605384-0.00524420.015509440.06004085-0.05054390.017218330.055812890.02234601-0.02191490.047422250.025420940.06059067-0.0075246-0.06457360.013893250.0020451-0.00152080.06466506-0.06228-0.01865090.007786550.06014103-0.0068680.0620923-0.05044540.03187042-0.08129030.02056406-0.0608020.01596523-0.03223880.066712510.085728230.02467467-0.0555572-0.091970.05912586-0.13568960.086587520.044270670.06362377-0.00614360.020446940.0089361-0.06008380.14717543-0.02001-0.01554860.0076714-0.0897210.060109290.149953150.02409451-0.02649540.089484530.025541090.046130990.00995731-0.08354540.03134678-0.0356472-0.0253888-0.0873943-0.0454545-0.08591490.053653540.020368550.003061210.045977010.096611750.02332865-0.0020593-0.0367313-0.04905450.042766150.067626480.026356660.134440790.07856238-0.1771607-0.09527340.09784378-0.11102680.101954030.10986854-0.08162580.02496252-0.02878250.20288791-0.08338580.066160790.039431580.0366911-0.0257948-0.0846677-0.04877170.11810424-0.0031627-0.07170010.17771690.00406241-0.0407513-0.0135581-0.24679310.01459828-0.0503597-0.1085857-0.0619041-0.06240430.043289010.060190930.305720110.053625110.03294155-0.0648991-0.00335790.00371922-0.04990610.087677460.004417660.00792670.082777050.069872620.0345754-0.1399925-0.07987910.08259029-0.13350660.095547710.04383569-0.16185480.055845410.0454771-0.1224587-0.07273330.02157447-0.041096-0.07083330.02694718-0.0187852-0.01084880.200224780.0059363-0.03004290.090455070.011704760.06388337-0.0431962-0.18998010.05143898-0.06670560.196238240.0010482-0.09544310.110782910.039132670.046819320.014098340.001917460.009048420.152963640.009121080.05875048-0.08909740.0051481-0.0300947

Page 29

Input

0.00800691-0.01662550.043911480.08892621-0.0580584-0.05469960.053798620.018586350.039531270.042407160.02067640.03409531-0.05617460.0323998-0.01676060.131039530.057372880.096763750.009220410.03724655-0.0128445-0.0028638-0.133962-0.0232625-0.00681310.10244761-0.0106678-0.0257718-0.0444403-0.08955630.063700950.01357421-0.0088922-0.05954890.067227390.04093372-0.00207910.06633442-0.0412024-0.1172374-0.0104512-0.04963840-0.058067300.055529410-0.01572330-0.005020600.0284404200.0395861700.0653396100.0093420100.023042070-0.009512500.014879140-0.027810900.1295464500.00651230-0.045602600.119074740-0.059956400.047221200.016649350-0.063118500.03853215

Page 30

因篇幅问题不能全部显示,请点此查看更多更全内容