UpsideRisk
Updated 2024-02-29 21:01:55.357000
Syntax
SELECT [westclintech].[wct].[UpsideRisk](
<@R, float,>
,<@MAR, float,>
,<@Full, bit,>,
,<@State, nvarchar(4000),>))
Description
Use the aggregate function UpsideRisk to calculate the Upside Risk, Upside Variance or Upside Deviation.
\rm{UpsideRisk=\sqrt{\frac{\Sigma_{i=1}^n{max}\left(0,R_i-MAR\right)^2}{n}}}
\rm{UpsideVariance=\frac{\Sigma_{i=1}^n{max}\left(0,R_i-MAR\right)^2}{n}}
\rm{UpsidePotential=\frac{\Sigma_{i=1}^n{max}\left(0,R_i-MAR\right)}{n}}
Where
{"columns":[{"field":"column 1"},{"field":"column 2"},{"field":"column 3"}],"rows":[{"column 1":"R","column 2":"=","column 3":"asset return"},{"column 1":"MAR","column 2":"=","column 3":"minimum acceptable return"},{"column 1":"n","column 2":"=","column 3":"n is either the rows in the GROUP or the number of rows where R < MAR"}]}
Arguments
@MAR
the minimum acceptable return in floating point format (i.e. 10% = 0.10). @MAR is an expression of type float or of a type that can be implicitly converted to float.
@Full
a bit value which determines the treatment of n. When @Full is TRUE then nu and nd are the number of non-null rows in the GROUP; when @Full is FALSE then nu is the number of rows where @R > @MAR and nd is the number of rows where @R < @MAR.
@State
A sting value determining the return value. Use 'VARIANCE' for UpsideVariance; 'RISK' for UpsideRisk; or POTENTIAL for UpsidePotential.
@R
the asset return for a period; the percentage return in floating point format (i.e. 10% = 0.10). @R is an expression of type float or of a type that can be implicitly converted to float.
Return Type
float
Remarks
If @R IS NULL it is not included in the calculation.
If @MAR IS NULL it is set to zero.
If there are no non-NULL rows in a GROUP then NULL is returned.
@MAR must be the same for all values in a GROUP.
If @Full IS NULL then @Full is set to TRUE.
If @Full is TRUE, then n equals the number of rows in the GROUP, else n = the number of rows where R < MAR in the GROUP
Examples
In this example we have monthly returns for an asset and its benchmark for the last three years. The minimum acceptable return is 0.005.
SELECT wct.UpsideRisk(Ra, 0.005, 'False', 'POTENTIAL') AS UpsidePotential,
wct.UpsideRisk(Ra, 0.005, 'False', 'RISK') AS UpsideRisk,
wct.UpsideRisk(Ra, 0.005, 'False', 'VARIANCE') AS UpsideVariance
FROM
(
VALUES
('2012-12-31', 0.001378, -0.003929),
('2013-01-31', 0.028677, -0.001701),
('2013-02-28', 0.005801, 0.003165),
('2013-03-31', 0.01442, -0.006487),
('2013-04-30', 0.00229, -0.004653),
('2013-05-31', 0.014905, 0.009577),
('2013-06-30', 0.008594, 0.00588),
('2013-07-31', 0.011531, 0.005089),
('2013-08-31', 0.008268, 0.005233),
('2013-09-30', 0.013993, -0.004338),
('2013-10-31', 0.009147, -0.006109),
('2013-11-30', -0.00316, -0.002222),
('2013-12-31', -0.00595, 0.005451),
('2014-01-31', 0.013398, -0.008099),
('2014-02-28', 0.002847, -0.000299),
('2014-03-31', -0.009544, -0.009809),
('2014-04-30', 0.002516, 0.008875),
('2014-05-31', 0.004626, -0.002681),
('2014-06-30', -0.002141, 0.000312),
('2014-07-31', 0.009247, 0.00936),
('2014-08-31', -0.01253, 0.005434),
('2014-09-30', 0.00441, 0.008157),
('2014-10-31', 0.01626, -0.006766),
('2014-11-30', 0.013207, 0.005742),
('2014-12-31', -0.008561, -0.005063),
('2015-01-31', 0.012357, 0.004357),
('2015-02-28', -0.002057, -0.00044),
('2015-03-31', 0.008217, -0.004866),
('2015-04-30', -0.013439, -0.007649),
('2015-05-31', 0.004391, -0.002073),
('2015-06-30', -0.008997, 0.00399),
('2015-07-31', -0.001878, -0.00613),
('2015-08-31', -0.014381, -0.00351),
('2015-09-30', -0.001885, 0.001172),
('2015-10-31', -0.001121, -0.000024),
('2015-11-30', 0.000816, 0.002596),
('2015-12-31', -0.003088, -0.009025)
) n (dt, Ra, Rb);
This produces the following result.
{"columns":[{"field":"UpsidePotential","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"UpsideRisk","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"UpsideVariance","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"UpsidePotential":"0.0075348","UpsideRisk":"0.00916366023668126","UpsideVariance":"8.39726689333333E-05"}]}
In this example we have the monthly returns for 6 managers plus a benchmark stored in the #managers table which is in 'spreadsheet' format. The minimum acceptable rate is 0.005.
SELECT *
INTO #managers
FROM ( VALUES ('2012-12-31', -0.002546, NULL, NULL, 0.003006, NULL, 0.005007, -0.001839, 0.00142),
('2013-01-31', 0.00977, NULL, NULL, 0.001, NULL, -0.007579, 0.008614, 0.00075),
('2013-02-28', 0.024726, NULL, NULL, 0.005703, NULL, 0.006496, -0.004624, 0.001579),
('2013-03-31', 0.000942, NULL, NULL, 0.007578, NULL, 0.008333, 0.005031, 0.00017),
('2013-04-30', 0.022139, NULL, NULL, 0.007118, NULL, -0.007312, -0.005431, 0.001034),
('2013-05-31', 0.019449, NULL, NULL, 0.005659, NULL, -0.003902, -0.001878, 0.00071),
('2013-06-30', -0.007964, NULL, NULL, 0.003757, NULL, -0.001899, -0.00706, 0.000256),
('2013-07-31', -0.008262, -0.002824, NULL, 0.003762, NULL, -0.007347, -0.001982, 0.00101),
('2013-08-31', 0.009617, 0.007319, NULL, 0.0022, NULL, -0.002116, 0.003867, 0.001522),
('2013-09-30', -0.004118, 0.004128, NULL, 0.001394, NULL, 0.008333, 0.001356, 0.001119),
('2013-10-31', 0.010754, -0.001578, NULL, 0.003483, NULL, -0.004724, -0.001342, 0.001232),
('2013-11-30', 0.002402, 0.020835, NULL, 0.001, NULL, 0.003954, -0.000306, 0.001374),
('2013-12-31', 0.004581, 0.015689, NULL, 0.002146, NULL, 0.008333, 0.001118, 0.001406),
('2014-01-31', -0.00055, -0.001027, -0.008245, 0.00732, NULL, 0.004025, -0.007227, 0.000624),
('2014-02-28', -0.001512, 0.001653, -0.009029, 0.009919, NULL, -0.008333, -0.003878, 0.00164),
('2014-03-31', 0.008784, 0.004364, -0.011608, 0.001, NULL, -0.008333, -0.004822, 0.001427),
('2014-04-30', 0.008412, -0.012369, -0.004692, 0.004536, NULL, -0.006303, 0.004306, 0.001618),
('2014-05-31', 0.003945, 0.010651, -0.016833, 0.001, NULL, -0.007974, 0.005221, 0.000937),
('2014-06-30', 0.012371, 0.01773, -0.010384, 0.010593, NULL, -0.004781, -0.000731, 0.0008),
('2014-07-31', 0.011915, 0.004308, -0.012965, 0.001, NULL, 0.007751, -0.009239, 0.001733),
('2014-08-31', -0.013738, 0.00039, 0.000009, 0.005139, 0.001, -0.003319, -0.003636, 0.000325),
('2014-09-30', -0.004081, 0.01968, -0.008214, 0.007976, 0.001, -0.003799, 0.005563, 0.000535),
('2014-10-31', 0.01608, 0.015291, -0.002969, 0.01303, 0.001, -0.004645, 0.001599, 0.001325),
('2014-11-30', 0.011241, 0.012312, 0.007088, 0.00384, 0.000852, 0.006783, -0.008487, 0.001152),
('2014-12-31', -0.004251, 0.008737, -0.013576, 0.001, 0.001, -0.0034, 0.001013, 0.001246),
('2015-01-31', -0.004039, 0.012938, -0.011891, 0.004576, 0.001, -0.004195, -0.002653, 0.000372),
('2015-02-28', 0.026326, 0.019695, -0.013178, 0.010737, 0.001, 0.006418, -0.00952, 0.001045),
('2015-03-31', -0.000628, 0.008029, 0.005917, 0.017461, 0.00048, -0.00501, 0.007879, 0.001419),
('2015-04-30', 0.005688, 0.01249, -0.018813, 0.001, -0.002104, 0.003657, 0.009886, 0.001383),
('2015-05-31', 0.010039, 0.008442, -0.01465, 0.001, 0.001, 0.001024, 0.001695, 0.000783),
('2015-06-30', -0.004267, 0.001391, -0.022504, 0.003104, 0.001, -0.003507, 0.009854, 0.0007),
('2015-07-31', -0.001672, 0.020558, -0.011859, 0.001, 0.001, NULL, 0.008361, 0.001188),
('2015-08-31', 0.015726, 0.017419, -0.004556, 0.001, -0.000462, NULL, -0.007253, 0.000771),
('2015-09-30', 0.001977, 0.007301, -0.00811, 0.013011, -0.001032, NULL, 0.009911, 0.000742),
('2015-10-31', 0.016201, 0.00877, -0.005536, 0.014527, -0.000833, NULL, 0.009897, 0.001119),
('2015-11-30', 0.019996, -0.000785, -0.002161, 0.001947, 0.001, NULL, -0.007307, 0.001116),
('2015-12-31', -0.003254, 0.009595, -0.013785, 0.001, 0.001, NULL, 0.007196, 0.001332)) n (dt, man1,
man2,
man3,
man4,
man5,
man6,
bmark, rf);
To calculate the upside risk for each manager against a minimum acceptable return of 0.5% we run the following SQL.
SELECT n.s as [State],
p.f as [Full],
wct.UpsideRisk(man1, 0.005, p.f, n.s) as man1,
wct.UpsideRisk(man2, 0.005, p.f, n.s) as man2,
wct.UpsideRisk(man3, 0.005, p.f, n.s) as man3,
wct.UpsideRisk(man4, 0.005, p.f, n.s) as man4,
wct.UpsideRisk(man5, 0.005, p.f, n.s) as man5,
wct.UpsideRisk(man6, 0.005, p.f, n.s) as man6,
wct.UpsideRisk(bmark, 0.005, p.f, n.s) as bmark
FROM #managers
CROSS APPLY
(
VALUES
('POTENTIAL'),
('RISK'),
('VARIANCE')
) n (s)
CROSS APPLY
(
VALUES
(0),
(1)
) p (f)
GROUP BY n.s,
p.f;
This produces the following result.
{"columns":[{"field":"State"},{"field":"Full","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"man1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"man2","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"man3","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"man4","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"man5"},{"field":"man6","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"bmark","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"State":"POTENTIAL","Full":"0","man1":"0.00940188888888889","man2":"0.00834110526315789","man3":"0.0015025","man4":"0.00469792857142857","man5":"NULL","man6":"0.00218175","bmark":"0.00294663636363636"},{"State":"RISK","Full":"0","man1":"0.0110671949773493","man2":"0.0095866838210202","man3":"0.0016125496891569","man4":"0.00591250155542112","man5":"NULL","man6":"0.00245770589168029","bmark":"0.00348200552190048"},{"State":"VARIANCE","Full":"0","man1":"0.000122482804666667","man2":"9.19045066842105E-05","man3":"2.6003165E-06","man4":"3.49576746428571E-05","man5":"NULL","man6":"6.04031825E-06","bmark":"1.21243624545455E-05"},{"State":"POTENTIAL","Full":"1","man1":"0.00457389189189189","man2":"0.0052827","man3":"0.000125208333333333","man4":"0.00177759459459459","man5":"0","man6":"0.000563032258064516","bmark":"0.000876027027027027"},{"State":"RISK","Full":"1","man1":"0.00771921170180591","man2":"0.00762929797338305","man3":"0.00046550299855819","man4":"0.00363692565819584","man5":"0","man6":"0.00124851584149005","bmark":"0.00189856266401433"},{"State":"VARIANCE","Full":"1","man1":"5.95862292972973E-05","man2":"5.82061875666667E-05","man3":"2.16693041666667E-07","man4":"1.32272282432432E-05","man5":"0","man6":"1.55879180645161E-06","bmark":"3.60454018918919E-06"}]}
Using the same data from the previous example in the #nmanagers table which is in 3rd normal form we perform the same calculation.
SELECT *
INTO #nmanagers
FROM
(
VALUES
('2012-12-31', 'man1', -0.002546),
('2012-12-31', 'man4', 0.003006),
('2012-12-31', 'man6', 0.005007),
('2012-12-31', 'bmark', -0.001839),
('2013-01-31', 'man1', 0.009770),
('2013-01-31', 'man4', 0.001000),
('2013-01-31', 'man6', -0.007579),
('2013-01-31', 'bmark', 0.008614),
('2013-02-28', 'man1', 0.024726),
('2013-02-28', 'man4', 0.005703),
('2013-02-28', 'man6', 0.006496),
('2013-02-28', 'bmark', -0.004624),
('2013-03-31', 'man1', 0.000942),
('2013-03-31', 'man4', 0.007578),
('2013-03-31', 'man6', 0.008333),
('2013-03-31', 'bmark', 0.005031),
('2013-04-30', 'man1', 0.022139),
('2013-04-30', 'man4', 0.007118),
('2013-04-30', 'man6', -0.007312),
('2013-04-30', 'bmark', -0.005431),
('2013-05-31', 'man1', 0.019449),
('2013-05-31', 'man4', 0.005659),
('2013-05-31', 'man6', -0.003902),
('2013-05-31', 'bmark', -0.001878),
('2013-06-30', 'man1', -0.007964),
('2013-06-30', 'man4', 0.003757),
('2013-06-30', 'man6', -0.001899),
('2013-06-30', 'bmark', -0.007060),
('2013-07-31', 'man1', -0.008262),
('2013-07-31', 'man2', -0.002824),
('2013-07-31', 'man4', 0.003762),
('2013-07-31', 'man6', -0.007347),
('2013-07-31', 'bmark', -0.001982),
('2013-08-31', 'man1', 0.009617),
('2013-08-31', 'man2', 0.007319),
('2013-08-31', 'man4', 0.002200),
('2013-08-31', 'man6', -0.002116),
('2013-08-31', 'bmark', 0.003867),
('2013-09-30', 'man1', -0.004118),
('2013-09-30', 'man2', 0.004128),
('2013-09-30', 'man4', 0.001394),
('2013-09-30', 'man6', 0.008333),
('2013-09-30', 'bmark', 0.001356),
('2013-10-31', 'man1', 0.010754),
('2013-10-31', 'man2', -0.001578),
('2013-10-31', 'man4', 0.003483),
('2013-10-31', 'man6', -0.004724),
('2013-10-31', 'bmark', -0.001342),
('2013-11-30', 'man1', 0.002402),
('2013-11-30', 'man2', 0.020835),
('2013-11-30', 'man4', 0.001000),
('2013-11-30', 'man6', 0.003954),
('2013-11-30', 'bmark', -0.000306),
('2013-12-31', 'man1', 0.004581),
('2013-12-31', 'man2', 0.015689),
('2013-12-31', 'man4', 0.002146),
('2013-12-31', 'man6', 0.008333),
('2013-12-31', 'bmark', 0.001118),
('2014-01-31', 'man1', -0.000550),
('2014-01-31', 'man2', -0.001027),
('2014-01-31', 'man3', -0.008245),
('2014-01-31', 'man4', 0.007320),
('2014-01-31', 'man6', 0.004025),
('2014-01-31', 'bmark', -0.007227),
('2014-02-28', 'man1', -0.001512),
('2014-02-28', 'man2', 0.001653),
('2014-02-28', 'man3', -0.009029),
('2014-02-28', 'man4', 0.009919),
('2014-02-28', 'man6', -0.008333),
('2014-02-28', 'bmark', -0.003878),
('2014-03-31', 'man1', 0.008784),
('2014-03-31', 'man2', 0.004364),
('2014-03-31', 'man3', -0.011608),
('2014-03-31', 'man4', 0.001000),
('2014-03-31', 'man6', -0.008333),
('2014-03-31', 'bmark', -0.004822),
('2014-04-30', 'man1', 0.008412),
('2014-04-30', 'man2', -0.012369),
('2014-04-30', 'man3', -0.004692),
('2014-04-30', 'man4', 0.004536),
('2014-04-30', 'man6', -0.006303),
('2014-04-30', 'bmark', 0.004306),
('2014-05-31', 'man1', 0.003945),
('2014-05-31', 'man2', 0.010651),
('2014-05-31', 'man3', -0.016833),
('2014-05-31', 'man4', 0.001000),
('2014-05-31', 'man6', -0.007974),
('2014-05-31', 'bmark', 0.005221),
('2014-06-30', 'man1', 0.012371),
('2014-06-30', 'man2', 0.017730),
('2014-06-30', 'man3', -0.010384),
('2014-06-30', 'man4', 0.010593),
('2014-06-30', 'man6', -0.004781),
('2014-06-30', 'bmark', -0.000731),
('2014-07-31', 'man1', 0.011915),
('2014-07-31', 'man2', 0.004308),
('2014-07-31', 'man3', -0.012965),
('2014-07-31', 'man4', 0.001000),
('2014-07-31', 'man6', 0.007751),
('2014-07-31', 'bmark', -0.009239),
('2014-08-31', 'man1', -0.013738),
('2014-08-31', 'man2', 0.000390),
('2014-08-31', 'man3', 0.000009),
('2014-08-31', 'man4', 0.005139),
('2014-08-31', 'man5', 0.001000),
('2014-08-31', 'man6', -0.003319),
('2014-08-31', 'bmark', -0.003636),
('2014-09-30', 'man1', -0.004081),
('2014-09-30', 'man2', 0.019680),
('2014-09-30', 'man3', -0.008214),
('2014-09-30', 'man4', 0.007976),
('2014-09-30', 'man5', 0.001000),
('2014-09-30', 'man6', -0.003799),
('2014-09-30', 'bmark', 0.005563),
('2014-10-31', 'man1', 0.016080),
('2014-10-31', 'man2', 0.015291),
('2014-10-31', 'man3', -0.002969),
('2014-10-31', 'man4', 0.013030),
('2014-10-31', 'man5', 0.001000),
('2014-10-31', 'man6', -0.004645),
('2014-10-31', 'bmark', 0.001599),
('2014-11-30', 'man1', 0.011241),
('2014-11-30', 'man2', 0.012312),
('2014-11-30', 'man3', 0.007088),
('2014-11-30', 'man4', 0.003840),
('2014-11-30', 'man5', 0.000852),
('2014-11-30', 'man6', 0.006783),
('2014-11-30', 'bmark', -0.008487),
('2014-12-31', 'man1', -0.004251),
('2014-12-31', 'man2', 0.008737),
('2014-12-31', 'man3', -0.013576),
('2014-12-31', 'man4', 0.001000),
('2014-12-31', 'man5', 0.001000),
('2014-12-31', 'man6', -0.003400),
('2014-12-31', 'bmark', 0.001013),
('2015-01-31', 'man1', -0.004039),
('2015-01-31', 'man2', 0.012938),
('2015-01-31', 'man3', -0.011891),
('2015-01-31', 'man4', 0.004576),
('2015-01-31', 'man5', 0.001000),
('2015-01-31', 'man6', -0.004195),
('2015-01-31', 'bmark', -0.002653),
('2015-02-28', 'man1', 0.026326),
('2015-02-28', 'man2', 0.019695),
('2015-02-28', 'man3', -0.013178),
('2015-02-28', 'man4', 0.010737),
('2015-02-28', 'man5', 0.001000),
('2015-02-28', 'man6', 0.006418),
('2015-02-28', 'bmark', -0.009520),
('2015-03-31', 'man1', -0.000628),
('2015-03-31', 'man2', 0.008029),
('2015-03-31', 'man3', 0.005917),
('2015-03-31', 'man4', 0.017461),
('2015-03-31', 'man5', 0.000480),
('2015-03-31', 'man6', -0.005010),
('2015-03-31', 'bmark', 0.007879),
('2015-04-30', 'man1', 0.005688),
('2015-04-30', 'man2', 0.012490),
('2015-04-30', 'man3', -0.018813),
('2015-04-30', 'man4', 0.001000),
('2015-04-30', 'man5', -0.002104),
('2015-04-30', 'man6', 0.003657),
('2015-04-30', 'bmark', 0.009886),
('2015-05-31', 'man1', 0.010039),
('2015-05-31', 'man2', 0.008442),
('2015-05-31', 'man3', -0.014650),
('2015-05-31', 'man4', 0.001000),
('2015-05-31', 'man5', 0.001000),
('2015-05-31', 'man6', 0.001024),
('2015-05-31', 'bmark', 0.001695),
('2015-06-30', 'man1', -0.004267),
('2015-06-30', 'man2', 0.001391),
('2015-06-30', 'man3', -0.022504),
('2015-06-30', 'man4', 0.003104),
('2015-06-30', 'man5', 0.001000),
('2015-06-30', 'man6', -0.003507),
('2015-06-30', 'bmark', 0.009854),
('2015-07-31', 'man1', -0.001672),
('2015-07-31', 'man2', 0.020558),
('2015-07-31', 'man3', -0.011859),
('2015-07-31', 'man4', 0.001000),
('2015-07-31', 'man5', 0.001000),
('2015-07-31', 'bmark', 0.008361),
('2015-08-31', 'man1', 0.015726),
('2015-08-31', 'man2', 0.017419),
('2015-08-31', 'man3', -0.004556),
('2015-08-31', 'man4', 0.001000),
('2015-08-31', 'man5', -0.000462),
('2015-08-31', 'bmark', -0.007253),
('2015-09-30', 'man1', 0.001977),
('2015-09-30', 'man2', 0.007301),
('2015-09-30', 'man3', -0.008110),
('2015-09-30', 'man4', 0.013011),
('2015-09-30', 'man5', -0.001032),
('2015-09-30', 'bmark', 0.009911),
('2015-10-31', 'man1', 0.016201),
('2015-10-31', 'man2', 0.008770),
('2015-10-31', 'man3', -0.005536),
('2015-10-31', 'man4', 0.014527),
('2015-10-31', 'man5', -0.000833),
('2015-10-31', 'bmark', 0.009897),
('2015-11-30', 'man1', 0.019996),
('2015-11-30', 'man2', -0.000785),
('2015-11-30', 'man3', -0.002161),
('2015-11-30', 'man4', 0.001947),
('2015-11-30', 'man5', 0.001000),
('2015-11-30', 'bmark', -0.007307),
('2015-12-31', 'man1', -0.003254),
('2015-12-31', 'man2', 0.009595),
('2015-12-31', 'man3', -0.013785),
('2015-12-31', 'man4', 0.001000),
('2015-12-31', 'man5', 0.001000),
('2015-12-31', 'bmark', 0.007196)
) n (dt, man, R);
SELECT n.s as [State],
p.f as [Full],
man,
wct.UpsideRisk(R, 0.005, p.f, n.s)
FROM #nmanagers
CROSS APPLY
(
VALUES
('POTENTIAL'),
('RISK'),
('VARIANCE')
) n (s)
CROSS APPLY
(
VALUES
(0),
(1)
) p (f)
GROUP BY n.s,
p.f,
man;
This produces the following result.
State Full man UpsideRisk Value
--------- ----------- ----- ----------------------
POTENTIAL 0 bmark 0.00294663636363636
POTENTIAL 0 man1 0.00940188888888889
POTENTIAL 0 man2 0.00834110526315789
POTENTIAL 0 man3 0.0015025
POTENTIAL 0 man4 0.00469792857142857
POTENTIAL 0 man5 NULL
POTENTIAL 0 man6 0.00218175
POTENTIAL 1 bmark 0.000876027027027027
POTENTIAL 1 man1 0.00457389189189189
POTENTIAL 1 man2 0.0052827
POTENTIAL 1 man3 0.000125208333333333
POTENTIAL 1 man4 0.00177759459459459
POTENTIAL 1 man5 0
POTENTIAL 1 man6 0.000563032258064516
RISK 0 bmark 0.00348200552190048
RISK 0 man1 0.0110671949773493
RISK 0 man2 0.0095866838210202
RISK 0 man3 0.0016125496891569
RISK 0 man4 0.00591250155542112
RISK 0 man5 NULL
RISK 0 man6 0.00245770589168029
RISK 1 bmark 0.00189856266401433
RISK 1 man1 0.00771921170180591
RISK 1 man2 0.00762929797338305
RISK 1 man3 0.00046550299855819
RISK 1 man4 0.00363692565819584
RISK 1 man5 0
RISK 1 man6 0.00124851584149005
VARIANCE 0 bmark 1.21243624545455E-05
VARIANCE 0 man1 0.000122482804666667
VARIANCE 0 man2 9.19045066842105E-05
VARIANCE 0 man3 2.6003165E-06
VARIANCE 0 man4 3.49576746428571E-05
VARIANCE 0 man5 NULL
VARIANCE 0 man6 6.04031825E-06
VARIANCE 1 bmark 3.60454018918919E-06
VARIANCE 1 man1 5.95862292972973E-05
VARIANCE 1 man2 5.82061875666667E-05
VARIANCE 1 man3 2.16693041666667E-07
VARIANCE 1 man4 1.32272282432432E-05
VARIANCE 1 man5 0
VARIANCE 1 man6 1.55879180645161E-06
See Also
DOWNSIDEDEVIATION - Calculate the downside deviation of asset returns
DOWNSIDEFREQUENCY - Calculate the downside frequency of asset returns
DOWNSIDEPOTENTIAL - Calculate the downside potential of asset returns
OMEGA - Calculate the Omega of asset returns
OMEGAEXCESSRETURN - Calculate the Omega Excess Return
OMEGASHARPERATIO - Calculate the Omega-Sharpe ratio of asset returns
UPSIDEFREQUENCY - Calculate the upside frequency of asset returns