Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Dividend Yield average 5 yrs

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