Thanks. Omega is gaining popularity in the alternative asset management
world where returns are not normally distributed. To confirm, the formula
below only works on normally distributed returns? I'm also wondering where
in the formula I put in the cell ranges that contain the data?
"Jerry W. Lewis" wrote:
I see why I could not find anything. The authors are at a center in London,
not at Duke University. The references suggest that this work has not yet
been published in refereed journals, and the document is labeled "Not for
Circulation".
For the Normal distribution, omega can be calculated as
=((mu-r)*2*NORMSDIST(-(r-mu)/sigma)*SQRT(Pi)*EXP((r^2+mu^2)/sigma^2/2)+SQRT(2)*EXP(1/sigma^2*r*mu)*sigma)
/((r-mu)*2*NORMSDIST((r-mu)/sigma)*SQRT(Pi)*EXP((r^2+mu^2)/sigma^2/2)+SQRT(2)*EXP(1/sigma^2*r*mu)*sigma)
For other distributions, I suspect that numerical integration would be
required, and I doubt that Microsoft will be interested until both of the
following occur:
- Use of this characteristic of a probability distribution becomes widespread
- Microsoft has implemented better algorithms to calculate the probability
distributions that they have.
Jerry
"macrohunter" wrote:
Thanks. This paper and others on Omega can be found at
http://faculty.fuqua.duke.edu/~charv...ng/BA453_2006/
Scroll down to Keating, and you can see some of his papers on Omega. The
Omega Function seems most useful. Continue to scroll down for two other pdf
files listed under Omega.
Keating_An_introducti+ 07-Jan-2004 14:00 190K
Keating_Asset_optimiz+ 07-Jan-2004 14:06 468K
Keating_The_omega_fun+ 07-Jan-2004 14:08 568K
"Jerry W. Lewis" wrote:
You need to provide more information. I cannot find anything in Current
Index to Statistics by anyone named Shadwick nor can I find anything by a
Keating that also has "Omega" in the title or keywords. A search of the Duke
online phonebook also failed to find a Shadwick, and none of the three
Keatings seemed likely to be called "Con".
Jerry
"macrohunter" wrote:
Con Keating and William Shadwick at Duke University wrote a paper, An
Introduction to Omega, in which they describe Omega. It would be great if
Excel added it to its statistical functions. In the meantime, does anyone
know how to write the formula in excel?