Offer your thoughts or opinion on the input financial query or topic using your financial background.

Quandl financial data : unexpected dividend 
For MCD, the 47¢ is a regular dividend on preferred stock (see SEC filing here). Common stock holders are not eligible for this amount, so you need to exclude this amount. For KMB, there was a spin-off of Halyard Health. From their IR page on the spin-off: Kimberly-Clark will distribute one share of Halyard common stock for   every eight shares of Kimberly-Clark common stock you own as of the   close of business on the record date. The deal closed on 2014-11-03. At the time HYH was worth $37.97 per share, so with a 1:8 ratio this is worth about $4.75. Assuming you were able to sell your HYH shares at this price, the "dividend" in the data is something you want to keep. With all the different types of corporate actions, this data is extremely hard to keep clean. It looks like the Quandl source is lacking here, so you may need to consider looking at other vendors.