Hi all
Would anyone have a suggestion on how to rank stocks in the Q500US universe based on the average dividend yield for the past 5 years?
Morningstar fundamentals have the dividend_yield field, but how would you take the average of 5 years, keeping in mind that different companies will pay dividends at different dates and different frequency?
Thanks
M