I'm using free Quandl financial data to reproduce a view of S&P 500 Dividend Aristocrats. What is important for me is not the result (we can get the list on the internet for free) but I'd like to do this by myself and make sure I understand the methodology.
Quandl data is pretty good, but there is some unexpected dividends I don't know how to explain.
For example :
- Mac Donald's (
MCD) has a dividend of 22¢ on 2000-11-13 and 23¢ on 2001-11-13, which is true and in the Quandl data. But in there we also find a dividend of 47¢ on 2000-09-13.
- Kimberly Clark (
KMB) usually has 4 dividends a year (less than $1). But on 2014-11-03, there is an additional super-high dividend (4.77$).
So my questions are :
- Can we explain this phenomenon ? Is the data legit ?
- Is there a data source I could use to find and remove these extra dividends ?