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?
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 quot;Omegaquot; 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 quot;Conquot;.
Jerry
quot;macrohunterquot; wrote:
gt; Con Keating and William Shadwick at Duke University wrote a paper, An
gt; Introduction to Omega, in which they describe Omega. It would be great if
gt; Excel added it to its statistical functions. In the meantime, does anyone
gt; know how to write the formula in excel?
Thanks. This paper and others on Omega can be found at
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 568Kquot;Jerry W. Lewisquot; wrote:
gt; You need to provide more information. I cannot find anything in Current
gt; Index to Statistics by anyone named Shadwick nor can I find anything by a
gt; Keating that also has quot;Omegaquot; in the title or keywords. A search of the Duke
gt; online phonebook also failed to find a Shadwick, and none of the three
gt; Keatings seemed likely to be called quot;Conquot;.
gt;
gt; Jerry
gt;
gt; quot;macrohunterquot; wrote:
gt;
gt; gt; Con Keating and William Shadwick at Duke University wrote a paper, An
gt; gt; Introduction to Omega, in which they describe Omega. It would be great if
gt; gt; Excel added it to its statistical functions. In the meantime, does anyone
gt; gt; know how to write the formula in excel?
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 quot;Not for
Circulationquot;.
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
quot;macrohunterquot; wrote:
gt; Thanks. This paper and others on Omega can be found at
gt; faculty.fuqua.duke.edu/~charv...ng/BA453_2006/
gt;
gt; Scroll down to Keating, and you can see some of his papers on Omega. The
gt; Omega Function seems most useful. Continue to scroll down for two other pdf
gt; files listed under Omega.
gt;
gt; Keating_An_introducti 07-Jan-2004 14:00 190K
gt; Keating_Asset_optimiz 07-Jan-2004 14:06 468K
gt; Keating_The_omega_fun 07-Jan-2004 14:08 568K
gt;
gt;
gt; quot;Jerry W. Lewisquot; wrote:
gt;
gt; gt; You need to provide more information. I cannot find anything in Current
gt; gt; Index to Statistics by anyone named Shadwick nor can I find anything by a
gt; gt; Keating that also has quot;Omegaquot; in the title or keywords. A search of the Duke
gt; gt; online phonebook also failed to find a Shadwick, and none of the three
gt; gt; Keatings seemed likely to be called quot;Conquot;.
gt; gt;
gt; gt; Jerry
gt; gt;
gt; gt; quot;macrohunterquot; wrote:
gt; gt;
gt; gt; gt; Con Keating and William Shadwick at Duke University wrote a paper, An
gt; gt; gt; Introduction to Omega, in which they describe Omega. It would be great if
gt; gt; gt; Excel added it to its statistical functions. In the meantime, does anyone
gt; gt; gt; know how to write the formula in excel?
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?
quot;Jerry W. Lewisquot; wrote:
gt; I see why I could not find anything. The authors are at a center in London,
gt; not at Duke University. The references suggest that this work has not yet
gt; been published in refereed journals, and the document is labeled quot;Not for
gt; Circulationquot;.
gt;
gt; For the Normal distribution, omega can be calculated as
gt;
gt; =((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)
gt; /((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)
gt;
gt; For other distributions, I suspect that numerical integration would be
gt; required, and I doubt that Microsoft will be interested until both of the
gt; following occur:
gt; - Use of this characteristic of a probability distribution becomes widespread
gt; - Microsoft has implemented better algorithms to calculate the probability
gt; distributions that they have.
gt;
gt; Jerry
gt;
gt; quot;macrohunterquot; wrote:
gt;
gt; gt; Thanks. This paper and others on Omega can be found at
gt; gt; faculty.fuqua.duke.edu/~charv...ng/BA453_2006/
gt; gt;
gt; gt; Scroll down to Keating, and you can see some of his papers on Omega. The
gt; gt; Omega Function seems most useful. Continue to scroll down for two other pdf
gt; gt; files listed under Omega.
gt; gt;
gt; gt; Keating_An_introducti 07-Jan-2004 14:00 190K
gt; gt; Keating_Asset_optimiz 07-Jan-2004 14:06 468K
gt; gt; Keating_The_omega_fun 07-Jan-2004 14:08 568K
gt; gt;
gt; gt;
gt; gt; quot;Jerry W. Lewisquot; wrote:
gt; gt;
gt; gt; gt; You need to provide more information. I cannot find anything in Current
gt; gt; gt; Index to Statistics by anyone named Shadwick nor can I find anything by a
gt; gt; gt; Keating that also has quot;Omegaquot; in the title or keywords. A search of the Duke
gt; gt; gt; online phonebook also failed to find a Shadwick, and none of the three
gt; gt; gt; Keatings seemed likely to be called quot;Conquot;.
gt; gt; gt;
gt; gt; gt; Jerry
gt; gt; gt;
gt; gt; gt; quot;macrohunterquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Con Keating and William Shadwick at Duke University wrote a paper, An
gt; gt; gt; gt; Introduction to Omega, in which they describe Omega. It would be great if
gt; gt; gt; gt; Excel added it to its statistical functions. In the meantime, does anyone
gt; gt; gt; gt; know how to write the formula in excel?
The paper you cited only defines omega in terms of integrals of theoretical
cdf's (cumulative distribution functions). Their example with financial data
is incompletely described. It is not clear whether they are
1. assuming some (unspecified) parent distribution whose parameters they
are estimating from the data
2. extending their formula #3 to involve sums of empirical distribution
functions
3. something else entirely, such as using an Edgeworth expansion to
approximate the cdf with cumulants estimated from the data
The formula I provided is specifically for the normal distribution. At the
time that they wrote their paper, Cascon et al stated that quot;The question of
the omega-characterization of the normal distribution is a natural one, to
which we do not as yet have a satisfactory answer. If that is still true,
where should I publish the closed form formula that I derived?
Jerry
quot;macrohunterquot; wrote:
gt; Thanks. Omega is gaining popularity in the alternative asset management
gt; world where returns are not normally distributed. To confirm, the formula
gt; below only works on normally distributed returns? I'm also wondering where
gt; in the formula I put in the cell ranges that contain the data?
gt;
gt; quot;Jerry W. Lewisquot; wrote:
gt;
gt; gt; I see why I could not find anything. The authors are at a center in London,
gt; gt; not at Duke University. The references suggest that this work has not yet
gt; gt; been published in refereed journals, and the document is labeled quot;Not for
gt; gt; Circulationquot;.
gt; gt;
gt; gt; For the Normal distribution, omega can be calculated as
gt; gt;
gt; gt; =((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)
gt; gt; /((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)
gt; gt;
gt; gt; For other distributions, I suspect that numerical integration would be
gt; gt; required, and I doubt that Microsoft will be interested until both of the
gt; gt; following occur:
gt; gt; - Use of this characteristic of a probability distribution becomes widespread
gt; gt; - Microsoft has implemented better algorithms to calculate the probability
gt; gt; distributions that they have.
gt; gt;
gt; gt; Jerry
gt; gt;
gt; gt; quot;macrohunterquot; wrote:
gt; gt;
gt; gt; gt; Thanks. This paper and others on Omega can be found at
gt; gt; gt; faculty.fuqua.duke.edu/~charv...ng/BA453_2006/
gt; gt; gt;
gt; gt; gt; Scroll down to Keating, and you can see some of his papers on Omega. The
gt; gt; gt; Omega Function seems most useful. Continue to scroll down for two other pdf
gt; gt; gt; files listed under Omega.
gt; gt; gt;
gt; gt; gt; Keating_An_introducti 07-Jan-2004 14:00 190K
gt; gt; gt; Keating_Asset_optimiz 07-Jan-2004 14:06 468K
gt; gt; gt; Keating_The_omega_fun 07-Jan-2004 14:08 568K
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Jerry W. Lewisquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You need to provide more information. I cannot find anything in Current
gt; gt; gt; gt; Index to Statistics by anyone named Shadwick nor can I find anything by a
gt; gt; gt; gt; Keating that also has quot;Omegaquot; in the title or keywords. A search of the Duke
gt; gt; gt; gt; online phonebook also failed to find a Shadwick, and none of the three
gt; gt; gt; gt; Keatings seemed likely to be called quot;Conquot;.
gt; gt; gt; gt;
gt; gt; gt; gt; Jerry
gt; gt; gt; gt;
gt; gt; gt; gt; quot;macrohunterquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Con Keating and William Shadwick at Duke University wrote a paper, An
gt; gt; gt; gt; gt; Introduction to Omega, in which they describe Omega. It would be great if
gt; gt; gt; gt; gt; Excel added it to its statistical functions. In the meantime, does anyone
gt; gt; gt; gt; gt; know how to write the formula in excel?
H Jerry,
The data we would use would be a series of monthly or daily returns.
Usually I receive these on an excel spreadsheet. For example, the dates in
column A and the corresponding returns in column B. The question is how do I
put this data in to the Omega formula you wrote.
Thanks.
quot;Jerry W. Lewisquot; wrote:
gt; The paper you cited only defines omega in terms of integrals of theoretical
gt; cdf's (cumulative distribution functions). Their example with financial data
gt; is incompletely described. It is not clear whether they are
gt; 1. assuming some (unspecified) parent distribution whose parameters they
gt; are estimating from the data
gt; 2. extending their formula #3 to involve sums of empirical distribution
gt; functions
gt; 3. something else entirely, such as using an Edgeworth expansion to
gt; approximate the cdf with cumulants estimated from the data
gt;
gt; The formula I provided is specifically for the normal distribution. At the
gt; time that they wrote their paper, Cascon et al stated that quot;The question of
gt; the omega-characterization of the normal distribution is a natural one, to
gt; which we do not as yet have a satisfactory answer. If that is still true,
gt; where should I publish the closed form formula that I derived?
gt;
gt; Jerry
gt;
gt; quot;macrohunterquot; wrote:
gt;
gt; gt; Thanks. Omega is gaining popularity in the alternative asset management
gt; gt; world where returns are not normally distributed. To confirm, the formula
gt; gt; below only works on normally distributed returns? I'm also wondering where
gt; gt; in the formula I put in the cell ranges that contain the data?
gt; gt;
gt; gt; quot;Jerry W. Lewisquot; wrote:
gt; gt;
gt; gt; gt; I see why I could not find anything. The authors are at a center in London,
gt; gt; gt; not at Duke University. The references suggest that this work has not yet
gt; gt; gt; been published in refereed journals, and the document is labeled quot;Not for
gt; gt; gt; Circulationquot;.
gt; gt; gt;
gt; gt; gt; For the Normal distribution, omega can be calculated as
gt; gt; gt;
gt; gt; gt; =((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)
gt; gt; gt; /((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)
gt; gt; gt;
gt; gt; gt; For other distributions, I suspect that numerical integration would be
gt; gt; gt; required, and I doubt that Microsoft will be interested until both of the
gt; gt; gt; following occur:
gt; gt; gt; - Use of this characteristic of a probability distribution becomes widespread
gt; gt; gt; - Microsoft has implemented better algorithms to calculate the probability
gt; gt; gt; distributions that they have.
gt; gt; gt;
gt; gt; gt; Jerry
gt; gt; gt;
gt; gt; gt; quot;macrohunterquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Thanks. This paper and others on Omega can be found at
gt; gt; gt; gt; faculty.fuqua.duke.edu/~charv...ng/BA453_2006/
gt; gt; gt; gt;
gt; gt; gt; gt; Scroll down to Keating, and you can see some of his papers on Omega. The
gt; gt; gt; gt; Omega Function seems most useful. Continue to scroll down for two other pdf
gt; gt; gt; gt; files listed under Omega.
gt; gt; gt; gt;
gt; gt; gt; gt; Keating_An_introducti 07-Jan-2004 14:00 190K
gt; gt; gt; gt; Keating_Asset_optimiz 07-Jan-2004 14:06 468K
gt; gt; gt; gt; Keating_The_omega_fun 07-Jan-2004 14:08 568K
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Jerry W. Lewisquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; You need to provide more information. I cannot find anything in Current
gt; gt; gt; gt; gt; Index to Statistics by anyone named Shadwick nor can I find anything by a
gt; gt; gt; gt; gt; Keating that also has quot;Omegaquot; in the title or keywords. A search of the Duke
gt; gt; gt; gt; gt; online phonebook also failed to find a Shadwick, and none of the three
gt; gt; gt; gt; gt; Keatings seemed likely to be called quot;Conquot;.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Jerry
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;macrohunterquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Con Keating and William Shadwick at Duke University wrote a paper, An
gt; gt; gt; gt; gt; gt; Introduction to Omega, in which they describe Omega. It would be great if
gt; gt; gt; gt; gt; gt; Excel added it to its statistical functions. In the meantime, does anyone
gt; gt; gt; gt; gt; gt; know how to write the formula in excel?
留言列表
