I find these exercises quite insightful and certainly worth the effort. Comparing my portfolio to the virtual portfolio is informative, as it helps me to identify candidate stocks for analysis and possible investment.
The June edition of the top 50 holdings of dividend ETFs has Exxon Mobil (XOM) repeating as the highest-ranked stock, while Microsoft (MSFT) and Apple (AAPL) replaced Procter & Gamble (PG) and Johnson & Johnson (JNJ) in the #2 and #3 slots, respectively.
To compile the virtual portfolio, I collect data from established Dividend ETFs and compile a spreadsheet with tickers of the top 25 holdings in each ETF, along with the market value of each holding.
To rank the top holdings, I use the relative market value of each holding to score the corresponding ticker. This proportional scoring system favors larger investments over smaller investments within the same ETF.
Next, I assign weights to each ETF based on total assets under management. Rather than doing so proportionally, I use a log-based formula so as not to overweight larger ETFs.
With proportional scores assigned to each ticker per ETF and weights assigned to each ETF, I simply calculate a weighted sum to get an aggregate score for each ticker.
Sorting the aggregate scores in descending order determines the rank of each ticker.
To see the top 50 holdings of dividend ETFs for June 2018, please read this article at Seeking Alpha.
Thanks for reading! Let me know how your portfolio compares to
the Top 50 Holdings of Dividend ETFs by commenting below.
the Top 50 Holdings of Dividend ETFs by commenting below.
No comments :
Post a Comment
Please don't include links in comments. I will mark such comments as spam and the comment won't be published. To make me aware of your blog or website, comment on my Blogrole page instead.