Calculating a Market-Cap- or Index-Weighted Sector Dividend Yield

Summary

The document asks what data are needed to calculate a sector’s dividend yield from company-level cash dividends and security identifiers. The answer says to obtain each company’s spot price first, so a yield can be calculated for each constituent. It then describes two ways to aggregate those yields: weight companies according to their shares of the sector index, or use company market capitalizations as relative weights.

This is a brief practical pointer rather than a worked formula or a full methodology. It does not specify how to define the dividend amount over a particular period, how to handle special dividends or missing prices, or whether the desired sector measure should be index-weighted or market-cap-weighted. Those choices matter because the resulting aggregate depends on the constituent universe, the dividend convention, and the weighting scheme. The key takeaway is that cash dividends and security codes alone are insufficient; prices and a consistent set of constituent weights are also needed.

Key ideas

• Company-level dividend yields require both dividend amounts and share prices.
• A sector yield can be aggregated using constituent weights from a sector index.
• Market capitalization can instead serve as the basis for relative constituent weights.
• The result depends on the chosen weighting scheme and on consistent dividend and price data.

Tags

# Calculating the diviend yield for a sector?


# Calculating the diviend yield for a sector?












I have the cash dividend amount for each company and its sec code, how would i go about calculating the dividend yield of the sector?

What other data would I need?

## Answer by mbison (score 1)

https://quant.stackexchange.com/a/43050

you would need the spot price of each of the companies (cause then you can calculate the yield).

next you would probably need the index weights of each of the companies with respect to its sector weight.

or alternatively you would need the marketcap of the company if you would want to weigh it relative to market cap size.

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.