In Europe, the transformation in the sovereign debt market since Mario Draghi’s “whatever it takes” promise in July 2012 has been remarkable. Ireland, which just exited an IMF bailout program in December, can now issue 5-year debt at yields well below 5-year Treasuries.
In 2012, 63 percent of large-cap funds, 80 percent of mid-cap funds and 67 percent of small-cap funds underperformed [relative to their benchmark]. The only asset class to see the majority of active funds outperform was large-cap growth, with 54 percent beating their benchmarks. The worst performance came in mid-cap growth funds where 87 percent failed to outperform.
/* Convert the annualized number back to a percent */SELECT(T3.AnnHPR-1)*100ASGeomAnnRetFROM(/* Annualize the holding period return */SELECTPOWER(T2.HPR,12.0/T2.NumReturns)ASAnnHPRFROM(/* Calculate the holding period return over the time
period.
POWER(10, SUM(LOG10(n))) is a simulated PRODUCT(n)
aggregate function.
The precision of POWER is determined by the precision
of the first argument, so use a lot of decimals. */SELECTPOWER(10.0000000000000000,SUM(LOG10(T.MonthReturn)))ASHPR,COUNT(*)ASNumReturnsFROM(/* Convert all percent returns to multipliers (1% ->
1.01) */SELECT1+MonthPctReturn/100ASMonthReturnFROM...)AST)AST2)AST3
Update 2008-01-30 10:52PM: Here’s the equivalent “one-liner”: